PH61754: ISSUES WITH INLINE REORG IN NON-WSL APPLY JOB

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• There are multiple issues with non-WSL apply job when inline
  REORG is generated:
  1. Inline REORG step does not have a step name
  //*************************************************************
  *********
  //* STEP : REORG TABLE SPACE
  //*
  //* RESTART JOB STEP NAME IF FAILED IN THIS STEP : DELU0001
  //*************************************************************
  *********
  // EXEC DSNUPROC,SYSTEM=DD1A,
  2. Inline reorg splits CREATE step on several parts. But all
  these parts have the same step name - CREATE.
  3. DELETE OLD DATASETS step before an inline REORG is a copy of
  the same step before UNLOAD - it has the same step name and
  deletes the same datasets.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR addresses the following       *
  *                      problems:                               *
  *                      1. A non-WSL job is generated with      *
  *                      incorrect REORG steps.                  *
  *                      2. A non-WSL job is generated with      *
  *                      incorrect CHECK DATA steps.             *
  *                      3. A WSL is missing cleanup before      *
  *                      REORG utility invocation.               *
  ****************************************************************
  1. When generating a non-WSL apply job that has both UNLOAD
  and inline REORG steps, the generated REORG steps have no step
  name and use incorrect data set names for cleanup.
  2. When generating a non-WSL apply job that has inline CHECK
  DATA steps, the rest of the CHECK DATA steps are replaced
  with the inline step in the generated job.
  3. When using a WSL that contains REORG steps, the required
  data sets are not deleted before calling REORG, causing it to
  fail on restart.
  

Problem conclusion

• The problem has been resolved.
  

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:

  UI98015

Modules/Macros

• ADB2ALTJ ADBGAJOB ADBTREO
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UI98015

     UP24/08/16 P F408

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.