Db2 for z/OS

Showing 979 of 15452

DB2 does not use a FlashCopy (Imagecopy) that has been migrated by DFHSM.

DB2 does not use a FlashCopy (Imagecopy) that has been migrated by DFHSM so we have check for this in RECOVER, which is a potential case for error/mishandling. DB2 should do a recall of recall of a migrated Flashcopy/Imagecopy as with all other s...

over 5 years ago in Db2 for z/OS 11 Not under consideration

11 VOTE

Enable 'Temporal' for DB2 catalog object tables granular and optional

V12R1M500 enables to optionally activate/deactivate 'Temporal RTS tables'. Please provide to optionally and granular activate/deactivate 'Temporal catalog objects tables' as e.g. SYSTABLES, SYSVIEWS, SYSCOLUMNS, ... We know that temporal for catal...

over 7 years ago in Db2 for z/OS 1 Not under consideration

3 VOTE

sqlcode -803 INSERT precheck

Looking at DB2 log when a SQLCODE -803 duplicate key condition occurs in an INSERT often leads to a rollback of the change already made to the tablespace and/or in the non unique indexes defined against the affected table. Would it be possible to ...

about 2 years ago in Db2 for z/OS 1 Not under consideration

9 VOTE

Wrong result from reading Business Temporal Tables with CURRENT TEMPORAL BUSINESS_TIME set to a non-NULL value

When reading Business Temporal Tables we set a value for the special register CURRENT TEMPORAL BUSINESS_TIME in order to get the appropriate result. If it is NULL all rows are read. If it is not NULL only rows for the specified timestamp should be...

over 6 years ago in Db2 for z/OS 1 Not under consideration

9 VOTE

optimiser to consider workfile size to determine to use a sort operation

Hi, were coping with a -904 00C90084 or 00C90085 DSNDB07 during a simple left outer join. Apparently the optimiser is not smart enough to determine wether or not to use a sort operation because his lack of knowledge about the sort work file alloca...

over 6 years ago in Db2 for z/OS 2 Not under consideration

5 VOTE

REORG TABLESPACE WHERE LIMITKEY BETWEEN X and Y

With the ADD PART and ROTATE, the logical and physical partitions on a tablespace can be out of ORDER. Current REORG at PART Level is for physical partitions, and requires DBA to search catalog to find all required PARTS.

over 3 years ago in Db2 for z/OS 1 Not under consideration

14 VOTE

DB2 Support for imbedded SQL comments in DBRMs and SYSIBM.SYSPACKSTMT

Full support of imbedded SQL comments in DB2 DBRMs and SYSIBM.SYSPACKSTMT

almost 10 years ago in Db2 for z/OS 0 Not under consideration

15 VOTE

Provide a new bind-option to provide values for the remark-column in SYSPACKAGE

There were several discussions regarding APPLCOMPAT and providing a value that a customer can easily see that a package was bound a level down. This request was refused by DB2 development, but another solution was acceptable. A new bind option can...

almost 11 years ago in Db2 for z/OS 1 Not under consideration

2 VOTE

Allow DB2 to Insert more than 32KB data into a CLOB column

SQL Server Management Studio, Toad for Oracle allow inserts with more than 32 KB column size but DB2 doesn't allow the same and this is a show stopper for few projects to come into DB2 ZoS as data fixes by application team is not possible in produ...

over 1 year ago in Db2 for z/OS 3 Not under consideration

2 VOTE

Provide incremental progress messages through a DB2 group restart

During a recent DR activity our Db2 had issues during group recovery and it was challenging to determine at what point Db2 had gone as far as it could before requiring the other member to be restarted to resolve any locks RC00C200EB . The MSTR log...

over 1 year ago in Db2 for z/OS 1 Future consideration

Please enter your email address

FILTER BY CATEGORY