PQ55076: FIXES: LOOP ON TBL RECOVERY W/DEPENDENT PKGS, MISSING DSSIZE PARM ON DSN1COPY JCL, SQLCODE181 ON INDEX RECOVERY: SEE DETAILS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This PTF addresses the following problems:
  
  1) Fixed an infinite loop that occurs when the AUO recovery
     option    "Generate Binds for DB2 Object Dependencies" was
     enabled and the    recovery of a table (with dependent
     packages) was requested.
  
  2) Corrected a missing "DSSIZE" parameter on the DSN1COPY
     utility JCL generated by AUO for tablespaces originally
     defined using the DSSIZE parameter.  Prior to this fix,
     the missing "DSSIZE" parm would result in an ABEND upon
     execution of the DSN1COPY utility.
  3) Corrected "Location" and "Collection" field sizes on
     panel AUO$IOBK (Package Bind Like screen).  Location
     field size set to 16 characters.  Collection field
     size set to 18 characters. Field sizes were reversed.
  4) Expanded package privilege selection criteria by adding
     "Location" and "Collection" fields to panel AUO$IOPK
     (Package Privilege Like screen).  Prior to this
     expansion, only the Grantee and/or Package Name fields
     could be used to control Package Privilege selection.
  5) Corrected a SQLCODE181 SQL error on recovery of an index.
     SQL error occurred and the DDL was not being generated
     for the specified index.
  6) Added the ability for AUO to store a new version of an
     object based on a change in the ALTER_TIMESTAMP column.
     Formerly, AUO only stored a new version of an object
     when the CREATE_TIMESTAMP changed.
  7) Fixed error where semicolon delimiter was being omitted
     from the end of a CREATE TABLE statement when table
     contained a "ROWID GENERATED ALWAYS" clause.
  8) Fixed S0C1 ABEND that occurred when a "D" was entered
     on the ISPF command line of the AUO main panel
  9) "ROWID GENERATED ALWAYS" clause was being incorrectly
     generated in recovery DDL as "ROWID GENERATE ALWAYS"
     in DDL for LOB Tablespaces.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 Object Restore V120 Users            *
  ****************************************************************
  * PROBLEM DESCRIPTION: This PTF addresses the following        *
  *                      problems:                               *
  *                                                              *
  *                      1. Fixed an infinite loop that occurs   *
  *                         when the AUO recovery option         *
  *                         "Generate Binds for DB2 Object       *
  *                         Dependencies" was enabled and the    *
  *                         recovery of a table (with            *
  *                         dependent  packages) was requested.  *
  *                      2. Corrected a missing "DSSIZE"         *
  *                         parameter on the DSN1COPY utility    *
  *                         JCL generated by AUO for             *
  *                         tablespaces originally defined       *
  *                         using the DSSIZE parameter.  Prior   *
  *                         to this fix, the missing "DSSIZE"    *
  *                         parm would result in an ABEND upon   *
  *                         execution of the DSN1COPY utility.   *
  *                      3. Corrected "Location" and             *
  *                         "Collection " field sizes on panel   *
  *                         AUO$IOBK (Package Bind Like          *
  *                         screen). Location field size set     *
  *                         to 16 characters. Collection field   *
  *                         size set to 18 characters. Field     *
  *                         sizes were reversed.                 *
  *                      4. Expanded package privilege           *
  *                         selection criteria by adding         *
  *                         "Location" and "Collection" fields   *
  *                         to panel AUO$IOPK (Package           *
  *                         Privilege Like screen).  Prior to    *
  *                         this expansion, only the Grantee     *
  *                         and/or Package Name fields could     *
  *                         beused to control Package            *
  *                         Privilege selection.                 *
  *                      5. Corrected a SQLCODE181 SQL error     *
  *                         on recovery of an index. SQL         *
  *                         error occurred and the DDL was not   *
  *                         being  generated for the specified   *
  *                         index.                               *
  *                      6. Added the ability for AUO to store   *
  *                         a new version of an object based on  *
  *                         a change in the ALTER_TIMESTAMP      *
  *                         column. Formerly, AUO only stored    *
  *                         a new version of an object when the  *
  *                         CREATE_TIMESTAMP changed.            *
  *                      7. Fixed error where semicolon          *
  *                         delimiter was being omitted from     *
  *                         the end of a CREATE TABLE statement  *
  *                         when table contained a "ROWID        *
  *                         GENERATED ALWAYS" clause.            *
  *                      8. Fixed S0C1 ABEND that occurred       *
  *                         when a "D" was entered on the ISPF   *
  *                         command line of the AUO main panel   *
  *                      9. "ROWID GENERATED ALWAYS" clause was  *
  *                         being incorrectly  generated in      *
  *                         recovery DDL as "ROWID GENERATE      *
  *                         ALWAYS" in DDL for LOB Tablespaces.  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code changes have been made for these enhancements
  

Problem conclusion

• APPLY PTF
  

Temporary fix

• *********
  * HIPER *
  *********
  

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

•    AUO$BKLK AUO$DBND AUO$DPPK AUO$MAIN AUO$PKLK
  AUO$PRF1 AUO#DDL  AUO#TSGN AUO@FRBK AUO@FRBP AUO@IOIX AUO@IOPK
  AUO@RDDL AUO@RECV AUO@RIGN AUODSN1
  

Fix information

• Fixed component name

  DB2 OBJECT REST

• Fixed component ID

  5655E7201

Applicable component levels

• R120 PSY UQ61152

     UP01/12/26 P F112 Ž

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.