Readmes are available
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 number
IV68772
Reported component name
CICS IA EXPL PL
Reported component ID
5655Y2201
Reported release
520
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-01-20
Closed date
2015-03-11
Last modified date
2015-03-11
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
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCSKXW","label":"IA Explorer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
11 March 2015