PI38496: ABENDS04E IN TARGET JOB

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Target jobs may abend with system code S04E when trying to build
  partitioned indexes. This may occur if SET command
  REBUILD-INDEXES-EXECUTE(Y) is specified.
  
  The SET command REBUILD-INDEXES-EXECUTE allows indexes requiring
  rebuilding in the target job to be submitted automatically.
  Partitioned indexes may lack the partition keyword (PART)
  resulting in all partitions being rebuilt as many times as there
  are partitions.  This may result in storage shortages and ABENDs
  in the target job. The code will be changed to always submit
  INDEX REBUILDS for partitioned
  indexes using the PART keyword.
  
  Further, the ISPF interface is incorrectly requiring the SET
  command to be REBUILD-INDEXES-EXECUTE(Y) when
  TARGET-JOB-INDEX-REBUILD-DDN is used. These commands should not
  be linked but both may be specified.  Both might be specified so
  that if the target job has problems rebuilding one or more
  indexes, the template output using the
  TARGET-JOB-INDEX-REBUILD-DDN command may be used to rebuild
  indexes after the target job has completed. The panels will be
  changed to decouple these two panel commands.
  

Local fix

• In the source job:
  In the SET command, ensure REBUILD-INDEXES-EXECUTE(N)
  In the COPY command
  TARGET-JOB-INDEX-REBUILD-DDN(CKZTIR) this defines the DDs in the
  target job and turns on the rebuild process
  In the target job:
  Add two DDs
  //CKZTIRI DD DISP=SHR,DSN=&hlq.CKZTIRI(QAS@H8) input template
  //CKZTIRO DD DISP=SHR,DSN=&hlq.CKZTIRO(QAS@H8) output of
  template processing
  Use CKZJOBR in JCLLIB as the input template and add //*
  &&UTLRBIX
  after //* &&TRGOBJS
  Make appropriate changes for your shop.
  After the target job has finished, execute the job in the
  CKZTIRO member.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Cloning Tool.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Target jobs may abend with system code  *
  *                      S04E when trying to build partitioned   *
  *                      indexes. This may occur if SET command  *
  *                      REBUILD-INDEXES-EXECUTE(Y) is           *
  *                      specified. The SET command              *
  *                      REBUILD-INDEXES-EXECUTE allows indexes  *
  *                      requiring rebuilding in the target      *
  *                      job to be submitted automatically.      *
  *                      Partitioned indexes may lack the        *
  *                      partition keyword (PART) resulting in   *
  *                      all partitions being rebuilt as many    *
  *                      times as there are partitions.  This    *
  *                      may result in storage shortages and     *
  *                      ABENDs in the target job. The code      *
  *                      will be changed to always submit        *
  *                      INDEX REBUILDS for partitioned          *
  *                      indexes using the PART keyword.         *
  *                      Further, the ISPF interface is          *
  *                      incorrectly requiring the SET           *
  *                      command to be                           *
  *                      REBUILD-INDEXES-EXECUTE(Y) when         *
  *                      TARGET-JOB-INDEX-REBUILD-DDN is used.   *
  *                      These commands should not be linked     *
  *                      but both may be specified.  Both might  *
  *                      be specified so that if the target      *
  *                      job has problems rebuilding one or      *
  *                      more indexes, the template output using *
  *                      the TARGET-JOB-INDEX-REBUILD-DDN        *
  *                      command may be used to rebuild          *
  *                      indexes after the target job has        *
  *                      completed. The panels will be           *
  *                      changed to decouple these two panel     *
  *                      commands.                               *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

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:

  UI30166

Modules/Macros

•    CKZ00501 CKZ00546 CKZ00715
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R310 PSY UI30166

     UP15/08/21 P F508

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.