PH01256: DDL GEN CANNOT COMPLETE VIEW ADB1847E PARSER ERROR REASON CODE = 8 ADB1664E INTERNAL ERROR ADB1873E

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An attempt to execute DDL or GEN on a view may result in
  following error message:
  ADB1847E GEN CANNOT COMPLETE
  ADB1847E A parser error has occurred for the following view.
  GEN cannot complete
              Reason code =8
              viewname
  The following error messages may also be produced:
  ADB1664E An internal error occurred. Diagnostic
  text=ADB2REH.REBIND_PLAN (10681):  :INTERR00000003PL.
              Reason code = 4
  ADB1646E An error has occurred while generating DDL for an
  object.
  ADB1873E Processing ended but not all supplied catrows were
  used.
              Reason code = 24
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool         *
  *                 for z/OS who use the GEN command.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: When running GEN command on             *
  *                      a view, GEN may issue the               *
  *                      following error message                 *
  *                                                              *
  *                      ADB1847E GEN CANNOT COMPLETE            *
  *                                                              *
  *                      ADB1847E A parser error has             *
  *                      occurred for the following view.        *
  *                      GEN cannot complete                     *
  *                                                              *
  *                      Reason code = 8                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  If a view's text contains a reference to a column without
  its table as a qualifier, the parser may not be able to resolve
  the type of the column, and the above ADB1847E error
  messages may be issued.
  
  The following error messages may also be produced:
  
  ADB1664E An internal error occurred. Diagnostic
  text=ADB2REH.REBIND_PLAN (10681):
       :INTERR00000003PL.
       Reason code = 4
  
  ADB1646E An error has occurred while
  generating DDL for an object.
  ADB1873E Processing ended but not all
  supplied catrows were used.
         Reason code = 24
  
  Here is an example of the view text:
  
  CREATE VIEW S1
  ..
  FULL JOIN "CASE" C ON ABC_XYZ = DE_XYZ
  where ABC_XYZ cannot be resolved by the parser.
  

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

•    ADB2PA   ADB2PA7  ADB2RE   ADB2REE  ADB2REG
  ADB2REH  ADB2REM  ADB2REZ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI58928

     UP18/10/12 P F810

• RC10 PSY UI58929

     UP18/10/12 P F810

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.