Db2 for z/OS

Showing 985

RECOVER utility option to include inflights

There should be an option in RECOVER utility which allows to include during recovery all the inflight threads which started before the point of time to which we are recovering the object. Currently all inflights are being rolled back

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

3 VOTE

Parameter to set REORG interrupt due to an unexpected wait

There are situations where a REORG utility can cause locks. A few weeks ago we suffered an episode of timeouts because a Reorg that was locking in the log phase. The Reorg was performing the consolidation of an ALTER DSSIZE in a UTS PBR. We didn't...

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

4 VOTE

Increase messaging detail after STOP Db2 to provide shutdown status information.

As Db2 continues to allow more and more capacity in a single subsystem - larger bufferpools, more open datasets, etc - the time to shut down Db2 continues to increase. Operational staff has complained repeatedly that they cannot tell whether Db2 i...

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

9 VOTE

Remove a thread in DB2 which becomes COMMITTED-H or ABORTED with command -RESET INDOUBT IPADDR(*) FORCE without STOP DDF

Change the way to remove a thread which becomes COMMITTED-H or ABORTED-H after a RECOVER INDOUBT is to execute command -RESET INDOUBT IPADDR(*) FORCE without stopping the DDF

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

2 VOTE

Reduce message flooding on system console using Db2 System Profile Monitoring for security profiles when detecting non-secure connections and WARNING_DIAGLEVEL3

This Aha idea is being opened on behalf of Commerzbank (Ute Kleyensteuber). Security profiles are used with System Profile Monitoring filter LOCATION=*, ATTR1=WARNING_ DIAGLEVEL3, ATTR3=1 (TLS required) to discover all incoming non-secure connecti...

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

11 VOTE

ALTER TABLESPACE DEFINE YES

Currently, if a tablespace or index is created with DEFINE NO, the underlying VSAM cluster is not created until the first row is inserted, or until LOAD RESUME NO REPLACE is executed. This is used a lot, for example, in SAP or PeopleSoft systems. ...

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

16 VOTE

DSNACCOX RRTDataSpaceRatio & TSQTY ZPARM

Our DBAs would like to use the RRTDataSpaceRatio attribute via DSNACCOX stored procedure to facilitate triggering REORGs for over allocated tablespaces. This is not currently possible due to the fact that REORGs are triggered erroneously for small...

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

17 VOTE

Eliminate the need to bind a subprogram locally called by a stored procedure running remotely

Today there are different code pathes if a package is called remotely from a local program OR a local stored procedure. If the package is called by a stored procedure we get SQLCODE805 if no local package exists. Therefore we have the need to bind...

about 10 years ago in Db2 for z/OS 0 Future consideration

8 VOTE

I would like an easy way to validate that a bound query is used to hint a dynamic query

Today, it is easy to validate that a bound query is used as a hint to a static query. After all, there is a column updated in PLAN_TABLE when the package is bound that exploits the bound query. But, it becomes difficult to know if a dynamic query ...

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

13 VOTE

RUNSTATS DIRECTORY (DSNDB01) TABLESPACES

Till now (DB2 12) it is not allowed to run RUNSTATS on the directory tablespaces.Because of features like LOB COMPRESSION or SPT01 COMPRESSION it is strongly recommended to have the possibility to run RUNSTATS on the directory tablespaces. We have...

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

Please enter your email address

FILTER BY CATEGORY