PK66091: DSNV086E IN DB2 SUBSYSTEM DB2 ABNORMAL TERMINATION REASON=00E50702 08/05/15 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DSNV086E in DB2 subsystem DB2 ABNORMAL TERMINATION
  REASON=00E50702.
  
  When monitoring workloads in a DB2 subsystem and collecting host
  variables, an ABENDS0C1 can occur causing an ABENDS071 and the
  DB2 subsystem to fail. Additional symtoms may also include
  ABENDS04E FOR REASON=00E20032.
  
  DSNV086 ABEND0C1 S0C1 0C1 ABEND071 071 S071 ABEND04E 04E S04E
  

Local fix

• Turn off collection of HOST variables in the QM profile - Gather
  Host Variables  N
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of IBM DB2 Query Monitor.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: DSNV086E in DB2 subsystem DB2 ABNORMAL  *
  *                      TERMINATION REASON=00E50702.When        *
  *                      monitoring workloads in a DB2 sybsystem *
  *                      and collecting host variables, an       *
  *                      ABEND0C1 can occur causing an ABEND071  *
  *                      and the DB2 subsystem to fail.          *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code changes have been made to address these issues.
  

Problem conclusion

• Apply PTF
  

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:

  UK36976 UK36977

Modules/Macros

•    CQMMHSTV CQMMHST9
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R220 PSY UK36976

     UP08/06/05 P F806 «

• R221 PSY UK36977

     UP08/06/05 P F806 «

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.