Db2 for z/OS

Showing 986

the SYSPACKAGE's column "lastused" needs to update more frequently

Hi IBM, As you see below in description of "lastused" column on SYSIBM.SYSPACKAGE, the updated must be done "whenever" the package is used but it's not true, so due to this doubt that we have when we saw that this column was not updated after pack...

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

16 VOTE

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

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

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

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

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

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

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