Db2 for z/OS

Showing 979 of 15451

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

4 VOTE

Please develop a tool to real time monitor BB1RMID

Dear DB2 for Z developers, Our critical banking client got to know there is a severe storage leak issue reported on the DB2 V12. It's addressed on the APAR PH45580 already. Meanwhile, however, the client still wants us to develop a tool which coul...

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

3 VOTE

Report Which Member(s) Are Holding Up Commit-LSN Advancement

Requesting that Db2 issue a message when the commit LSN enhancement hasn't made progress for in a reasonable period of time, preferably with the LSN of all Db2 members so that Db2 customers can identify which member(s) could be holding up the LSN ...

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

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

6 VOTE

Reorg - SORTDATA NO - write to shadow instead of SYSREC and then the shadow

over 3 years ago in Db2 for z/OS 0 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 ...

over 4 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

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

Please enter your email address

FILTER BY CATEGORY