PM61947: GEN ADB1924E NO STATEMENT TEXT RECORD(S) FOUND FOR CREATE VIEW WHEN RUNNING IN DB2 10 ENFM9

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' GEN command issues a
  message:
  ADB1924E No statement text record(s) found for Create view
  when executed on a DB2 10 subsystem in ENFM9 mode.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Generate (GEN) function on  *
  *                 a View, Materialized Query Table (MQT),      *
  *                 Trigger in DB2 10 Enabling-New-Function      *
  *                 mode (ENFM9).                                *
  *                                                              *
  *                 Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Alter Table (ALT) function  *
  *                 to alter a table that has a Trigger on it in *
  *                 DB2 10 ENFM9 mode.                           *
  *                                                              *
  *                 Users of the DB2 Object Comparison Tool      *
  *                 for z/OS who compare tables that have a      *
  *                 view, the source is from DDL and target is   *
  *                 from the catalog in DB2 10 ENFM9 mode.       *
  *                                                              *
  *                 Users of the DB2 Object Comparison Tool      *
  *                 for z/OS who compare schemas, source is      *
  *                 from DDL and target is from the catalog in   *
  *                 DB2 10 ENFM9 mode.                           *
  *                                                              *
  *                 Users of the DB2 Object Comparison Tool      *
  *                 for z/OS who compare databases with a        *
  *                 view, the source is from DDL and target      *
  *                 is from the catalog in DB2 10 ENFM9 mode.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      GEN command issues a message:           *
  *                                                              *
  *                      ADB1924E No statement text              *
  *                      record(s) found for Create view         *
  *                      when executed on a DB2 10               *
  *                      subsystem in ENFM9 mode.                *
  *                                                              *
  *                      The DB2 Administration Tool for z/OS,   *
  *                      ALT on a table which has a trigger      *
  *                      and after submitting the alter job,     *
  *                      the following error message is          *
  *                      displayed:                              *
  *                                                              *
  *                      Compare Trigger source                  *
  *                      (source_object) and                     *
  *                      target(target_object)                   *
  *                      ADB0380E Module ADB2CMP -               *
  *                      Severe error Alter terminates           *
  *                                                              *
  *                      The DB2 Object Comparison Tool for      *
  *                      z/OS compares the tables that have a    *
  *                      view, source is from DDL and target     *
  *                      is from the catalog, after submitting   *
  *                      the compare job, the following error    *
  *                      message is displayed:                   *
  *                                                              *
  *                      ADB1843E No sysviews row found          *
  *                      for 'Create view'                       *
  *                                                              *
  *                      ADBC026E Severe Error when              *
  *                      generating DDL                          *
  *                                                              *
  *                      The DB2 Object Comparison Tool for      *
  *                      z/OS compares schemas, the source       *
  *                      is from DDL and target is from the      *
  *                      catalog, after submitting the compare   *
  *                      job, the following error message is     *
  *                      displayed:                              *
  *                                                              *
  *                      ADB1649E ADB2REY:  Unexpected           *
  *                      sqlcode in : GEN_UDF Select Max         *
  *                      seqno                                   *
  *                                                              *
  *                      and an SQLCODE=-305 / SQLCODEN305       *
  *                      is displayed:                           *
  *                                                              *
  *                      DSNT408I SQLCODE = -305, ERROR:         *
  *                      THE NULL VALUE CANNOT BE ASSIGNED       *
  *                      TO OUTPUT HOST VARIABLE NUMBER 1        *
  *                      BECAUSE NO INDICATOR VARIABLE IS        *
  *                      SPECIFIED                               *
  *                      DSNT418I SQLSTATE   = 22002             *
  *                      SQLSTATE RETURN CODE                    *
  *                                                              *
  *                      The DB2 Object Comparison Tool for      *
  *                      z/OS, compares the database with a      *
  *                      view, the source is from DDL and        *
  *                      target is from the catalog, after       *
  *                      submitting the job, an ONCODE520 /      *
  *                      ONCODE=520 is displayed:                *
  *                                                              *
  *                      IBM0421S  ONCODE=520  The               *
  *                      SUBSCRIPTRANGE condition                *
  *                      was raised.                             *
  *                      From entry point                        *
  *                      MODIFY_TOKENS at statement              *
  *                      >stmtnumber< at compile unit            *
  *                      offset >offsetaddress< at               *
  *                      entry offset >offsetaddress<            *
  *                      at address >address<                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The GEN function can't create a version file record for the
  View, MQT, or Trigger when executed on a DB2 10 subsystem in
  DB2 10 ENFM9 mode.
  

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

•    ADB2REH  ADB2REM  ADB2REP  ADB2RET  ADB2REY
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK78293

     UP12/04/28 P F204

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.