Db2 for z/OS

Showing 88

RID problem instrumentation improvement

The IFI 2 & 3 fields QISTRLLM and QISTRPLM and the RID fields in the 316 and 401 are all basically “useless” these days to actually detect a RID related limit problem. I know that the QXRFMIAP is available in the IFI 2 & 3 but it is needed...

6 months ago in Db2 for z/OS 0 Future consideration

9 VOTE

New Db2 ZPARM for specifying SMS storage & management classes for FlashCopy image copies

When doing FlashCopy image copies the Db2 utilities create image copies by ADRDSSU and it passes the same SMS storage & management classes as the Db2 spaces.This is not always wanted as the performance and management requirements are in most c...

6 months ago in Db2 for z/OS 0 Future consideration

2 VOTE

Link FLA messages to auto recovery task id

We did a large GRECP recovery test with around 68.000 GBP dependend objects. After restart and the automatic GRECP recovery we see a lot of DSNI025I, DSNI026I, DSNI027I, DSNI028I and DSNI029I messages as expected, but they have no correlation to t...

7 months ago in Db2 for z/OS 0 Future consideration

6 VOTE

Expand IFCID 258 to include the last available partition (based on MAXPARTITIONS) of a partitioned table spaces.

IBM already produces IFCID 258 when an extent is taken. Would IBM may consider the expansion into the last available partition to be a noteworthy event or either inform the MAXPARTITION value. So, the percentage of available partitions can be calc...

7 months ago in Db2 for z/OS 0 Future consideration

6 VOTE

Set Partition Index, DPSI to the same DSSIZE as Tablespace when converting to RPN and ALTER TABLESPACE DSSIZE is after ALTER TABLESPACE PAGENUM RELATIVE

In numerous cases it is impossible to put the ALTER TABLESPACE DSSIZE in front of the ALTER TABLESPACE PAGENUM RELATIVE due to the number of partitions and page size. Currently this only works with the following. After the reorg materialization th...

8 months ago in Db2 for z/OS 0 Future consideration

2 VOTE

Set object status to prohibit data access

Before we drop a Db2 table we need to make sure that noone use the object in any way. We solve this now by stopping the tablespace and keeping it stopped for about six months. This means that noone can access the data and noone can run a utility a...

9 months ago in Db2 for z/OS 0 Future consideration

11 VOTE

DB2: Enhancing DB2 decision making during starting up in DEFER ALL mode

We would like to enhance the DB2 product when starting a database with the "defer all" zparm parameter. It is unfortunate that there is a limit of 2500 in place, and it is also unfortunate that the trusted context is not automatically built, even ...

10 months ago in Db2 for z/OS 2 Future consideration

15 VOTE

Display IAG2 on object level

Sometimes IAG2 will be disabled, in some situations this is clear and ok, in some situations it is strange and not expected. To implement reliable automation we need e.g. an enhancement to DISPLAY DATABASE SPACENAM with IAG, which shows which inse...

11 months ago in Db2 for z/OS 0 Future consideration

2 VOTE

Provide incremental progress messages through a DB2 group restart

During a recent DR activity our Db2 had issues during group recovery and it was challenging to determine at what point Db2 had gone as far as it could before requiring the other member to be restarted to resolve any locks RC00C200EB . The MSTR log...

11 months ago in Db2 for z/OS 1 Future consideration

7 VOTE

Provide capability to set DSSIZE for implicitly created LOB Auxiliary Tablespaces

Currently an implicitly created LOB Auxiliary TS DSSIZE is set to 4G and does not adhere to the zparm IMPDSSIZE or the base TS DSSIZE. We would like the capability to influence the default DSSIZE for LOBs.This would also make it consistent with th...

12 months ago in Db2 for z/OS 0 Future consideration

Please enter your email address

FILTER BY CATEGORY