Db2

Showing 1390

Skip REORG evaluation if offline maintenance window equal 1 or 2 hours

Reorg table can be run twice during offline maintenance window. This is not acceptable behavior because it can exhaust the window time on the same table. Secondly, it is also possible to put in queue the same REORG TABLE that will be run the next ...

almost 8 years ago in Db2 / Utilities (Export Import Load db2look etc) 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

5 VOTE

Add an ooption to export column names in the csv file

Add an option to the export utility to include the column names in the del file.

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

3 VOTE

ADMIN_MOVE_TABLE Allow implicit PACKAGE BIND by the application

ADMIN_MOVE_TABLE change to allow an implicit PACKAGE BIND by the application. Currently Db2 marks the PACKAGE (SYSCAT.PACKAGES) as inoperative by marking VALID = 'X' which requires an explicit bind. This causes an outage in a 24x7 environment. S...

almost 6 years ago in Db2 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

5 VOTE

DB2 to incorporate a feature equivalent to Oracles Flashback(RIMS)

We have an official request from executive management ((John Mikkelsen) for DB2 to incorporate a feature equivalent to Oracles Flashback. Eric Egdorf DB2 LUW Support Verizon Business 719-535-4289 Verizon recently had an outage that they feel coul...

almost 10 years ago in Db2 / Utilities (Export Import Load db2look etc) 1 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

5 VOTE

Encryption at tablespace level

Allow to encrypt at the tablespace level. Add the encrypt keyword in the create tablespace command

almost 10 years ago in Db2 / Security 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

5 VOTE

DB2 to add support for alter table without going on need for reorg immediately and allow full access (read,write,alter...etc)

After setting compatibility vector to ORA, we expect alter table to not affect read/write access. In our test, we see that after dropping even a single column, table goes in reorg_pending = Y status and we can not use reorg inplace to continue ins...

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

Please enter your email address

FILTER BY CATEGORY