Db2 for z/OS

Showing 814

Eliminate x-locks on CREATE INDEX DEFER YES to improve concurrency

This is similar to DB24ZOS-I-1114 and DB24ZOS-I-1689. When attempting to create an index with CREATE INDEX DEFER YES, there should be no need to lock packages that are dependent on the table. Requiring an x-lock doesn't seem necessary. With phase-...

8 days ago in Db2 for z/OS 1 Not under consideration

10 VOTE

Provide one Db2 message to indicate that GRECP and LPL recovery is complete across a Db2 data sharing group.

We use automation to drive our disaster recovery processes to reduce the recovery time and remove human interaction. We have been running into issues with starting software products that require access to Db2 before it has completed GRECP and LPL ...

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

39 VOTE

In a UTS world shouldn't DSNUCH01 include DSNUM as 3rd column for this SYSCOPY's index?

In a UTS world shouldn't DSNUCH01 include DSNUM as 3rd column for the SYSCOPY's index?, since DB2 v12 all tablespaces should be defined as Universal Table Space, PBR or PBG. Segmented and Simple tablespaces are deprecated.

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

6 VOTE

Support for CREATE INDEX DEFER YES DEFINE NO would be very usefull for Spaces with a 'high' number of partitions to avoid timeouts on SYSTSTAB.

When using "CREATE INDEX DEFER YES DEFINE NO", "DEFINE NO" is ignored with SQLCODE 20122 and the VSAM Clusters are created anyway. Doing this for a partitioned index on a partitioned table with lots of partitions (400+) the runtime of CREATE INDEX...

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

2 VOTE

Enhance Db2 System profiles to allow exceptions

System profiles are being used to control applcompat levels for distributed connections. This is being done by trapping on the default db2 driver COLLECTION NULLID then setting the attributes to another collection using a higher applcompat. This w...

25 days ago in Db2 for z/OS 0 Not under consideration

3 VOTE

Allow application to decide what to do when a timeout occurs (-911 vs. -913)

In time-critical processes, it can be important to be able to react to timeout conditions in Db2. In Db2 V13, there is new functionality that allows an application to override the default timeout setting (the CURRENT LOCK TIMEOUT special register)...

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

8 VOTE

Make IFI process zIIP eligible

With more and more data being replicated off host, the replication tasks are increasingly using more and more CPU to read the logs. Allowing the IFI read process to be zIIP eligible would help reduce our general purpose CPU consumption. This would...

4 months ago in Db2 for z/OS 3 Not under consideration

24 VOTE

Db2 native and RACF security consistency requirement

This is especially important for shops like ours where for years DB2 native security and migrate to RACF security to be complaint with security audit and policies, and also new mainframe applications standards. There is multiple areas where curren...

about 1 year ago in Db2 for z/OS 2 Not under consideration

59 VOTE

Allow us to use the profile tables to set the ACCUMACC zparm more granular

At the present time we have ACCUMACC set to 20. We have had to set this to 1 for problem determination purposes. In our active system it causes issues with our SMF jobs when we have done this for even a short time. We would like the ability to use...

about 3 years ago in Db2 for z/OS 5 Not under consideration

16 VOTE

When DSNL077I tells us IN-USE DBAT is exceeding 85% of MAXDBAT then ALSO issue DISPLAY THREAD

DB2 has recently introduced message DSNL077I which tells us when IN-USE DBATS begin to exceed 85% of system parameter MAXDBAT. And the corresponding message of DSNL078I tells us when IN-USE DBATS falls below 75% of MAXDBAT https://www.ibm.com/docs...

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

Please enter your email address

FILTER BY CATEGORY