PI86879: EXECUTING ADMIN TOOL GEN LINE COMMAND ON VIEW MAY RESULT IN ABEND 0C4 OR MESSAGE ADB1848W

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Executing Admin Tool GEN line command on view may result in
  abend 0C4:
  
     CEE3204S The system detected a protection exception (System
  Completion Code=0C4).
         Location:
  
  
           Program Unit:  Entry: IBMPBALD Statement:  Offset:
  +000000AA
  
  Alternatively, the job may result in the following error:
  
  ADB1848W Unformatted DDL will be generated for the following
  view
  because it could not be parsed.
  
              Reason code =  28
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS and DB2 Object Comparison           *
  *                 Tool for z/OS who use GEN on a view          *
  *                 which has dependent views.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: GEN command on a view abends            *
  *                      0C4 / abend0C4 with ONCODE=8094         *
  *                      / oncode8094 or returns message         *
  *                      ADB1848W / msgadb1848w.                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the GEN command on a view which has
  dependent views and the text of dependent views are
  larger than the parent view, program abended with 0C4
  and the message:
  
  IBM0534S ONCODE=8094 Protection exception
            From entry point ADB2PA5 at statement 9605
  
   May also fail with no abend and the message:
  
  ADB1848W Unformatted DDL will be generated for
   the following view because it could not be parsed.
   Please verify the DDL.
   Reason code = 28
  

Problem conclusion

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

  UI50759 UI50760

Modules/Macros

•    ADB2CMT  ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI50759

     UP17/10/03 P F710

• RC10 PSY UI50760

     UP17/10/03 P F710

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.