APAR status
Closed as program error.
Error description
You are currently running CICS IA v5.1 Plug-In and the CICS Explorer v5.1 and trying to execute one the IBM default command flow queries. But the queries keep failing and you get a pop up window that says "Cannot run the query for the current database. Reason: the following fields are not supported in CICS IA 5.1, DB APAR LEVEL [H274510] database: CICS.Column.TASKID, CICS.Column.USERID, CICS.Column.CMD_EIBRESP The CICS IA Plugin Development have confirmed this and they agree that the samples are incorrect. Additional Symptom(s) Search Keyword(s): KIXREVEPH
Local fix
Problem summary
When running CICS IA v5.1 Plug-In and the CICS Explorer v5.1 and trying to execute one the IBM default Command Flow, DB2, or Natural queries you get a pop up window that says: Cannot run the query for the current database. Reason: the following fields are not supported in CICS IA 5.1, DB APAR LEVEL H274510 database: CICS.Column.TASKID, CICS.Column.USERID, CICS.Column.CMD_EIBRESP The column names listed under the Reason may vary depending on the Query. The problem occurs because some of the sample query files are corrupted. The corrupted files are located in: Supplied Samples\Command Flow (3 files) Supplied Samples\DB2 (3 files) Supplied Samples\Natural and ADABAS (4 files)
Problem conclusion
The corrupted sample query files have been corrected. This fix will be made available in Version 5.1.0.1 of the CICS Interdependency Analyzer plug-in for CICS Explorer. For installation instructions please see: Ordering maintenance for the IBM CICS Explorer tools plug-ins http://www-01.ibm.com/support/docview.wss?uid=swg21614546 To replace the corrupted files with the correct ones, remove the corrupted query samples from your workspace by either deleting them from the IA plug-in Queries view, or directly from your workspace folder using a file manager. The corrupted files are located in Supplied Samples\Command Flow (3 files) Supplied Samples\DB2 (3 files) Supplied Samples\Natural and ADABAS (4 files) The new set of samples will be copied to your workspace once you press a 'Refresh' toolbar button in the Queries view, or once you restart CICS Explorer.
Temporary fix
Comments
APAR Information
APAR number
IV36712
Reported component name
CICS IA EXPL PL
Reported component ID
5655Y2201
Reported release
510
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-02-13
Closed date
2013-04-23
Last modified date
2013-04-23
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
R510 PSY
UP
Rate this page:
Average rating
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.