DSNECP10

DSNECP10 is part of the TSO Attachment Facility and is involved in TSO attachment initialization processing.

Two cases in which DSNECP10 causes wait as reported on the Resource Demand Distribution report include

  • Resource contention when an application is waiting for a Db2 object (indexspace or tablespace) which another user has locked.

  • High wait time caused by I/O wait. You can reduce I/O wait by improving Index Buffer lookaside ratios.

Hints

  • Ensure that the best possible access path is used.

  • Reorganize clustering indexes where the cluster ratio has dropped.

  • Encourage use of prefetch.

  • Allow an index to stay resident by assigning it to its own buffer pool.

  • Increase the size of the buffer pool when page stealing has occurred.

You can detail the causes of wait time by turning on Class 3 Accounting. The Db2 Performance Monitor Accounting Detail report will show types of suspension activity to the column SUSPENSIONS/SYSTEM EVENTS with various events, such as LOCK/LATCH SUSPENSIONS, SYNC. I/O SUSPENSIONS, etc. You can analyze these events further. For example, you can detail LOCK/LATCH SUSPENSIONS on the Lock Suspensions Summary, Lock Contentions Summary, and Lock Contention Trace reports. You can examine buffer pool processing through the Buffer Pool Statistics report and the Buffer Pool I/O Activity report. See the Strobe CICS Performance Supplement reports.

If high time is attributed to this module for multiple programs, then examine the detailed suggestions in the Installation Guide for moving DSNECP10 to LPA.

Reference Sources

IBM Db2 for OS/390, Messages and Codes, GC26-8979

IBM Db2 for OS/390, Installation Guide, GC26-8970