PI14370: CM IMPORT CHANGE GENERATES ERROR MSG AISQ003E - PROCESSING ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS Change Management Import
  Function generates error message:
    AISQ003E - Processing error. Encountered abnormal terminator
               for statements when reading DDL.
    Partial statement = COMMENT ON TABLE table_name IS
               'Deninition:-----------table_name
    ADB2CID - Now terminating
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration for          *
  *                 z/OS and DB2 Object Comparison Tool          *
  *                 for z/OS who use Change Management           *
  *                 (CM) to import a change.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The Import function generates error     *
  *                      message ASQ003E / msgasq003e            *
  *                      when attempting to import a 'COMMENT    *
  *                      ON' statement when there is a '--'      *
  *                      in the COMMENT ON statement:            *
  *                                                              *
  *                      AISQ003E - Processing error.            *
  *                      Encountered abnormal terminator         *
  *                      for statements when reading DDL.        *
  *                      Partial statement =                     *
  *                      COMMENT ON TABLE table_name             *
  *                      IS 'Deninition:-----------table_name    *
  *                        ADB2CID - Now terminating             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The Import function generates error message ASQ003E /
  msgasq003e when attempting to import a 'COMMENT ON'
  statement.
  

Problem conclusion

• The problem has been resolved to support COMMENT ON statement
  when importing a change.
  
  The following AISQxxxx messages have been changed;
  
  AISQ001E - Processing error. Undefined file DDLIN
  
  is changed to:
  
  ADB9601E An undefined file was found in Change Management.
  Check the JCL and then rerun the job.
  
  AISQ002E - Processing error. OnCode:XXX
  
  is changed to:
  
  ADB0351E  Module : ADB2ISQ detected an ONCODE condition
  XXX At YYY.
  
  AISQ003E - Processing error. Encountered abnormal terminator
  for statements when reading DDL.
  
  is changed to:
  
  ADB9600E Change Management can not import statements that are
  in the delta change file.  Contact IBM Software Support and
  provide the delta change file.
  

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:

  UI19178 UI19179

Modules/Macros

•    ADB2ISQ  ADB9000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI19178

     UP14/06/28 P F406

• RB10 PSY UI19179

     UP14/06/28 P F406

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.