PQ54598: ADDS RI SUPPORT, DDL SUPPORT FOR SEGSIZE, DSSIZE, MAXROWS, AND AUDITING PARMS: FIXED SQLCODE805 ON BIND, ETC.: SEE DETAILS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR adds support for the following:
  
  1. RI foreign key recovery generation.
  2. RI Primary key recovery generation.
  3. RI Unique key recovery generation.
  
  This APAR corrects the following:
  
  1. "FOR MIXED" DATA parameter in table column definitions was
     getting truncated.
  2. Added support for the generation of CREATE TABLE parameters
     SEGSIZE, DSSIZE, MAXROWS, and AUDITING.
  3. Profile option "Generated binds for dependent plans/packages"
     was not being retained properly.
  4. Corrected behavior of Log Analysis Tool (LAT) interface file
     prompt (was being displayed at incorrect times).
  5. Corrected 805 error when selecting package binds. DBRM AUO@FR
     missing from AUO#BIND sample JCL member in   SAUOSAMP.
  6. Corrected -556 SQL error when revoking execute privilege on
     package.
  7. Corrected problem with grant DDL generated for packages
     (extra semicolons were generated when more then one grant
     was generated).
  8. Corrected -204 SQL error when extraneous DROP SYNONYMS were
     generated subsequent to dropping a view.
  9. Corrected problem where ";" was erroneously generated as a
     separator between the database name and tablespace name when
     both names were 8 characters in length.
  10. Corrected missing "SEGSIZE" clause in generated recovery DDL
      for a segmented tablespace.
  11. Corrected problem with missing Package Privileges.
  12. Corrected duplicate storage groups in DDL comments.
  13. Corrected duplicate generation for storage groups.
  14. Corrected missing name in DROP VIEW statement
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 Object Restore V120 users            *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR adds support for the          *
  *                      following:                              *
  *                                                              *
  *                      1. RI foreign key recovery generation.  *
  *                      2. RI Primary key recovery generation.  *
  *                      3. RI Unique key recovery generation.   *
  *                                                              *
  *                      This APAR corrects the following:       *
  *                                                              *
  *                                                              *
  *                      1. "FOR MIXED" DATA parameter in table  *
  *                          column definitions was gettin g     *
  *                          truncated.                          *
  *                      2. Added support for the generation of  *
  *                         CREATE TABLE parameters SEGSIZE,     *
  *                         DSSIZE, MAXROWS, and AUDITING.       *
  *                      3. Profile option "Generated binds for  *
  *                         dependent plans/packages"  was not   *
  *                          being retained properly.            *
  *                      4. Corrected behavior of Log Analysis   *
  *                         Tool (LAT) interface file prompt     *
  *                         (was being displayed at incorrect    *
  *                         times).                              *
  *                      5. Corrected 805 error when selecting   *
  *                         package binds. DBRM AUO@FR missing   *
  *                         from AUOBIND sample JCL member in    *
  *                         SAUOSAMP.                            *
  *                      6. Corrected -556 SQL error when        *
  *                         revoking execute privilege on        *
  *                         package.                             *
  *                      7. Corrected problem with grant DDL     *
  *                         generated for packages (extra        *
  *                         semicolons were generated when       *
  *                         more then one grant was generated).  *
  *                      8. Corrected sqlcode204 SQL error when  *
  *                         extraneous DROP SYNONYMS were        *
  *                         generated subsequent to dropping     *
  *                         a view.                              *
  *                      9. Corrected problem where ";" was      *
  *                         erroneously generated as a           *
  *                         separator between the database       *
  *                         name and tablespace name when both   *
  *                         names were 8 characters in length.   *
  *                      10. Corrected missing "SEGSIZE" clause  *
  *                          in generated recovery DDL for a     *
  *                          segmented tablespace.               *
  *                      11. Corrected problem with missing      *
  *                          Package Privileges.                 *
  *                      12. Corrected duplicate storage groups  *
  *                          in DDL comments.                    *
  *                      13. Corrected duplicate generation      *
  *                          for storage groups.                 *
  *                      14. Corrected missing name in DROP      *
  *                          VIEW statement.                     *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code changes have been made for these enhancements.
  

Problem conclusion

Temporary fix

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

Comments

• APPLY PTF
  

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$BPRF AUO$DPIX AUO$DPSG AUO$DPTB AUO$DPTS
  AUO$MAIN AUO$MSRT AUO$PRF1 AUO$PRF4 AUO$REST AUO#BIND AUO#BPGN
  AUO#DAUL AUO#DBUL AUO#DDL  AUO#DDL1 AUO#DREC AUO#FIND AUO#IXGN
  AUO#IXUL AUO#KAGN AUO#LOAD AUO#PAGN AUO#PAUL AUO#SGGN AUO#TAUL
  AUO#TBGN AUO#TBUL AUO#TBUX AUO#TSGN AUO#TSUL AUO@FRDB AUO@FRIK
  AUO@FRIP AUO@FRIX AUO@FRRI AUO@FRSG AUO@IODB AUO@IOIX AUO@IOTB
  AUO@IOTS AUO@IOUA AUO@IXUR AUO@RBND AUO@RDDL AUO@RECV AUO@RIGN
  AUOACCEP AUOALLOC AUOAPPLY AUOCNTFL AUODDDEF AUODSNL  AUODSNU
  AUODSN1  AUORECEV AUO00    H23L120J
  

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.