PM77044: SQL CODE -805 ERROR IN THE DB2 QUERY MONITOR DATA LOAD CQM@LDB2 SUPPORT IDAA IN QUERY MONITOR - PHASE 1 13/01/10 PTFPECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• IDAA support in Query Monitor 3.1 phase 1.
  Phase 1 support indicates whether a query was offloaded to the
  IDAA appliance (IBM DB2 Analytics Accelerator)in the ISPF
  summary panels and in CAE.
  
  Additional Symptom:
  This APAR also addresses an SQL code -805 error in the DB2 Query
  Monitor data LOAD job (CQM@LDB2) caused by an extra element
  introduced in PE'd APAR PM70811(UK83673) that should not be
  included.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: IDAA support in Query Monitor 3.1       *
  *                      phase 1. Phase 1 support indicates      *
  *                      whether a query was offloaded to the    *
  *                      IDAA appliance (IBM DB2 Analytics       *
  *                      Accelerator)in the ISPF summary panels  *
  *                      and in CAE.                             *
  *                      Additional Symptom:                     *
  *                      This APAR also addresses an SQL code    *
  *                      -805 error in the DB2 Query Monitor     *
  *                      data LOAD job (CQM@LDB2) caused by an   *
  *                      extra element introduced in PE'd APAR   *
  *                      PM70811(UK83673) that should not be     *
  *                      included.                               *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  PM77881 PM77994 UK91110

Modules/Macros

• CQM$BUFC CQM$BUFP CQM$BUFS CQM$BUFX CQM$BUF8
  CQM$BU8C CQM$BU8S CQM$BU8X CQM$CHLP CQM$DELC CQM$DELS CQM$DELX
  CQM$DELY CQM$DEL8 CQM$DE8C CQM$DE8S CQM$DE8X CQM$LINK CQM$LOCK
  CQM$LOCS CQM$LOCX CQM$LOC8 CQM$LO8C CQM$LO8S CQM$LO8X CQM$MAIN
  CQM$SMKY CQM$SMTX CQM$SMT8 CQM$SM01 CQM$SM02 CQM$SQRP CQM$SQR8
  CQM$SUMJ CQM$SUMK CQM$SUMP CQM$SU8J CQM$SU8K CQM$SU8P CQM$VSTR
  CQM#CQMA CQM#CQ31 CQM#CQ32 CQM#FEXP CQM#FMTR CQM#INTX CQM#IVCV
  CQM#IVSM CQM#MAIN CQM#PCIQ CQM#PCIX CQM#QAPI CQM#QAPX CQM#QSQL
  CQM#SDAQ CQM#SDIR CQM#SWTX CQM#UINX CQM@ITXT CQM@WDB2 CQMALTER
  CQMBLOB  CQMCAE   CQMCAEPT CQMCAPI  CQMCOMM  CQMCPXPT CQMC0185
  CQMDDL   CQMHBUF1 CQMHSUMB CQMHSUMJ CQMHSUMK CQMHSUMP CQMJAR
  CQMMCALX CQMMCMDX CQMMCMOX CQMMEACX CQMMEAPX CQMMEARX CQMMEASX
  CQMMEMTX CQMMESQX CQMMEXCX CQMME8CX CQMME8PX CQMME8RX CQMME8SX
  CQMME9CX CQMME9PX CQMME9RX CQMME9SX CQMMMETX CQMMQAPX CQMMSQLX
  CQMOREDX CQMPARSE CQMTTXTX
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R310 PSY UK91110

     UP13/02/07 P F302

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.