PH18944: DB2 INTERNAL SERVICEABILITY APAR FOR INSERT ALGORITHM 2 - IAG2

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Db2 internal serviceability for Insert Algorithm 2 - IAG2
  
  Additional keywords: MSGDSNI055I MSGDSNI087I IAG2
                       DB2IAG2/K
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 customers using Insert Algorithm                  *
  * 2 (IAG2) on objects defined with Universal                   *
  * Table Space (UTS) and MEMBER CLUSTER                         *
  * attributes.                                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Serviceability                                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  1. Need serviceability code to help problem diagnosis for
  Insert Algorithm 2 function.
  2. Improve DSNI055I & DSNI087I messages with serviceability
  information.
  

Problem conclusion

• 1. Serviceability code are added.
  2. DSNI055I message is modified to include the following
     information:
       URID OF DISABLING AGENT
       --- The Unit of Recovery ID of the thread that
           triggered Insert Algorithm 2 to be disabled.
       RBA OF DISABLING DIAGNOSTIC LOG
       --- The RBA value of the diagnostic log record
           when Insert Algorithm 2 was disabled.
       LRSN OF DISABLING DIAGNOSTIC LOG
       --- The LRSN value of the diagnostic log record when
           Insert Algorithm 2 was disabled.
  3. DSNI087I message is modified to include the following
     information:
       URID OF ENABLING AGENT
       --- The Unit of Recovery ID of the thread that
           triggered Insert Algorithm 2 to be enabled.
       RBA OF ENABLING DIAGNOSTIC LOG
       --- The RBA value of the diagnostic log record
           when Insert Algorithm 2 was enabled.
       LRSN OF ENABLING DIAGNOSTIC LOG
       --- The LRSN value of the diagnostic log record when
           Insert Algorithm 2 was enabled.
  

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:

  UI68041

Modules/Macros

• DSNFIDIR DSNICMT2 DSNISGSP DSNIASFP DSNISFRC DSNFCDIR DSNISFPI
  DSNITCUS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI68041

     UP20/03/04 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.