PI96994: USING NON STANDARD CHARS (IE. # OR @) IN SCHEMA NAME OF OFFLOAD TABLES MAY CAUSE SQLCODE=-104 IN ACTIVITY BROWSER

IBM Db2 Query Monitor for z/OS CAE Browser Client download
Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In oder to get data from the DB2 offload tables, the CAE Server
  automatically builds SQL statements. These SQL statements are
  long and are broken into lines shorter than 80 characters for
  better readability. If the schema name contains non-alpabetic
  and non-numeric characters, for example @ or #, then the CAE
  Server may generate an statement incorrectly, causing
  SQLCODE=-104.
  

Local fix

• As workaround use schema name without @ (only alphabetic and
  numbers).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Query Monitor z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: In oder to get data from the DB2        *
  *                      offload tables, the CAE Server          *
  *                      automatically builds SQL statements.    *
  *                      These SQL statements are long and are   *
  *                      broken into lines shorter than 80       *
  *                      characters for better readability. If   *
  *                      the schema name contains non-alpabetic  *
  *                      and non-numeric characters, for         *
  *                      example @ or #, then the CAE Server     *
  *                      may generate an statement incorrectly,  *
  *                      causing SQLCODE=-104.                   *
  ****************************************************************
  * 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:

  UI58878

Modules/Macros

• CQMBLOB  CQMCAEPT CQMCPXPT CQMICRT  CQMJAR
  CQMMGRT  CQMPTFRM CQMUPXCF
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI58878

     UP18/10/06 P F810

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.