Db2

Showing 1400

Support converting non-restricted databases to restricted databases in Db2

There can be legacy databases created with non-restricted mode. However as security policies get stringent there is need to convert these databases into restricted databases. The way to convert currently is to recreate the database from scratch. I...

over 3 years ago in Db2 / Configuration Parameters 0 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

2 VOTE

Support for UR requested with column organized tables

Actually we're preparing a new Warehouse on DB2 BLU 11.5.5 on AIX using column organized tables. In an early technical examination we found, that concurrent access under isolation level UR ( reporting application ) and updating the same rows will ...

over 3 years ago in Db2 0 Future consideration

3 VOTE

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

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

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

Please enter your email address

FILTER BY CATEGORY