PM33675: ALC LOOP IN CONVERT STEP / ST3AC JOB IBM0441W ONCODE=150 THE STRINGSIZE CONDITION ENTRY POINT UPDATE_COLLIST CONVERT_DDL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS ALC commands CONVERT step
  loops with a message:
  IBM0441W  ONCODE=150  The STRINGSIZE condition was raised.
  From entry point UPDATE_COLLIST at statement 5831 at compile
  unit offset +000053E0 at entry offset +000053E0
           at address 34BC9FB0.
           From entry point CONVERT_DDL at statement 2143 at
  compile unit offset +00009C3A at entry offset +00009C3A at
           address 34BD872A.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the ALC line command to alter   *
  *                 a table which has referential constraints.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool's ALC       *
  *                      function loops at the CONVERT step      *
  *                      or ST3AC job with an ONCODE=150         *
  *                      STRINGSIZE condition raised and         *
  *                      ONCODE=350 STRINGRANGE condition        *
  *                      raised from entry point                 *
  *                      UPDATE_COLLIST.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool's ALC function loops at the CONVERT
  step or ST3AC job with an ONCODE=150 STRINGSIZE condition
  raised and ONCODE=350 STRINGRANGE condition raised from entry
  point UPDATE_COLLIST.
  

Problem conclusion

• Program has been modified to resolve the problem.
  

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

•    ADB27AD
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK67984

     UP11/05/26 P F105

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.