PI06580: ADBTEP2: REORG TABLESPACE ACTS PRIOR TO REBUILD INDEX, WHEN REDEFINE TS IN BPSIZE AND IX IN PIECESIZE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ADBTEP2: Reorg tablespace acts prior to rebuild index, when
  redefine TS in BPSIZE and IX in PIECESIZE.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and DB2 Object Comparison Tool          *
  *                 for z/OS who try to apply a change that      *
  *                 has a table space in REORG-pending           *
  *                 (REORP) and an index in REBUILD-pending      *
  *                 (RBDP) status at the same time.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: The APPLY job fails when the user       *
  *                      attempts to resolve a table space       *
  *                      in REORG-pending (REORP) and            *
  *                      an index REBUILD-pending (RBDP)         *
  *                      status at the same time while           *
  *                      using the Batch Restart Program         *
  *                      ADBTEP2's ADVISORYAUTOREBUILD and       *
  *                      ADVISORYAUTOREORG options.              *
  *                                                              *
  *                      The job log contains                    *
  *                                                              *
  *                      Return Code 8 / RC = 8,                 *
  *                      ADB5185E / msgadb5185e                  *
  *                      and ADBT010W /                          *
  *                      msgadbt010w errors:                     *
  *                                                              *
  *                      DSNU000I    323 >timestamp< DSNUGUTC -  *
  *                      OUTPUT START FOR UTILITY, UTILID =      *
  *                      C0000001                                *
  *                      DSNU1044I   323 >timestamp< DSNUGTIS -  *
  *                      PROCESSING SYSIN AS EBCDIC              *
  *                      DSNU050I    323 >timestamp< DSNUGUTC -  *
  *                      TEMPLATE ADBREORG DSN >hlq<.>tempname<. *
  *                      &DB..&SN..&UNIQ. DISP(MOD, DELETE,      *
  *                      CATLG)                                  *
  *                      DSNU1035I   323 >timestamp< DSNUJTDR -  *
  *                      TEMPLATE STATEMENT PROCESSED            *
  *                      SUCCESSFULLY                            *
  *                      DSNU050I    323 >timestamp< DSNUGUTC -  *
  *                      TEMPLATE ADBCOPY DSN                    *
  *                      >hlq<.>tempname<.&DB                    *
  *                      ..&SN..&UNIQ. DISP(MOD, CATLG,CATLG)    *
  *                      DSNU1035I   323 >timestamp< DSNUJTDR -  *
  *                      TEMPLATE STATEMENT PROCESSED            *
  *                      SUCCESSFULLY                            *
  *                      DSNU050I    323 >timestamp< DSNUGUTC -  *
  *                      TEMPLATE ADBDISC DSN                    *
  *                      >hlq<.>tempname<.&DB                    *
  *                      ..&SN..&UNIQ. DISP(MOD, CATLG,CATLG)    *
  *                      DSNU1035I   323 >timestamp< DSNUJTDR -  *
  *                      TEMPLATE STATEMENT PROCESSED            *
  *                      SUCCESSFULLY                            *
  *                      DSNU050I    323 >timestamp< DSNUGUTC -  *
  *                      TEMPLATE ADBPUNCH DSN                   *
  *                      >hlq<.>tempname<.                       *
  *                      &DB..&SN..&UNIQ. DISP(MOD, CATLG,       *
  *                      CATLG)                                  *
  *                      DSNU1035I   323 >timestamp< DSNUJTDR -  *
  *                      TEMPLATE STATEMENT PROCESSED            *
  *                      SUCCESSFULLY                            *
  *                      DSNU050I    323 >timestamp< DSNUGUTC -  *
  *                      LISTDEF ADBREORG INCLUDE                *
  *                      TABLESPACES TABLESPACE                  *
  *                      >tablespace name<                       *
  *                      DSNU1035I   323 >timestamp< DSNUILDR -  *
  *                      LISTDEF STATEMENT PROCESSED             *
  *                      SUCCESSFULLY                            *
  *                      DSNU050I    323 >timestamp< DSNUGUTC -  *
  *                      REORG TABLESPACE LIST ADBREORG          *
  *                      SHRLEVEL REFERENCE SCOPE PENDING        *
  *                      UNLDDN ADBREORG                         *
  *                      COPYDDN ADBCOPY PUNCHDDN                *
  *                      ADBPUNCH                                *
  *                      DISCARDDN ADBDISC SORTDEVT              *
  *                      SYSALLDA SORTNUM 5                      *
  *                      DSNU1033I   323 >timestamp< DSNUGULM -  *
  *                      PROCESSING LIST ITEM: TABLESPACE        *
  *                      >tablespace name<                       *
  *                      DSNU214I  -SSID 323 >timestamp<         *
  *                      DSNUGDTC - REBUILD PENDING ON           *
  *                      INDEX >index name<                      *
  *                      PROHIBITS PROCESSING                    *
  *                      DSNU012I    323 >timestamp< DSNUGBAC -  *
  *                      UTILITY EXECUTION TERMINATED, HIGHEST   *
  *                      RETURN CODE=8                           *
  *                      1                                       *
  *                      ADB5185E The run is ending due to       *
  *                      errors.                                 *
  *                      ADBT010W - Rollback performed due to    *
  *                      previous error                          *
  *                                   Additional diagnostics     *
  *                                   NNNINNN                    *
  *                                   commit_all_req=N           *
  *                                   asw_req       =N           *
  *                                   asw_app       =N           *
  *                                   asw_stmt_app  =I           *
  *                                   chk_rec_found =N           *
  *                                   SQLCODE -626? =N           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The APPLY job fails when the user attempts to resolve a table
  table space in REORG-pending (REORP) and index in REBUILD-
  pending (RBDP) status at the same time using ADBTEP2's
  AUTOCHECK, ADVISORYAUTOREBUILD, and ADVISORYAUTOREORG options.
  The APPLY job fails because the resolving sequence is not
  correct.  The REORG TABLESPACE needs to be done before the
  REBUILD INDEX.
  

Problem conclusion

• 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:

Modules/Macros

•    ADBHUPA  ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI27294

     UP15/05/16 P F505

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.