Db2 for z/OS

Showing 975

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

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

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

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

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

1 VOTE

LOAD Replace improvement for RI tables

We had a Db2 DDL change where a new table "b" was created with a RI constraint to a parent table "a" which was also modified (DROP/CREATE). Table "a" had several rows which were unloaded before the change and loaded back after the DDL changes (LOA...

9 months ago in Db2 for z/OS 1 Not under consideration

2 VOTE

Ability to stop AOT and other db2 tables on IDAA

When we STOP or start for UT ,spaces of tables that are loaded to IDAA or spaces that relate to AOT's, these spaces are still available for the IDAA. We can SELECT data from the IDAA for these tables and for AOT's' we can also update them. We need...

over 1 year ago in Db2 for z/OS 1 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...

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

Please enter your email address

FILTER BY CATEGORY