Db2 for z/OS

Showing 984

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

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

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

16 VOTE

Online Constraint name renaming capability

MR0803067232 DBDB2D/S05008 Expand the ALTER-TABLEâ€“Statement with an RENAME-Clause or add a RENAME-CONSTRAINT-Statement which renames the constraint name online.

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

9 VOTE

Runstats use profile

Runstats should be able to deal always with the generated profile for the optimizer.Or, DB2 should generate only such profiles that can be successfully executed.

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

1 VOTE

Allow a Db2 z/OS Server to request clients set other JDBC Data Server Driver parameters, such as minTransportObjects or maxTransportObjects

In FL502 of Db2 13, IBM offers MODIFY DDF with the "RQSTWLB" option which allows the Db2 server to tell clients to enable Sysplex Workload Balancing (enableSysplexWLB=true) as long as the client doesn't explicitly set WLB to "false". It would be b...

9 months ago in Db2 for z/OS 2 Future consideration

Please enter your email address

FILTER BY CATEGORY