PH02980: PROBLEMS WITH LOB AND NOT LOGGED ATTRIBUTES GENERATING THE IMAGECOPY UTILITY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Problems with LOB and NOT LOGGED attributes generating the Image
  Copy utility:
  For non-LOB objects created with the NOT LOGGED attribute, Db2
  Automation Tool defaults SHRLEVEL(CHANGE) to
  SHARELEVEL(REFERENCE) in the Image Copy utility as expected.
  This is the correct behavior.
  For LOB tablespace created with the NOT LOGGED attribute, Db2
  Automation Tool does NOT default the SHARELEVEL(CHANGE) to
  SHARELEVEL(REFERENCE) in the Image Copy utility, thus resulting
  in the job failing with following error:
  DSNU076I -DBP3 223 17:54:14.46 DSNUBAII - KEYWORD=FLASHCOPY
  CONSISTENT INVALID FOR NOT LOGGED TABLE SPACE=DSNXSR.SYSXSRA1
  Expected result: Db2 Automation Tool should default
  SHRLEVEL(CHANGE) to SHRLEVEL(REFERENCE) in the generated JCL and
  issue the following build message:
  HAAB302W - Copy SHARELEVEL(CHANGE) not supported on not logged
  spaces.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Automation Tool z/OS.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Problems with LOB and NOT LOGGED        *
  *                      attributes generating the Image Copy    *
  *                      utility:                                *
  *                      For non-LOB objects created with the    *
  *                      NOT LOGGED attribute, Db2 Automation    *
  *                      Tool defaults SHRLEVEL(CHANGE) to       *
  *                      SHARELEVEL(REFERENCE) in the Image      *
  *                      Copy utility as expected.               *
  *                      This is the correct behavior.           *
  *                      For LOB tablespace created with the     *
  *                      NOT LOGGED attribute, Db2 Automation    *
  *                      Tool does NOT default the SHARELEVEL    *
  *                      (CHANGE) to SHARELEVEL(REFERENCE) in    *
  *                      the Image Copy utility, thus resulting  *
  *                      in the job failing with following       *
  *                      error:                                  *
  *                      DSNU076I -DBP3 223 17:54:14.46          *
  *                      DSNUBAII - KEYWORD=FLASHCOPY            *
  *                      CONSISTENT INVALID FOR NOT LOGGED       *
  *                      TABLE SPACE=DSNXSR.SYSXSRA1             *
  *                      Expected result: Db2 Automation Tool    *
  *                      should default SHRLEVEL(CHANGE) to      *
  *                      SHRLEVEL(REFERENCE) in the generated    *
  *                      JCL and issue the following build       *
  *                      message:                                *
  *                      HAAB302W - Copy SHARELEVEL(CHANGE)      *
  *                      not supported on not logged spaces.     *
  ****************************************************************
  * 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:

Modules/Macros

•    HAAHJG27
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R430 PSY UI60363

     UP18/12/27 P F812

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.