Db2 for z/OS

Showing 961 of 14915

There should be a table like SYSUTILITIES that contains Db2 Commands that have been issued

There should be a table like SYSUTILITIES , say SYSCOMMANDS, that contains Db2 Commands that have been issued, including the full text of the Db2 command that was issued.

over 1 year ago in Db2 for z/OS 0 Future consideration

3 VOTE

Allow Secondary AUTHID and Patterns in AUTHID column of the RLF tables

In order to make administration of the RLF tables easier, we would like to be able to enter a Secondary Authid or an ID Pattern. Secondary AUTHIDs would allow us to use definitions in the Security Manager to accommodate resource limits for many ID...

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

2 VOTE

Set Special Registers with profile tables for local applications

It would be nice to set the current explain mode (special register) with the help of profile tables (dsn_profile_table & dsn_profile_attributes) for local applications. In our case it's CICS. At the moment it's only possible for remote applica...

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

4 VOTE

Restart Time of DB2 should not be dependent on SCA size

During restart of DB2, the time difference between DSNR003I and DSNR004I is a function of the SCA size. Case TS009645595 was opened and has all the details. But in summary: this large time differenece of 30 seconds (in our case) is a function of t...

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

8 VOTE

Enhance the -904 REASON 00E30305 with the root cause of the failing AUTOBIND

The APAR PH13350 enhancement writes a notification DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00E30305 , TYPE OF RESOURCE This is a useful notification but it can be quite difficult to find the...

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

7 VOTE

real append processing on insert for LOB when specifying append

Our customers send us many millions of documents every day, which we have to save in the form of LOBs very quickly and without interruption in DB2. For this we use the APPEND option to be able to process the inserts as quickly as possible. Unfortu...

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

7 VOTE

Add SCOPE(GROUP) to the Start/Stop Profile command

In our shop we have many Db2 data sharing members. If we need to stop and then start our profile tables we need to do so in many places. Adding the SCOPE(GROUP) to the both the start and the stop command would reduce the number of places and comma...

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

8 VOTE

Better RMF API support in Db2 stats collection

Db2 can extract z/OS - LPAR related info from RMF when ZOSMETRICS ZPARM is enabled. However for this to work in a sysplex environment it is required that EVERY member in the sysplex has the Db2 SDSNLINK library in the linklist , regardless of whet...

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

2 VOTE

REPORT RECOVERY - new syntax requested to externalise just the image copy and log datasets

REPORT RECOVERY provides the CURRENT and SUMMARY keywords but even for these options the job output is either very verbose (Unit of Recovery, SYSCOPY entries, Archive log datasets, volume numbers for the LOG datasets etc) or too little (just the v...

9 months ago in Db2 for z/OS 2 Not under consideration

18 VOTE

New DB2z "LOCKMAXCANCEL" tablespace characteristic - cancel thread when N locks have been reached

Suggest a new parameter for the TABLESPACE definition (perhaps named "LOCKMAXCANCEL"). LOCKMAXCANCEL This would allow you to specific a number that represent the maximum number of locks that can be acquired for the tablespace at which point the th...

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

Please enter your email address

FILTER BY CATEGORY