Db2

Showing 1398

Default of for read only for all select statements

As you might have noticed, the "for read only" clause of the select statement in DB2 is not widely known nor used. Most standards select statements going through the DB2 engine have the risk of becoming an ambiguous cursor with sub-optimal perform...

over 5 years ago in Db2 / Application Development 1 Not under consideration

4 VOTE

TRY_CAST for DB2 LUW (CAST without error)

"New" scalar-function TRY_CASTReturns a value cast to the specified data type if the cast succeeds; otherwise, returns null.

over 7 years ago in Db2 / Application Development 0 Not under consideration

4 VOTE

DDL creation support thru implicit trusted connection

Trusted context is a very good security mecanism to promote a user from an application server to a specific role. We face 2 problems:- DDL issued from Siebel application server, when applying a change, fails for CREATE TABLE- If user has no direct...

over 7 years ago in Db2 / Security 0 Not under consideration

4 VOTE

DB2 V9.7

When doing the case sensitive search, the index on ALT_IDENTIFIER is used correctly, and the query takes around 0.2 seconds as expected. When doing the case insensitive search, the optimiser correctly uses the V_N1999152021 column rather than the ...

over 7 years ago in Db2 / Text Search 0 Not under consideration

5 VOTE

Use trusted logging with db2audit to protect audit data from instance users and root

On Aix there is a trusted logging which can be used by syslog and AIX auditing. It would be nice if db2 can use this as well to store its audit data. At the moment it is written to Audit Data Path. It would be nice if this can be a character mode ...

over 9 years ago in Db2 / Security 0 Not under consideration

2 VOTE

Add Container Management Software PodMan to Db2Rest API

Docker is not allowed in our environment. Podman is lighter. We are Openshift and Redhat so Podman fits better for us. Containers running in Docker should work with Podman with little or no changed.

almost 4 years ago in Db2 / NoSQL 0 Not under consideration

1 VOTE

DB2 z .

Hello, At the present time CP4D does not support certificate based authentication to DB2z for replication on DB2 open databases. We are forced to use a generic user with password which is not secure and not recommanded. Could you please develop th...

almost 2 years ago in Db2 0 Not under consideration

1 VOTE

let db2adutl work cross-dbpartition on one LPAR, as it did before

Before DB2 11.5.8.0.1 db2adutl could work on different dbpartitions on the same LPAR.Now it throws an error that input database partition number/current database partition number are different, if DB2NODE is not explicitly set.db2adutl should be a...

almost 2 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 3 Is a defect

2 VOTE

DB2_DMU_DEFAULT=IMPLICITLYHIDDENMISSING, if set at instance level then we should not need it to be specified again in import command just like 9.7 clients

We are facing an issue for version 11.1. FP5 where we are able to load the data into a table with a column in a table which has IMPLICITLY HIDDEN column, In the past we were able to run the import and not specified the column name and it has worke...

almost 4 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

2 VOTE

DB2Z-Allow for EXCHANGE DATA function on Clone table to NOT put packages in VALID status of 'A'

We have processes that use the clone table feature to allow for non disruptive load operations. When we do the exchange data the packages on the primary table move to a VALID STATUS of 'A' when they had a status of 'Y' previously. This creates iss...

almost 4 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY