PK53079: JCLERR "FAILED BY INTERPRETER" IN DB2 OBJECT RESTORE V2.1 WITH DB2 LOG ANALYSIS TOOL V2.3 (POINT IN TIME RECOVERY).

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Restore generated job, which restores the object,
  ends with JCLERR "FAILED BY INTERPRETER". The job  wants to use
  a dataset that does not exist.
  
  For example:
  105 //SQLIN    DD DISP=SHR,DSN=A351153.DB2ORLAT.SQLOUT.R0161447
  
  This happens in DB2 Object Restore v2.1. It occurs only when DB2
  Log Analysis Tool v2.3 (Point in Time Recovery).
  
  EXPLANATION:
  JES3 will not recognize the existence of dynamically created
  (svc 99) data sets during a job run. The DISP=SHR reference to
  the sql input data set in the EXECSQL job step will fail the
  entire job with a IAT4404 JES3 locate error because the JCL to
  allocate that data set is not contained
  in the job stream.
  

Local fix

• To correct the problem please split the recovery in two jobs.
  - Run that data recovery and ALA SQL jobs steps first in a job.
  - When that job completes run the SQL execute step(s).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of IBM DB2 Object Restore.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Object Restore generated job, which *
  *                      restores the object, ends with JCLERR   *
  *                      "FAILED BY INTERPRETER".  The job       *
  *                      wants to use a dataset that does not    *
  *                      exist.                                  *
  *                                                              *
  *                      For example:                            *
  *                      105 //SQLIN  DD DISP=SHR,DSN=           *
  *                      A351153.DB2ORLAT.SQLOUT.R0161447        *
  *                                                              *
  *                      This happens in DB2 Object Restore      *
  *                      V2.1.  It occurs only with DB2 Log      *
  *                      Analysis Tool V2.3 (Point in Time       *
  *                      Recovery).                              *
  *                                                              *
  *                      EXPLANATION:                            *
  *                      JES3 will not recognize the existence o *
  *                      dynamically created (SVC 99) data sets  *
  *                      during a job run.  The DISP=SHR         *
  *                      reference to the sql input data set in  *
  *                      EXECSQL job step will fail the entire j *
  *                      with an IAT4404 JES3 locate error becau *
  *                      the JCL to allocate the data set is not *
  *                      contained in the job stream.            *
  *                                                              *
  *                      LOCAL FIX:                              *
  *                      To correct the problem please split the *
  *                      recovery into two jobs.                 *
  *                      -Run that data recovery and ALA SQL job *
  *                       steps in a job.                        *
  *                      -When that job completes run the SQL    *
  *                       execute step(s)                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code changes have been made to address these issues.
  

Problem conclusion

• Apply the PTF.
  

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:

  UK31141

Modules/Macros

•    AUO@XSQL AUOUTILS
  

Fix information

• Fixed component name

  DB2 OBJECT REST

• Fixed component ID

  5655E7201

Applicable component levels

• R210 PSY UK31141

     UP07/11/21 P F711

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.