Db2 for z/OS

Showing 965 of 15054

Remove some of the restrictions related to SQLCODE -20555

There is currently a restriction on the use of archive-enabled tables and temporal tables in one statement: The execution of this statement leads to SQLCODE -20555: SELECT * FROM DB2.LZTB0586 WHERE VNR IN ( SELECT VNR FROM DB2.LZTB0520) SQLERROR O...

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

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

7 VOTE

remove limitations in workfile database which leedsto outages

When a workfile is created Db2 increments obid, when a workfile ist dropped the obid is not released by Db2. There is a restriction of maximum 500 workfiles. When the limit has been reached, no more work files can be created, SQL code -497 is retu...

almost 2 years ago in Db2 for z/OS 0 Future consideration

6 VOTE

Adding userid and timestamp info in Database exception table (DBET)

When an objects goes to a pending status or STOP status due to unplanned / unexpected activity, it is difficult to identify who /when the object went to that restrictive status.Already the DBET will be storing information when an object goes to ST...

over 1 year ago in Db2 for z/OS 0 Future 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.

almost 7 years ago in Db2 for z/OS 1 Planned for future release

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

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

7 VOTE

Enhance high availability for partition by growth tablespaces.

Real-life scenario is described in the first paragraph below. I included a subset of it. The issue resulted in critical system outage caused a partition by growth dataset that hit max extents prior to hitting the DSMAX for the partition tablespace...

almost 2 years ago in Db2 for z/OS 0 Future 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...

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

8 VOTE

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

about 2 years 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.

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

Please enter your email address

FILTER BY CATEGORY