PK02239: MSG CQM7003E COLUMN VAR# MISSING FOR TABLE EXCEPTION HOSTV

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In environments with non-english CCSIDs, it is possible that the
  pound sign (#) is not translated correctly and the load fails to
  find that column in the offload table.  Structure will be
  changed
  to exclude the # sign and code will be modified to except both
  new and old structures.
  *****************
  ADDITIONALLY THIS WILL ADDRESS
  *******************
  WHEN EXECUTING OFFLOAD JOB CQM@LDB2 SPECIFING MULITPLE INTERVALS
  SQL TEXT IS OFFLOADED ONLY FOR FIRST INTERVAL SPECIFIED
  *
  Sample offload job CQM@LDB2 has an output error.
  All data included in the DATA parameter is offloaded for every
  interval between the starting_interval and ending_interval
  parameters with the exception of sqltext. CQM@LDB2 erroneously
  offloads sqltext only for the first interval specified by
  starting_interval parameter. The program is corrected to output
  sqltext for every interval between the starting and ending
  parameter.
  

Local fix

• ZAP below: //GTEE0W JOB
  '9-LCEG-SPG-F3-N',SIST,CLASS=4,MSGCLASS=T //* $ACFJ219 ACF2
  ACTIVE TORONJE //S1 EXEC PGM=AMASPZAP //SYSLIB DD
  DSN=SIST.DB2PM.V201.SCQMLOAD,DISP=SHR //SYSPRINT DD SYSOUT=*
  //SYSIN DD * NAME CQM@WDB2 CQM@WDB2 VER 0103C4 D97B REP 0103C4
  D9B1
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: In environments with non-english        *
  *                      CCSIDs, it is possible that the pound   *
  *                      sign (#) is not translated correctly    *
  *                      and the load fails to find that column  *
  *                      in the offload table.  Structure will   *
  *                      be changed to exclude the # sign and    *
  *                      code will be modified to except both    *
  *                      new and old structures.                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  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:

  UK04229

Modules/Macros

•    CQM#MSTB CQM@ITXT CQM@LSTM CQM@WDB2 CQMDDL7
  CQMDDL8
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R210 PSY UK04229

     UP05/06/15 P F506

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.