PI63489: SYSTEM ABEND CODE 013, REASON CODE 00000024 WHEN SCANNING CODE WITH APOSTSQL-CODED SQL SYNTAX AND /B PARM IN DMH630Z

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 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