Db2 for z/OS

Showing 787

Enhancement ALTER of STOGROUP to be NO-DISRUPTIVE change.

As we all know to perform an ALTER DB.TS/IX USING STOGROUP XXXXX a STOP/ALTER/START process is required which is a DISRUPTIVE change. So, looking for an enhancement on that ALTER process maybe it could be "improved" by putting the involved Db2 obj...

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

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

48 VOTE

Command confirmation in joblog of DB2MSTR.

DB2 has many commands which display or alter the status of something. There are a lot of distinct environments from which the commands can be executed (z/OS console, DSN session, TSO DSN command processor, IMS or CICS terminal, special STPs, IFI-i...

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

27 VOTE

IFCID 316 401 ZiiP Usage Statistics

Currently the IFCIDs 316 and 401 contains great data for monitoring and tuning SQLs. It would be excellent if these IFCIDs could be extended to include a separate set of ZiiP counters. IFCID 25 does this for Utilities at the moment.

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

3 VOTE

Identify when all members of a Data Sharing Group are up and operational

After a crash or hard down, Db2 will perform its recovery processing including GRECP and LPL processing. There are external systems (e.g. CICS, MQ, etc.) that are dependent on all members in the data-sharing group to be fully up and operational an...

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

20 VOTE

Avoid Reorg Abends by improving estimation of average row length

Today, for estimating the average row length being passed to sort, REORG gets that from catalog statistics with either AVGROWLEN or COMPRESSRATIO. The reason RTS stats is not used, is because RTS only contains the compressed data size.

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

1 VOTE

CREATE TABLE LIKE "table-controlled partitioning" should create the table with same partitioning scheme and rules

When a table that uses table-controlled partitioning is identified in the LIKE clause, the new table should automatic inherit the partitioning scheme of that table and create an uts PBR.

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

9 VOTE

Modify the DSNJU003 utility to allow it to define anything stored in the Db2 BSDS

When creating and new Db2 member, we must bring it all the way up before we can create the bufferpools, size them, and set the thresholds. We would like the ability to defined them prior to starting the Db2 member/subsystem. When creating an alias...

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

47 VOTE

A View with Select * should be regenertated without Drop/Create View

We have a lot of views defined with Select *. Since DB2 V8 we have the option to add columns to the base table, but the view does not include the new column, which is ok and accepted. But to get the new column we have to drop and recreate the View...

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

5 VOTE

DB2 for zOS correlated column behavior

Problem statement - unqualified column name interpreted as correlated reference. As per example below: DELETE FROM SYSADM.T1 WHERE COL3 IN (SELECT COL3 FROM SYSADM.T2)--> DSNT404I SQLCODE = 012, WARNING: THE UNQUALIFIED COLUMN NAME COL3 WAS INT...

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

Please enter your email address

FILTER BY CATEGORY