PH08931: DB2 ADMINISTRATION TOOL - CHANGE MANAGEMENT IMPORT DDL WITH 'VALIDATE_DDL' FAILS WITH ONCODE 8097 IN ADB2WVL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CM import DDL with validate_ddl fails with:
  
  FUNCTION = ADB2WVL, LINE 456: Signal error
  
  RC = 8
  
  ZERRMSG =
  ZERRSM = User error
  ZERRLM = One or more statements not successfully validated.
           Please see Report for more details.
  
  CONSISTENCY CHECKS REPORT
  =========================
  ADB2WVL : Processing error. Error Cond raised
  ADB2WVL: oncode is 8097
  
  ERROR condition was raised
   Traceback of user routines:
   Compile Unit
     Entry          Statement  CU offset   Entry offset  Address
     CHAR2INT       15866      +00000188   +00000188     22E0B380
     VALIDATE_CREATE_INDEX
                    5784       +00001B90   +00001B90     22E495D8
     GET_CREATE_OWNER_NAME
                    4751       +00003558   +00003558     22E51458
     VALIDATE_CREATE
                    4039       +0000014E   +0000014E     22E53686
     VALIDATE_STMT  3658       +00000242   +00000242     22E59462
     VALIDATE_DDL   12915      +0000152A   +0000152A     22E1AA92
     ADB2WVL        2866       +00002A78   +00002A78     22E059C8
  
  Note: Statement numbers, offsets and addresses are approximate,
        and may vary somewhat, depending on release, maintenance
        applied and other factors.
  
  ONCODE8097
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who uses CM import DDL              *
  *                 with validate_ddl.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: CM import DDL with validate_ddl=Y       *
  *                      fails with error condition in           *
  *                      CHAR2INT routine when validating        *
  *                      Create Index with partitions.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When running CM import with DDL that includes
  partition range clauses in Create Index and
  validate_ddl = 'Y', an error condition is raised
  and validate fails the CM import.
  
  Messages:
  FUNCTION = ADB2WVL, LINE 456: Signal error
  
  ADB2WVL : Processing error. Error Cond raised
  ADB2WVL : oncode is 8097
  
  Traceback of user routines:
  Compile Unit Entry Statement
           CHAR2INT 15866
           VALIDATE_CREATE_INDEX 5784
           GET_CREATE_OWNER_NAME 4751
           VALIDATE_CREATE 4039
           VALIDATE_STMT 3658
           VALIDATE_DDL 12915
           ADB2WVL 2866
  
  Note: Statement numbers are approximate, and may vary somewhat,
        depending on release or other maintenance applied.
  

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:

  UI63340

Modules/Macros

•    ADB2WVL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI63340

     UP19/06/04 P F906

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.