Db2 for z/OS

Showing 997 of 15909

Issue command DISPLAY DB CLAIMERS on a LOAD SHRLEVEL NONE when DRAIN fails in UTILINIT phas

We faced situations in which LOAD SHRLEVEL NONE jobs abends with S04E and Reason Code 00C200EC during UTILINIT phase. When this abends occurs, LOAD was unable to DRAIN all the claimers, once it is SHRLEVEL NONE, before beggining LOAD data into tab...

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

47 VOTE

A View with Select * should be regenertated without Drop/Create View

We have a lot of views defined with Select *. Since DB2 V8 we have the option to add columns to the base table, but the view does not include the new column, which is ok and accepted. But to get the new column we have to drop and recreate the View...

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

27 VOTE

IFCID 316 401 ZiiP Usage Statistics

Currently the IFCIDs 316 and 401 contains great data for monitoring and tuning SQLs. It would be excellent if these IFCIDs could be extended to include a separate set of ZiiP counters. IFCID 25 does this for Utilities at the moment.

over 7 years ago in Db2 for z/OS 1 Planned for future release

11 VOTE

Modify DSNJU004 to print all information stored in a Db2 BSDS

Not everything that resides in a BSDS can be printed via this utility. However several items are stored in the BSDS that we need to go to several other places to get the information

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

4 VOTE

DB2 Regions creating a lot of messages for AB/S004E SYSTEM ABEND CODE: 004E in LOGREC

It was reported thru GTIECSMFDB-10132 on both the SDPLEX and SBPLEX that the DB2 regions are producing thousands of error messages in the System Logrec for AB/S004E SYSTEM ABEND CODE: 004E each day. The following error messages are filling up the ...

about 1 year ago in Db2 for z/OS 3 Planned for future release

7 VOTE

DDF Start with TCP/IP should be coordinated between Start Listener and Start DDF

During start of DDF inside DB2, DB2 start the Listener for TCP/IP requests and a small timeframe later the DDF. In this timeframe incoming requests are denied with REASON=00D31032 and follow-on errors. As an bypass we do not start DDF automaticall...

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

13 VOTE

RUNSTATS with exception consideration

All DB2 customers use RUNSTATS. The RUNSTATS results are used by the DB2 optimizer to determine optimal access plans. In 99.999 percent of all cases this is not a problem. However, there are some objects (tablespaces / indices) for which a RUNSTAT...

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

9 VOTE

Enable DSNTIAUL to generate NUMRECS in the punchdataset

The UNLOAD using DSNUTILB generates the NUMRECS parameter which makes the Allocation of Sort/Workdatasets for the Load utility very effective. Because some collegues use IKJEFT01 (DSNTIAUL) for unloading data, we tried to use NUMRECS here also. Bu...

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

3 VOTE

Improve Space Search Performance for Nearly Full PBR

Currently, when there are many concurrent inserts on a PBR which is nearly full, CPU and elapsed time for inserts increases by many orders of magnitude, to the point where it can completely monopolize the CPU on an LPAR. In past discussions, I was...

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

3 VOTE

Write Failed Lock Escalation Attempts to Master

Currently, when Lock Escalation succeeds, a message is written to the Master Log with details. However, when a Lock Escalation attempt fails (due to a timeout or deadlock), nothing is written. This sort of timeout or deadlock can be difficult to d...

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

Please enter your email address

FILTER BY CATEGORY