PK21692: AL RDEF AFTER UTIL UNLOAD FROMCOPY RESULTS IN UNLOAD STEP USING THE FROMCOPY SYNTAX AGAIN.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool AL RDEF function UNLOAD step
  incorrectly uses a UNLOAD FROMCOPY if a UNLOAD FROMCOPY is
  generated before the AL is attempted.
  

Local fix

• Correct UNLOAD step to remove FROMCOPY clause
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool,  who       *
  *                 create  unload  utility job with ALTER       *
  *                 Redefine, or do Utility Image copy and       *
  *                 then RDEF on a Tablespce, are affected.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: AL RDEF  UNLOAD step incorrectly uses a *
  *                      UNLOAD FROMCOPY if a UNLOAD FROMCOPY is *
  *                      generated before the AL is attempted.   *
  *                      .*                                      *
  *                      When  creating  alter redefine building *
  *                      a job with an unload  utility step with *
  *                      user  defined  options  previously  set *
  *                      from   an  Admin  unload  utility,  the *
  *                      utility options are copied to this step *
  *                      .*                                      *
  *                      A FROMCOPY statement is added to Unload *
  *                      step for a RDEFed tablespace.           *
  *                      .*                                      *
  *                      When  a  UTITILTY Image copy is created *
  *                      for  a  Tablespace  and  a  RDEF  of  a *
  *                      Tablespace is done after the Utility. A *
  *                      FROMCOPY  Statement  is inserted in the *
  *                      UNLOAD Step of the Generated job stream *
  *                      for a RDEFed Tablespace.                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• The reported problems have been fixed. Apply the fixes.
  

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

•    ADB2UUOP ADB21SAJ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK13525

     UP06/04/19 P F604

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.