PK20535: SQLCODE104 WHEN RESTORING LARGE VIEWS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When restoring views with large amounts of text, IBM DB2 Object
  Restore may produce erroneous VIEW DDL.  The generated DDL is
  missing
  the first table column in the view definition text.  This
  happens on
  both V7 and V8 of DB2. Attempting to run the DDL will generate a
  SQLCODE104.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Restore.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: When restoring views with large amounts *
  *                      of text, IBM DB2 Object Restore may     *
  *                      produce erroneous VIEW DDL.  The        *
  *                      generated DDL is missing the first      *
  *                      table column in the view definition     *
  *                      text.  This happens on both V7 and V8   *
  *                      of DB2. Attempting to run the DDL will  *
  *                      generate a SQLCODE104.                  *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

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

Modules/Macros

•    AUO07
  

Fix information

• Fixed component name

  DB2 OBJECT REST

• Fixed component ID

  5655E7201

Applicable component levels

• R210 PSY UK15885

     UP06/07/17 P F607

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.