PI19350: DSN508I MESSAGES INDICATING DB2 DBM1 BELOW-THE-BAR STORAGE WARNING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DECENA00 exit does not release storage upon error
  termination.
  Customer reported many errors like the following.
  
   DSNT408I SQLCODE = -652, ERROR:  VIOLATION OF INSTALLATION
            DEFINED EDIT OR VALIDATION PROCEDURE SOPQTE01
   DSNT418I SQLSTATE   = 23506 SQLSTATE RETURN CODE
  
  Customer reported DB2 crashed after receiving messages that all
  below the bar storage in DBM1 was consumed.
  We began receiving DSN508I messages indicating 70% usage then
  the following.
  
  DSNV508I  -D025 DSNVMON - DB2 DBM1 BELOW-THE-BAR
  STORAGE WARNING
            99% CONSUMED
            0% CONSUMED BY DB2
            12M AVAILABLE OUT OF REGION SIZE 1400M
            WITH A 282M STORAGE CUSHION
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of the DECENA00 EDITPROC.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: A storage leak occurred when the        *
  *                      DECENA00 EDITPROC was executed.         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The user did not move the contents of the Cryptographic Services
  Facility (ICSF) Cryptographic Key Data Set (CKDS) to a new
  system. When DECENA00 ran on thsis new system it did not
  successfully retrieve the key. DECENA00 error processing did not
  free storage. The problem was diagnosed when a very largwe
  number of transactions had been abnormally terminated, but
  continued to be scheduled resulting in DB2 storage management
  issues.
  

Problem conclusion

• Additional storage release processing was added to DECENA00
  user error processing.
  Relink the updated EDIT routine DECENA00 supplied with this
  APAR into all impacted existing user built encryption EDIT
  routines. No ICSF key management definitions are impacted so
  the same key labels can be used as specified for the
  original versions of the routines. Use the original link
  edit JCL that built each user EDIT routine to regenerate a
  new version of each routine.  Be sure to recycle DB2 to
  ensure the updated versions of the EDIT routines are
  refreshed in the appropriate SDSNEXIT library.
  

Temporary fix

Comments

APAR Information

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

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

  UI19868

Modules/Macros

• DECENA00 DECENC07
  

Fix information

• Fixed component name

  DATA ENCRYPTION

• Fixed component ID

  5655P0300

Applicable component levels

• R120 PSY UI19868

     UP14/07/24 P F407

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.