Db2

Showing 989

Reduce Time Required for Online(Inplace) Reorg for huge tables

1) Inplace reorg will take time more for the tables with huge data say for example 1 TB 2) To Reduce the time for this we want to avoid full table scan hence we need to look in portions of the data in a table where it is getting fragmented 3) Henc...

over 4 years ago in Db2 / Tables/Index (Range MQ MDC etc.) 21 Not under consideration

101 VOTE

Method for downgrading FixPack level of Db2 pureScale

In order to downgrade FP level of pureScale, uninstall the product, re-install and recovery from backup are needed.This is time consuming and cannot be done online.Customer want some easy FP fallback method.Most customer plan to FP upgrade with so...

over 6 years ago in Db2 / Installation & Upgrade 1 Not under consideration

73 VOTE

Getting the Accessplans at the Routine level for the Database LUW

Db2 performance issues in one of the major area to look for, Whenever there is performance issue in the database, one of the major point we look is for the queries how they are behaving in the database. Db2 LUW provides lot of options to get the ...

over 4 years ago in Db2 / Monitoring 29 Not under consideration

62 VOTE

Since customers' environment needs to stay updated please make the Db2 11.5.9.0 pureScale for AIX 7.3 TL01 and TL02 certified for Power System 10. We just certified the "AIX 7.3 TL00 SP1 or higher".

It is useful to avoid security breach and avoid OS known bugs.

5 months ago in Db2 / pureScale 0 Not under consideration

58 VOTE

Decouple archive log purging from BACKUP utility

For databases using AUTO_DEL_REC_OBJ, at the end of the BACKUP utility there is a synchronous process which purges any history records and their associated archive logs. This can take a very long time on busy systems. It is necessary to decouple t...

over 6 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 1 Not under consideration

56 VOTE

Restore database to another Db2 server with different endianness

My customer is using RHEL Big Endian Linux on PPC and Db2 10.5 which is end of support April 30, 2020. They have no option but to migrate to RHEL Little Endian. They cannot simply backup and restore the database and are looking at using Db2move wh...

over 5 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 2 Not under consideration

51 VOTE

Please create current training material for Db2 administration

Please create basic training material for database administrators on Db2 that is easily consumable and free. A platform like EDx, Udemy, etc, would be ideal, but even on a proprietary platform would be acceptable.

over 5 years ago in Db2 / Other/Unknown 1 Not under consideration

49 VOTE

Allow CREATE/REPLACE for users other than owner

Currently on Db2 LUW CREATE OR REPLACE is only allowed for the owner of a database object. CREATE OR REPLACE authorization should be opened up to allow create/replace by anyone who has the ability to drop the object and to create the object with a...

over 5 years ago in Db2 / Statements (DDL and DML) 3 Not under consideration

48 VOTE

Restore of online backup taken with older Db2 version

Current product limitation don't allow to restore an online database backup that were taken with a older Db2 level than the on of the Db2 instance . Our production environement must be available on a 24x7 basis and this limitation is a serious lim...

about 6 years ago in Db2 / Backup/Restore/ Rollforward/ Recover / Installation & Upgrade 0 Not under consideration

46 VOTE

Provide a documented and supported procedure to generate ddl (db2look as SP - like db2lk_generate_ddl)

db2lk_generate_ddl is a stored procedure that provides functionality to generate DDL via SQL (similar to db2look which is a tool as db2llok cannot be executed througha SQL client tool. This function already exists but is not documented and I am no...

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

Please enter your email address

FILTER BY CATEGORY