Db2 for z/OS

Showing 1023

Way to execute the ADMIN_INFO_SYSPARM without such elevated permissions

I have tried to grant some of my users to execute the ADMIN_INFO_SYSPARM, because I find that it could be useful to them, for example the Security people for getting information needed for External Audits. From my experience, you have to be SYSADM...

1 day ago in Db2 for z/OS 0 Under review

2 VOTE

Add DSNL523I or DSNL519I for all available PORTs

Currently at DB2 startup, or when DDF is started, a DSNL523I or DSNL519I message is issued for the main DB2 PORT, the main SECPORT, and RESORT. I would like the same to be done for all available LOCATION ALIAS PORTs so our automation can validate ...

2 days ago in Db2 for z/OS 0 Future consideration

1 VOTE

Allow for clear text NEWAUTHID in SYSIBM.USERNAMES

We use SYSPROC.DSNLEUSR to encrypt usernames and passwords that are stored in the DSNLEUSR table, The procedure encrypts both NEWAUTHID and PASSWORD. It becomes difficult to manage the SYSIBM.USERNAMES table as we cannot see the NEWAUTHID in clear...

4 days ago in Db2 for z/OS 0 Under review

1 VOTE

Reduce restrictions of ADD PARTITION

“ALTER TABLE ADD PARTITION” is not available when target table holds uncommitted(not materialized) definition change. In most cases “MAXVALUE” is selected as limit key value because Partitioned-Table of TABLE-CONTROL cannot hold data exceeded the ...

8 days ago in Db2 for z/OS 0 Under review

1 VOTE

Improve the flexibility of changing PARTITION key

When to change PARITITION keys in multiple PARTITIOIN, a validation routine to check the data consistency runs every time ALTER command (ALTER TABLE ALTER PARTITION) is executed. In most cases we change the key value for multiple PARTITION keys an...

8 days ago in Db2 for z/OS 0 Under review

1 VOTE

Preventing DBD Lock when changing PARTITION key

There’s a possibility that status becomes AREOR when PARTITION key in PBR is changed by “ALTER TABLE ALTER PARTITION”. We strongly request you to revise the function NOT to set DBD Lock at this moment. It’s hard to say that changing PARTITION key ...

8 days ago in Db2 for z/OS 0 Under review

1 VOTE

Prevent immediate reflection of PARTITION key changes

When changing partition key of PBR using ALTER TABLE ALTER PARTITION, it may take effect immediately without AREOR status under certain conditions, so please provide an option to allow PARTITION key changes to be reflected in the AREOR state upon ...

8 days ago in Db2 for z/OS 0 Under review

2 VOTE

IFCID 402 support for more than 50 unique user profiles like IFCID 365, 411 and 412

The critical issue is that IFCID 402 uniquely lacks the continuation flag essential for identifying continuation records within a single interval, a feature consistently present in other DDF-related IFCIDs (365, 411, 412). This omission significan...

10 days ago in Db2 for z/OS 0 Under review

1 VOTE

Add SCOPE(GROUP) for -DIS STATS(INDEXTRAVERSECOUNT)

Our shop has 13 LPARs for our Production environment & while trying to figure out the best way to combined all the different FTB FACTOR values for the individual IXs it was mentioned maybe a future feature of something along the lines of -DIS ...

14 days ago in Db2 for z/OS 0 Future consideration

1 VOTE

Trim blanks from 60 byte statement text in IFCID 316

IFCID 316 contains only the first 60 bytes of the SQL text. Some programs may, for readability, include lots of blank spaces around SQL text. In extreme cases (python scripts) the text is preceded by a line of blanks. In these cases the 60 bytes o...

14 days ago in Db2 for z/OS 0 Submitted

Please enter your email address

FILTER BY CATEGORY