PH00212: CM BATCH COMPARE ANALYZE ALTER WLM SP IBM0441W ONCODE = 150 STRINGSIZE COMPARE_WLM_ENV ADB2PA PARSE ERROR TRIGGER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A CM Batch or Object Compare analyze job including an ALTER
  PROCEDURE...WLM ENVIRONMENT statement for a stored procedure
  may lead to two issues:
  1.  ONCODE 150 / ONCODE150 error:
  IBM0441W  ONCODE=150  The STRINGSIZE condition was raised..
           From entry point COMPARE_WLM_ENV at statement 20404 at
  compile unit offset  >offset< at address >address<
           From entry point COMPARE_STPS at statement 6895 at
  compile unit >offset< at address >address<
  Note: Statement numbers are approximate, and may vary somewhat,
  depending on release or other maintenance applied.
  2.   Parse errors for triggers that reference the stored
  procedures:
  ADB2PA: The following statement could not be parsed :
  (Create Trigger statement follows)
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 V12.1 Change Management batch                *
  *                 function, or users of the DB2 Object         *
  *                 Comparison Tool for z/OS V12.1.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: When comparing stored procedures        *
  *                      and their related base triggers, two    *
  *                      errors may arise:                       *
  *                                                              *
  *                      1. A parser error on the triggers that  *
  *                      reference the stored procedures.        *
  *                                                              *
  *                      2. ONCODE 150. The STRINGSIZE condition *
  *                      was raised from entry COMPARE_WLM_ENV.  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following issues are addressed:
  
  1. A number of parse errors for triggers that reference the
  stored procedures:
  
     ADB2PA: The following statement could not be parsed :
  
  2. An Oncode 150 error:
  
   IBM0441W ONCODE=150 The STRINGSIZE condition was raised..
   From entry point COMPARE_WLM_ENV at statement 20404
  
   From entry point COMPARE_STPS at statement 6895
  
  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:

Modules/Macros

•    ADB2CMS  ADB2REM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI58622

     UP18/09/26 P F809

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.