Db2 for z/OS

Showing 975 of 15368

New ZPARM for SYSTIMESENSITIVE Bind Option

Please reference CASE TS005056787 ( Temporal Table access path in Plan_Table does not match dynamic explain). This bind option which is set for using a Temporal Timestamp Register was set with a DEFAULT to YES by IBM for all binds that exclude thi...

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

10 VOTE

new fixcat categories in maintenance stream

We would like to have new fixcat categories for security and performance. Currently this is a manual process that is labor intensive and in some cases time prohibitive. New security policies require that we identify fixes that are security or perf...

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

6 VOTE

Allow ALTER TABLE ... ROTATE for ARCHIVE TABLES (Type 'R')

We have archive tables to retain old data for up to 8 years using transparent archiving. When we try and Rotate these tables we get SQLCODE -20525: ALTER TABLE DBO.SECURITYLOG_$ARC ROTATE PARTITION FIRST TO LAST ENDING AT ('2020-11-30-23.59.59...

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

14 VOTE

Alter-support for global variables

With DB2 V11 global variables were introduced, but unfortunately no alter-option to change the default. This would be especially beneficial it this enhancement would also include the system-provided global variables. With this enhancement each cus...

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

6 VOTE

New Db2 REST Service Discovery Authority

Since a security loophole was closed it is now only possible to discover REST services via the Db2 supplied Db2ServiceManager API that the user has authority to execute. We feel this goes against the open API economy that we are currently in, wher...

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

9 VOTE

Lock Escalation Action zParm for Pre-Escalation

A new zParm that would enable feature in DB2 to: 1) detect request for LOCK ESCALATION2) lookup thread characteristics/criteria in control 'table'3) take action (coded in 'table') based on entry in control 'table', OR take a default action (i.e. d...

over 6 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

1 VOTE

Db2: Recovery of Mainframe Db2 databases without applying changes.

When the DB2 is performing a recover it uses log and copy files, it may be some sitations where the log contains changes that we dont want to restore. For exemple we may have inserts made by an authorized program and also updates performed by an u...

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

8 VOTE

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

Please enter your email address

FILTER BY CATEGORY