PI94101: ABEND0C4 RUNNING SYSPROC.ADMIN_INFO_SQL WHEN THE INPUT SQL HAS ENDING COMMENT MARKER "*/" MISSING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ADMIN_INFO_SQL abends when a delimited string contains the
  characters /* without an ending */ in SYSIBM.SYSROUTINES.TEXT of
  an SQL function.
  The abend is 0C4.
  

Local fix

• ensure there is ending "*/" for character string that
  contains "/*"
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 11 for z/OS and Db2 12 for z/OS                      *
  * customers who use the Db2-supplied                           *
  * stored procedure SYSPROC.ADMIN_INFO_SQL                      *
  * or the batch program DSNADMSB to collect                     *
  * Db2 environmental service data either                        *
  * directly or via any of the following                         *
  * tools:                                                       *
  * o Query Environment Capture feature of                       *
  * Data Studio                                                  *
  * o Query Environment Capture feature of                       *
  * Optim Query Workload Tuner                                   *
  * o Capture Query Environment feature of                       *
  * Data Server Manager                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The following problems may occur                             *
  * when running the batch program                               *
  * DSNADMSB or the Db2-supplied                                 *
  * stored procedure                                             *
  * SYSPROC.ADMIN_INFO_SQL:                                      *
  * (1) When generating the CREATE                               *
  * routine DDL from the                                         *
  * SYSIBM.SYSROUTINES.TEXT column,                              *
  * ADMIN_INFO_SQL may fail as follows:                          *
  * o Abends when a forward slash followed                       *
  * by an asterisk is found within a                             *
  * delimited string in                                          *
  * SYSIBM.SYSROUTINES.TEXT                                      *
  * o Omits the character immediately                            *
  * following a bracketed comment                                *
  * in SYSIBM.SYSROUTINES.TEXT                                   *
  *                                                              *
  * (2) When generating the CREATE TABLE                         *
  * DDL, ADMIN_INFO_SQL may truncate the                         *
  * PRIMARY KEY clause as follows:                               *
  * CREATE TABLE ... (                                           *
  * "COL1" ...                                                   *
  * ,"COL2" ...                                                  *
  * ,"COL3" ...                                                  *
  * ,"COL4" ...                                                  *
  * ,"COL5" ...                                                  *
  * ,"COL6" ...                                                  *
  * , PRIMARY KEY ("COL1",                                       *
  * "COL2",                                                      *
  * )                                                            *
  * IN DB1.TS1                                                   *
  * ...                                                          *
  * where the closing ) and columns in the                       *
  * primary key are missing.                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * APPLY PTF                                                    *
  ****************************************************************
  (1) When generating the CREATE routine DDL from the
  SYSIBM.SYSROUTINES.TEXT column of a routine,
  ADMIN_INFO_SQL may fail as follows:
  o Abends when a forward slash followed by an asterisk
  is found in a delimited string in
  SYSIBM.SYSROUTINES.TEXT, because ADMIN_INFO_SQL
  erroneously handles the forward slash followed by an
  asterisk as the beginning of a bracketed comment and
  fails to find the bracketed comment closing marker.
  o Omits the character immediately following a bracketed
  comment.
  (2) When generating the CREATE TABLE DDL, ADMIN_INFO_SQL
  generates a truncated PRIMARY KEY clause, as described
  in the Problem Description of this APAR.
  
  ADMIN_INFO_SQL uses a counter to track the number of
  columns examined so far in an index. However, it does
  not reset this counter to 0 after it finishes processing
  an index and starts processing the next index of the
  same table. Therefore, if an indexed table has a primary
  key and one other index, and it processes the other index
  first before processing the primary key, the PRIMARY KEY
  clause will be truncated with missing columns, because
  the counter would indicate prematurely that all the
  PRIMARY KEY columns have been examined.
  

Problem conclusion

• To address the issues described in the Problem Description
  section of this APAR, DSNADMSB and ADMIN_INFO_SQL are
  modified as follows:
  (1) When generating the CREATE routine DDL from the
      SYSIBM.SYSROUTINES.TEXT column of a routine:
      o A forward slash followed by an asterisk in a delimited
        string is not considered the beginning of a bracketed
        comment.
      o The character immediately following a bracketed comment
        is not omitted.
  (2) When generating the PRIMARY KEY clause of a CREATE TABLE
      DDL, the counter used to track the number of columns
      examined so far in an index is reset to zero when all
      the columns in the index are examined.
  

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:

  UI55475 UI55477

Modules/Macros

• DSN@DMSS DSNADMSS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI55475

     UP18/05/12 P F805 ¢

• RB10 PSY UI55477

     UP18/05/12 P F805 ¢

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.