IV68772: USES RESOURCE RESULTS MISSING FOR TRANSACTIONS - DECIMAL SEPARATOR IN DB2 IS A COMMA SQLCODE-214

IBM CICSIA-5.2.0-FP0003
IBM CICSIA-5.2.0-FP0004
IBM CICSIA-5.2.0-FP0005
IBM CICSIA-5.2.0-FP0006

APAR status

• Closed as program error.

Error description

• After migrating to CICS IA 5.2 plug-in, you select a
  transaction and attempt to show the resources used.  No
  resources are displayed.  This same sequence runs fine under
  CICS IA 5.1 plug-in.
  In the log, you see the following message:
  !ENTRY com.ibm.cics.dbfunc 4 0
  !MESSAGE Unable to execute SELECT DISTINCT APPLID,PROGRAM FROM
  CICSIA.CIU_CICS_DATA WHERE TRANSID='TRA1' UNION SELECT DISTINCT
  APPLID,PROGRAM FROM CICSIA.CIU_DB2_DATA WHERE TRANSID='TRA1'
  UNION SELECT DISTINCT APPLID,PROGRAM FROM CICSIA.CIU_IMS_DATA
  WHERE TRANSID='TRA1' UNION SELECT DISTINCT APPLID,PROGRAM FROM
  CICSIA.CIU_MQ_DATA WHERE TRANSID='TRA1' ORDER BY 1,2
  When the same query is run under DB2 SPUFI, you see:
  DSNT408I SQLCODE = -214, ERROR:  AN EXPRESSION IN THE FOLLOWING
  POSITION, OR  STARTING WITH 1 IN THE ORDER BY CLAUSE IS NOT
  VALID.  REASON CODE = 1
  DSNT418I SQLSTATE   = 42822 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXONDA SQL PROCEDURE DETECTING ERROR
  The customer has the decimal point specified as a comma (,)
  rather than a period (.) in DB2.
  Additional Symptom(s) Search Keyword(s): KIXREVEPH
  SQLCODE214 SQLCODE-214  SQLSTATE 42822
  

Local fix

• Contact CICS IA Support for a usermod
  

Problem summary

• If the database locale has the decimal point set to comma,  DB2
  v8 and later require a space between comma and decimal column
  number in clauses such as "ORDER BY 1, 2". Otherwise 1,2 is
  treated as floating-point decimal and the SQL server returns SQL
  Code -214.
  

Problem conclusion

• The Database Functionality component of the Interdependency
  Analyzer plug-in for CICS Explorer was updated so that "ORDER
  BY" clauses always contain a space after a comma.
  The fix will be made available in version 5.2.0.3 of the CICS
  Explorer Interdependency Analyzer plug-in.
  For installation instructions please see:
  Ordering maintenance for the IBM Explorer for z/OS, IBM CICS
  Explorer and CICS Explorer plug-ins
  http://www.ibm.com/support/docview.wss?uid=swg21380083
  

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:

Fix information

• Fixed component name

  CICS IA EXPL PL

• Fixed component ID

  5655Y2201

Applicable component levels

• R520 PSY

     UP