Db2 for z/OS

Showing 967

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

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

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

16 VOTE

add SPACENAM in DISPLAY BLOCKERS command

PTF UI69433 introduces a new command DISPLAY BLOCKERS which is wonderful because it provides rich information of locks and claimers. The only draw back is it does not have SPACENAM option to narrow down the output.

about 4 years ago in Db2 for z/OS 1 Planned for future release

21 VOTE

I would like to force the use of the "DEFER" option on the creation of an index (using Zparm to make it optional).

We have DBAs that at times (accidently) run a "CREATE INDEX" and fail to include the "DEFER" option. This is rather easy to do because the reverse engineering tools fail to create syntax with the "DEFER" option. The creation of indexes can be very...

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

1 VOTE

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

11 VOTE

RLF DSNRLMTxx table field RLFIP allow subnet wildcard

we have a need to restrict threads with RLF by specifying userid and source IP with a subnet wild card. the source ips change with each "logon". In order to restrict all possible ips under a given subnet, we would need to enter 255 X 255 ips. allo...

almost 3 years ago in Db2 for z/OS 0 Planned for future release

6 VOTE

DISPLAY TERMINATED DUE TO INSUFFICIENT MESSAGE SPACE

Applications moving to the cloud have significantly increased the number of locations accessing Db2. Current limits within the -DISPLAY LOCATION command prevents the command from displaying all possible locations. This idea is to remove this limit...

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

25 VOTE

FL LEVEL support

In Db2 12 the Functional Level is currently *not* externalized in various places where it most definitely should be. Notably the PLAN_TABLE, IFCID 316 and IFCID 401. If you are attempting tuning you *must* know under which FL level the SQL in ques...

almost 7 years ago in Db2 for z/OS 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY