Db2 for z/OS

Showing 964 of 15033

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

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

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

9 VOTE

IRLM enhancement in case of global deadlock processing

We had a situation which was described in case TS015567644. The symptom was that IRLM could not fully process the complete deadlock stuff of all members of an 8-way DS system. Therefore we get DXR167E in some of the members. Additional workload wi...

4 months ago in Db2 for z/OS 0 Future consideration

15 VOTE

Way to tell if a Db2 view is not being used any longer

We are looking for a solution to tell if a Db2 view is still used or not.A request came to our team to rename a column in several tables. One of the tables have multiple view on it, and one of the view includes the column to be renamed. We cannot ...

7 months ago in Db2 for z/OS 4 Future consideration

32 VOTE

Db2Z INSERT with VALUES should allow multiple rows

Db2 LUW and many other RDMS allow one INSERT with VALUES to insert multiple rows at once. Db2 Z does not allow that syntax. Db2 Z INSERT with VALUES only allows one row at a time So if you have multiple rows you want to insert with the INSERT usin...

over 1 year ago in Db2 for z/OS 1 Planned for future release

56 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

4 VOTE

After PIT Recovery the RTS values are restored

Today some RTS statistics is lost after PIT Recovery. These statistics is necessary for other utilites like REORG, REBUILD or CHECK to calculate e.g. the correct SORTWKxx data set sizes. As we have very large objects, this behaviour lead to the co...

2 months ago in Db2 for z/OS 0 Under review

20 VOTE

Db2 profiles - Enable monitoring and enforcement of AUTHIDs

Db2 v13 offers new feature of Db2 profiles to support monitoring and enforcement of TLS secure connections. Please add ability to do this at AUTHID level. Some apps and users have converted and we could put in a profile to ensure only secure conne...

about 1 year ago in Db2 for z/OS 0 Planned for future release

43 VOTE

Indicate whether the fallback SPE for Db2 13 migration is installed

As a user planning to migrate to Db2 13 I already activated V12R1M510 on my Db2 12 subsystem. However, I also want to make sure that I have the fallback SPE PH37108 https://www.ibm.com/support/pages/apar/PH37108 installed. Could this information b...

about 2 years ago in Db2 for z/OS 5 Planned for future release

16 VOTE

Enhanced Instrumentation for workfiles

A possibility through IFI and/or a new command -DIS WORKFILES to get an “asis” use list of all work pools (Sort , DGTT, Work etc.) This data is crucial for tuning the number, size and type of the work spaces that we all have. The output should be ...

11 months ago in Db2 for z/OS 1 Future consideration

Please enter your email address

FILTER BY CATEGORY