Db2 for z/OS

Showing 793

Track SHRLEVEL info in Utilities history

In Db2 13 utility execution can be recorded in one or two utilities history tables. We are struggling to find all utility executions ran with SHRLEVEL NONE to tell the applications to change their parameters to avoid problems. It is very hard to f...

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

6 VOTE

Configure a user-defined value for disabling all IFI request and MONITOR trace processing after a number of abends

When a certain number of abends occurs, while processing IFI requests, processing of all IFI request and MONITOR trace is disabled, requiring an action from Db2 operator/system administrator to be resumed. Today this number of abends, that disable...

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

13 VOTE

Db2 z/OS limitations with ALTER TABLESPACE MOVE TABLE

I love the upcoming FL508 and this new availability even though I have not used it. Looking deeper into the Knowledge Center there seems to be some limitations that I would like to see resolved. The two items are: a) Exist in the same data...

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

3 VOTE

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

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

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

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

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

Please enter your email address

FILTER BY CATEGORY