Db2

Showing 1390 of 15598

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

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.

almost 10 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

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

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

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

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 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

3 VOTE

Can access federation object in the trigger body

The db2 instance have multiple database, and customer want to access a user table that locate in another database through Db2 trigger .

almost 6 years ago in Db2 / Federation 0 Not under consideration

4 VOTE

LOAD utility should allow huge loads to run with out blocking transactional log files

Please let me explain more about how i look at LOAD utility.LOAD utility is a way to write data into database quickly by ignoring the traditional route into the system, like query processing insert/update/delete.LOAD utility will by pass many perf...

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

Please enter your email address

FILTER BY CATEGORY