PI80619: DB2 ADMINISTRATION TOOL - WSL MISMATCH (ADBC099E) AND PARTIAL ADMIN STATEMENTS IN WSL FOR IDAA RELATED OBJECTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The compare runs fine, the WSL execution fails with the error:
  ADBC099E: WSL mismatch. The WSLs did not compare equally.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration for z/OS     *
  *                 and DB2 Object Comparison Tool for z/OS,     *
  *                 who also use IBM DB2 Analytics               *
  *                 Accelerator (IDAA) for z/OS.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: The Change Management (CM) Batch job    *
  *                      fails during the RUN step due to a      *
  *                      mismatch or incorrect accelerator       *
  *                      related statements in the POSTUTIL      *
  *                      step of work statement list (WSL).      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a single CM batch job is used to register, analyze and
  run a change that involves the drop and create of DB2 tables
  that are also added to an accelerator, specifying the following
  parameters causes failures during run process:
  
  Failure #1: Error ADBC099E / msgadbc099e:
  
  DO_RUNTIME_ANALYZE = "Y";
  ADBC099E: WSL mismatch. The WSLs did not compare equally.
  
  Failure #2: A SQLCODE=-104 / SQLCODEN104:
  
  CONTENT_OF_APPLY_JOBS = "D";
  
  --#ADMIN PROCESS POSTUTIL
    SET CURRENT SQLID='>sqlid<';
       DB1AACC1 INCLUDE >object<;
       DB1AACC1 LOCKMODE TABLESET INCLUDE >object<;
  
  ADB5044I *** INPUT STATEMENT:
        DB1AACC1 INCLUDE >object<;
  sqlerror on DB1AACC1 command, PREPARE function
   DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "DB1AACC1".
   SOME SYMBOLS THAT MIGHT BE LEGAL ARE: >ERR_STMT< >WNG_STMT<
   GET SQL SAVEPOINT HOLD FREE ASSOCIATE
  

Problem conclusion

• Problems have 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:

  UI47483 010PC2Ÿ 010PC2Ÿ UI47484 010PC2Ÿ 010PC2Ÿ 010PC2Ÿ

Modules/Macros

•    ADBGAJOB ADB2CID  ADB2CME  ADB2ISQ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI47483

     UP17/05/25 P F705

• RC10 PSY UI47484

     UP17/05/25 P F705

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.