Db2 for z/OS

Showing 798

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

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

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

1 VOTE

CREATE TABLE LIKE "table-controlled partitioning" should create the table with same partitioning scheme and rules

When a table that uses table-controlled partitioning is identified in the LIKE clause, the new table should automatic inherit the partitioning scheme of that table and create an uts PBR.

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

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

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

6 VOTE

static SQL with DGTT and REOPT(ALWAYS) should be traced by IFCID 401

We realized that not all static SQLs are captured by DB2 to be put into IFI buffers (IFCID 401) I'm referring to static SQL related to packages bound with REOPT(ALWAYS) and DGTTs statements. For REOPT(ALWAYS) packages, only statements not affec...

over 4 years ago in Db2 for z/OS 2 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

Please enter your email address

FILTER BY CATEGORY