Direct links to fixes
RAAzInstallRepository
RAAzInstall
Rational Asset Analyzer for System z Fix Pack 11 (6.1.0.11) for 6.1
Rational Asset Analyzer for System z Fix Pack 12 (6.1.0.12) for 6.1
Rational Asset Analyzer for System z Fix Pack 13 (6.1.0.13) for 6.1
Rational Asset Analyzer for System z Fix Pack 14 (6.1.0.14) for 6.1
Rational Asset Analyzer for System z Fix Pack 15 (6.1.0.15) for 6.1
Rational Asset Analyzer for System z Fix Pack 16 (6.1.0.16) for 6.1
Rational Asset Analyzer for System z Fix Pack 17 (6.1.0.17) for 6.1
Rational Asset Analyzer for System z Fix Pack 18 (6.1.0.18) for 6.1
Rational Asset Analyzer for System z Fix Pack 19 (6.1.0.19) for 6.1
Rational Asset Analyzer for System z Fix Pack 20 (6.1.0.20) for 6.1
Rational Asset Analyzer for System z Fix Pack 21 (6.1.0.21) for 6.1
Rational Asset Analyzer for System z Fix Pack 22 (6.1.0.22) for 6.1
Rational Asset Analyzer for System z Fix Pack 23 (6.1.0.23) for 6.1
APAR status
Closed as program error.
Error description
When RAAz Proprietary scanner has /B parameter to support QUOTESQL coded in DMH630Z and COBOL code with APOSTSQL-coded SQL syntax is present in EXEC SQL code, the following messages may be logged and postprocessing stops: IRX0250E System abend code 013, reason code 00000024. IRX0255E Abend in host command EXECIO or address environment routine TSO. IRX0670E EXECIO error while trying to GET or PUT a record. RDPRINT: DMH3112E Fail to read file data. Also, in RaaRestWar log: " [2016/05/18 17:29:06:955] RaaRestWar SEVERE: Return code [16] from processing queue type [4] java.lang.Exception: Return code [16] from processing queue type [4] at com.ibm.dmh.aqp.AnalysisQueueProcessorWork.startQueueProcessing( Analysis QueueProcessorWork.java:578) at com.ibm.dmh.aqp.AnalysisQueueProcessorWork.run2(AnalysisQueuePro cessorWo rk.java:414) at com.ibm.dmh.qp.DmhWork$WorkThreadIdentitySwitcher.run(DmhWork.ja va:69) at com.ibm.dmh.util.ThreadIdentitySwitcher$1.run(ThreadIdentitySwit cher.jav a:109) at java.security.AccessController.doPrivileged(AccessController.jav a:384) at javax.security.auth.Subject.doAs(Subject.java:495) at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:13 1) at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:89 ) at com.ibm.dmh.util.ThreadIdentitySwitcher.switchAndRun(ThreadIdent itySwitc her.java:102) at com.ibm.dmh.qp.DmhWork.run(DmhWork.java:34)
Local fix
remove /B parameter from DMH630Z when scanning COBOL code with APOSTSQL-coded SQL syntax
Problem summary
While the compiler-based scanners allowed users to specify QUOTESQL or APOSTSQL as an SQL scanning option to identify the parameter for SQL string delimiters, the proprietary scanners had no such user option available. By default, APOSTSQL was provided as the setting for SQL string delimiters when using the proprietary scanner. There was no mechanism for users to override this default. Source programs that contained SQL statements that required the compiler to use the QUOTESQL parameter failed to analyze successfully when using the proprietary scanner, generating a java.lang.StringIndexOutOfBoundsException message. A temporary workaround to provide relief from the StringIndexOutOfBounds exception was to hardcode a /B switch to force setting QUOTESQL as the SQL string delimiter. However, this workaround could result in a different exception if the program being analyzed actually utilized apostrophe as the SQL string delimiter, generating a java.lang.Exception message for example. Other symptoms of the issue in this context could include messages such as the following: IRX0250E System abend code 013, reason code 00000024. IRX0255E Abend in host command EXECIO or address environment routine TSO. IRX0670E EXECIO error while trying to GET or PUT a record. RDPRINT: DMH3112E Fail to read file data. (container_name(member_name)) EX 'hlq.SDMHREXX(DMH600Z)' 'D=N DS-MEMBER dataset_name SITE=site_name PDS dataset_name' RC(16) In the System log: IEA995I SYMPTOM DUMP OUTPUT 288 SYSTEM COMPLETION CODE=0C4 REASON CODE=00000004 TIME=11.42.59 SEQ=00081 CPU=0000 ASID=0049 PSW AT TIME OF ERROR 078D1000 8000C73E ILC 2 INTC 0D ACTIVE LOAD MODULE ADDRESS=00008038 OFFSET=00004706 NAME=CEEBINIT
Problem conclusion
The Collect Inventory wizard now provides an easy method for users to specify the SQL string delimiter parameter QUOTESQL as a SQL scanning option to override the default setting for the proprietary scanners.
Temporary fix
Comments
APAR Information
APAR number
PI63489
Reported component name
RATL ASSET ANAL
Reported component ID
5724V2700
Reported release
610
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-06-02
Closed date
2016-06-22
Last modified date
2016-06-22
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
unknown
Fix information
Fixed component name
RATL ASSET ANAL
Fixed component ID
5724V2700
Applicable component levels
R610 PSY
UP
Document Information
Modified date:
14 October 2021