Db2 for z/OS

Showing 773

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...

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

2 VOTE

Create a new BiF to do a real TIMESTAMPDIFF

The current scalar function TIMESTAMPDIFF is great if the difference is not over one month, then it starts guessing at how many days are involved. If you want to know the number of seconds between two timestamps it gives variously bad degrees of e...

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

6 VOTE

Allow a join of a temporal table with an archive-enabled table.

Allowing us to join a temporal table with an archive-enabled table would allow us to take advantage of both features. As is we will have to choose one or the other.

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

1 VOTE

CANCEL THREAD Enhancement - to cancel threads by specifying a SCOPE(ssid)

This will help in cancelling of threads running in any of the LPARs in a Parallel Sysplex. Currently, DISPLAY THREAD supports SCOPE(GROUP). So, this would be a good feature to have. These can be very useful during IPLs when some thread is holding ...

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

2 VOTE

Add timestamp to all -DISPLAY command outputs

More and more companies are using multiple DISPLAY commands to track for problems or usage statistics etc. The problem is that the TIMESTAMP when the command was issued is not in the output (apart from DISPLAY BLOCKERS) It would be really good to ...

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

4 VOTE

Sorting large amounts of data sequentially

We executed a query where a large amount of data had to be sorted. The execution stopped with SQLCODE -904 (temp. storage exceeded). This query was executed with DEGREE 1. When we executed the same query with DEGREE ANY, the query was executed by ...

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

2 VOTE

REPORT RECOVERY - new syntax requested to externalise just the image copy and log datasets

REPORT RECOVERY provides the CURRENT and SUMMARY keywords but even for these options the job output is either very verbose (Unit of Recovery, SYSCOPY entries, Archive log datasets, volume numbers for the LOG datasets etc) or too little (just the v...

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

2 VOTE

High CPU utilisation in CF structure xxxx_SCA

We have noticed that the structure DB2P_SCA in production the reason for high CPU consumption in the Coupling Facility is. Our reporting proofs this behaviour. We opened a case and did a deeper dive with IBM’s experts into. At the end we can say t...

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

2 VOTE

Register all dependencies in SYSPACKDEP

Today SYSPACKDEP records the dependencies of packages - but not dependencies related to RI. That means that a user or a tool needs to run additional queries to understand all dependencies to e.g. answer the question: which packages do I need to RE...

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

1 VOTE

Add flag field to IFCID 402 to indicate when a reset has occurred.

In Db2 Version 13 and V12 (with APAR PH50729), Db2 resets IFCID 402 statistic counters immediately if the warning or exception threshold for the associated profiles is changed when you issue a START PROFILE command. It’s difficult to tell if the c...

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

Please enter your email address

FILTER BY CATEGORY