Db2 for z/OS

Showing 975 of 15368

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

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

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

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

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

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

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

Please enter your email address

FILTER BY CATEGORY