PH52316: MINOR CAE DEFECT FIXES (SQLCODE203 , -203)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• -203 SQL Error When Sorting by Delay in Archive Connection plus
  other minor defect fixes
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Query Monitor CAE               *
  ****************************************************************
  * PROBLEM DESCRIPTION: -203 SQL Error When Sorting by Delay    *
  *                      in Archive Connection                   *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  While browsing offload data, sorting by Delay would result in
  a -203 Db2 SQL error..
  

Problem conclusion

• 1. Corrected the statement causing the error.
  

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:

Modules/Macros

• CQM#IVSM CQM#MAIN CQM$INTV CQM29    CQM86    CQM860E  CQM861I
  CQM@LDB2 CQMBLOB  CQMCFPAX CQMCPXPT CQMHACT1 CQMHDB21 CQMHDDB1
  CQMHEXC1 CQMHINTV CQMHSMKY CQMHSQ02 CQMHSQC2 CQMHSQC3 CQMHSQCC
  CQMHSQCL CQMHSQCP CQMHSTXT CQMHSUJ1 CQMHSUL1 CQMHSUM3 CQMHSUM6
  CQMHTEMP CQMJAR   CQMMCMDX CQMMEMTX CQMPTFRM CQMSSV   CQMUPXPT
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI90800

     UP23/03/05 P F303

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.