PK36338: GOC USING PANELID ADB2US01 FOR REORG SHRLEVEL CHANGE FOR MAPPING TABLE DOES NOT PRODUCE WSL DDL WITH THE MAPPING TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• User does a Object Compare and using the GOC5 panelid ADB2USO1
  'Specify Utility Specify Utility Options - REORG TABLESPACE'
  and adds a 'MAPTBL OWNER' and 'MAPTBL NAME' for their reorg
  shrlevel change Utility. The WSL that is created is missing
  the mappingtable value so when WSL is run it gets rc=8 and
  these messages:
  DSNU050I    DSNUGDFL -  REORG TABLESPACE DB4TESTX.TS4TESTX LOG
      NO SORTNUM 4 COPY UNLDDN UTLREC DISCARDDN(UTLDISC)
      WORKDDN(UTLUT1, SORTOUT) SORTDATA SHRLEVEL CHANGE DRAIN_WAIT
      20 RETRY 120 RETRY_DELAY 60 STATISTICS TABLE(ALL) REPORT YES
      UPDATE ALL HISTORY NONE SORTDEVT 3390 COPYDDN(SYSCOPY)
  DSNU071I DSNUGDFL - KEYWORD 'CHANGE' REQUIRES KEYWORD
      'MAPPINGTABLE'
  

Local fix

• Please apply PTF when available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of OC requesting reorg utility         *
  *                 with customization of share level            *
  *                 change.                                      *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: OC execs GOCGCMP and GOCGAJOB modified  *
  *                       to add the mapping table to the        *
  *                      resulting job step for share level of   *
  *                       change.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  OC execs GOCGCMP and GOCGAJOB modified
   to add the mapping table to the
  resulting job step for share level of
   change.
  

Problem conclusion

• The problem has been solved
  

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

•    GOCGAJOB GOCGCMP
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R710 PSY UK22303

     UP07/03/01 P F702

• R720 PSY UK22304

     UP07/03/01 P F702

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.