PI98322: ADMIN TOOL ADB1848W Reason code = 28 ADB2PA PARSER ERROR GEN SCH = %

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using the Admin Tool GEN function to generate all
  schema-based objects, triggers, UDFS, STPs, etc., the following
  error message may be issued by the parser:
                              >table-name<
  ADB1848W Unformatted DDL will be generated for the following
  object because it could not be parsed. Please verify the DDL.
                              Reason code = 28
                              >object-name<
  ADB2PA: The following statement could not be parsed :
  (the statement in question follows.)
  Token number =  >token number<    , Token = >token<
  (A specific error statement relating to the token follows.)
  Note:  This  error occurs only when the parm SCH='%' is
  generated in the JCL.
  

Local fix

• To avoid this error, on panel ADB21, type 'h' to list all schema
  objects.  Then type primary command 'GEN' on the primary
  command line.
  The parameter SCH will be generated in the JCL for each schema,
  e.g.
    SCH=
  'ADB'
   ;
    SCH=
  'ABC'
   ;
   etc.
  With these parameters, the issue of the parser error should not
  occur.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the GEN function.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the GEN function             *
  *                      to generate all schema-based            *
  *                      objects, triggers, UDFs, SPs, etc.,     *
  *                      a parser error may occur.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the GEN function to generate
  all schema-based objects, triggers, UDFS, STPs, etc,
  and the GEN parameter SCH is specified as: SCH='%',
  the following parse error statements may occur:
  
                   >table-name<
   ADB1848W Unformatted DDL will be generated for the following
   object because it could not be parsed. Please verify the DDL.
                   Reason code = 28
                   >object-name<
  
  ADB2PA: The following statement could not be parsed :
  (the statement in question follows.)
  
  Token number = >token number< , Token = >token<
  (A specific error statement relating to the token follows.)
  

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:

  UI57130

Modules/Macros

•    ADB2REP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI57130

     UP18/07/13 P F807

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.