Search results: Db2 for z/OS

Showing 292

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.

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

64 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 3 years ago in Db2 for z/OS 5 Not under consideration

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

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

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

24 VOTE

Implicit Tablespaces for conversion of multi-table tablespaces to UTS PBG

When converting multi-table tablespaces to universal tablespaces with new command ALTER TABLESPACE MOVE TABLE you need to create a new tablespace for each table explicitely before you can use the command. It would be very nice if the ALTER TABLESP...

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

38 VOTE

Improvements in online DDL changes - DBD design

Our company uses DB2 zOS almost exclusively for dynamic SQL workloads. Our management expects that DB2 zOS also has high availability regarding DDL changes in this application szenario. If you intend to perform DDL changes in this environment duri...

over 5 years ago in Db2 for z/OS 15 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...

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

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

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

21 VOTE

TABLESPACE LOGGED NO-integrity available even Rollback

We wonder a new type LOGGED tablespace attribute, similar to LOGGED NO but without any consequences at Rollback processes. Currently TABLESPACE LOGGED NO doesn´t log Row changes, but: TS change to Icopy state at first Row change TS change to RecPe...

over 3 years ago in Db2 for z/OS 0 Not under consideration

47 VOTE

Improve performance of EXPLAIN

With early versions of DB2 the performance of EXPLAIN was not relevant. Nowadays, where DBAs do thousands of EXPLAINs, the performance and turnaround is getting critical. I think there is room for better performance and throughput of mass EXPLAINs...

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

Please enter your email address

FILTER BY CATEGORY