PK45430: JCL ERROR IN THE GENERATED PWH JOB NEEDED FOR THE SQL BACH JOB

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• JCL ERROR IN THE GENERATED PWH JOB NEEDED FOR THE SQL BACH JOB
  
  In the generated PWH job, OM DB2PE created the ANLPARM and
  ANLCNTL DDNAME, they are needed for the SQLPA Batch job.
  
  Since a row in a JCL job does not accept more than 72 chars on a
  row (better is to say 71, because the 72th char should be a
  continuation char) and the customer environment is longer than
  44 chars (with member name), OM DB2PE get a JCL error (IEFC618I
  OPERAND FIELD DOES NOT TERMINATE IN COMMA OR BLANK) we have to
  split the line in two..
  
  Instead of generating the following JCL row:
  //ANLPARM  DD
  DISP=SHR,DSN=SIBM.OMEGAMON.V310.LAB.CPUQ.RKD2PAR(OMQPDBL1)
  
  We have to create these 2 lines:
  //ANLPARM  DD DISP=SHR,
  //            DSN=SIBM.OMEGAMON.V310.LAB.CPUQ.RKD2PAR(OMQPDBL1)
  The same for the ANLCNTL DDNAME.
  
  FYI.
  Here again the JCL statement.
  //ANLPARM  DD
  DISP=SHR,DSN=SIBM.OMEGAMON.V310.LAB.CPUQ.RKD2PAR(OMQPDBL1)
  1234567890123456789012345678901234567890123456789012345678901234
  56789012
           1         2         3         4         5         6
       7
  

Local fix

• Drop runtime and recreate the runtime with a shorter HLQ.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Classic Interface                        *
  *                 -   Performance Warehouse users              *
  ****************************************************************
  * PROBLEM DESCRIPTION: The generated PWH job containing the    *
  *                      SQLPA call contains errors when called  *
  *                      from VTAM if the OMPE datasets HLQ is   *
  *                      longer than 25 chars.                   *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF.                              *
  ****************************************************************
  Splitted the ANLPARM & ANLCNTL into 2 lines in the
  generated JCL.
  

Problem conclusion

• SQLPA can now be called from VTAM correctly.
  
  KEYWORDS :SQLPA VTAM JCL ERROR PWH
  

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:

  UK25962 UK25963

Modules/Macros

•    DGO@SQPA DGOZSQPA
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK25962

     UP07/06/12 P F706

• R410 PSY UK25963

     UP07/06/12 P F706

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.