PM03869: ECSA SHORTAGE MSGDXR175E SP241

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After starting OMEGAMON Batch CRD job with DSGLOBAL(Y)
  which starts DB2 AUDIT TRACE
  the ECSA is growing by SP241 for Lock Manager TRWA Pool .
  DB2STGLK/K
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 UDB for z/OS V8 and V9 users.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: ECSA storage shortage due to orphaned   *
  *                      TRWA blocks.                            *
  *                                                              *
  *                      Message MSGDXR175E (IRLM IS UNABLE TO   *
  *                      OBTAIN STORAGE - ECSA) received in      *
  *                      syslog followed by DB2 abnormal         *
  *                      termination with ABEND878 RC4.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A TRWA is unconditionally acquired during thread allocation if
  one does not exist for the thread.  However, the agent driving
  the thread allocation could have a TRWA associated with it, and
  the TRWA created during thread allocation will overwrite the
  agent's existing TRWA pointer.  This resulted in a leak of
  TRWAs, storage shortage in ECSA and DB2 abnormal termination.
  
  Please note that all TRWA storage is freed when DB2 termination
  occurs.
  

Problem conclusion

• DB2 has been modified to use the agent's TRWA if one exists.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK54384 UK54385

Modules/Macros

• DSNTAAL  DSNTADL  DSNTICT  DSNTLBAC DSNXAAB
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK54384

     UP10/03/03 P F003

• R910 PSY UK54385

     UP10/03/03 P F003

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.