PQ68221: ABEND0C4 IN AUO#WRDS, INCORRECT SET CURRENT SQLID ON SYNONYM MISSING QUOTE IN VIEW DDL, SQLCODE305 AND AUO#DDL MEMBER.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. An ABEND0C4 was occurring intermittently in module AUO#WRDS
  when selecting a database to restore.
  2. AUO#DDL was updated to include the DROP DATABASE statement.
  3. The wrong SQLID was being issued in the restore DDL for
     SYNONYMS that were originally created with a different
     HI LEVEL QUALIFIER than the creator name.
  4. Long view names, and table names in generated SYNONYM
     DDL were missing the double-quote at the end of the name.
  5. An intermittent SQLCODE305 was occurring when restore DDL was
     generated.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 Object Restore User's                *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. An ABEND0C4 was occurring            *
  *                         intermittently in module AUO#WRDS    *
  *                         when selecting a database to         *
  *                         restore.                             *
  *                                                              *
  *                      2. AUO#DDL was updated to include the   *
  *                         DROP DATABASE statement.             *
  *                                                              *
  *                      3. The wrong SQLID was being issued in  *
  *                         the restore DDL for GRANTS that were *
  *                         originally created with a different  *
  *                         HI LEVEL QUALIFIER than the creator  *
  *                         name.                                *
  *                                                              *
  *                      4. Long view names, and  table names in *
  *                         generated GRANT DDL were missing the *
  *                         double-quote at the end of the name. *
  *                                                              *
  *                      5. An intermittent SQLCODE305 was       *
  *                         occurring when restore DDL was       *
  *                         generated.                           *
  *                                                              *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code changes have been made to correct this problem.
  

Problem conclusion

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

  UQ72376

Modules/Macros

•    AUO#DAGN AUO#DDL  AUO#KAGN AUO#PAGN AUO#SPGN
  AUO#SQLD AUO#TAGN AUO#TAUL AUO#UAGN AUO#VAGN AUO#WRDS AUO@SCPY
  H23L120J
  

Fix information

• Fixed component name

  DB2 OBJECT REST

• Fixed component ID

  5655E7201

Applicable component levels

• R120 PSY UQ72376

     UP02/12/19 P F212

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.