Db2 for z/OS

Showing 798

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.

9 months ago in Db2 for z/OS 1 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...

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

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

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

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

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

9 VOTE

ALTER TABLE DROP multiple COLUMNs

If you want do delete multiple columns of a table using "ALTER TABLE tbname DROP COLUMN colname", you currently have to execute many ALTER TABLE statements. The execution time increases exponentially with the number of columns to be deleted. If th...

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

13 VOTE

Allow alter column to drop NOT NULL constraint

Currently the only way to remove the NOT NULL constraint from a column is to unload the table, drop-recreate table (or drop-add column) and reload table. Such a small change needs so much effort, and causes unnecessary outage and service disruptio...

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

6 VOTE

When DB2 writes a message to the DB2 Log, DB2 could also optionally write the contents of the message to a new IBM Catalog Table SYSIBM.DB2_Messages or a user defined table.

WHY THIS IS A GOOD IDEA Many of our DB2 subsystems and members remain active for several months or more. Searching for a DB2 Message can take a long time in SDSF when analysing and diagnosing problems. Having all of the DB2 Messages in a Table mak...

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

61 VOTE

Stop package invalidation after ALTER MAXPARTITIONS

These days in an agile world we have to ALTER PBG spaces on-the-fly to raise the MAXPARTITIONS value. Sadly this ALTER, even though it is an immediate ALTER, sets all dependent packages to VALID = 'N' which is, of course, a disaster.

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

6 VOTE

Extend Db2 Message monitoring IFCID 197 to include information about message tokens

Our shop is using ITM Situation management to heavily automate processing/notification for our customers and thus minimize the use of custom logic to be maintained (specific REXX programs etc.) . One feature that we leverage is the OMEGAMON for Db...

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

11 VOTE

Externalize non-DSC SQL in IFCID 316

An old request that got rejected but is for me, and at least 52 other voters, important was the IFI 316 for non-DSC eligible Dynamic SQLs. The business case here has two major reasons: First and most important these days – Audit. Any Dynamic SQL m...

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

Please enter your email address

FILTER BY CATEGORY