PM72315: ALT COMMAND ABENDX37 ON SYSOUT MESSAGE ONCODE150 STRINGSIZE CONDITION ENTRY POINT APPLY_PATHSCHEMA_MASKS / APPLY_RECORD_MASK

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' ALT command can result
  in an ABENDx37:
  IEC030I
  B37-04,IFG0554A,xxxx,xxxxx,SYSOUT,xxxx,xxxxxx,SYSnnnnn.Tnnnnnn.
  Rannn.Taaa.Rnnnnnnn
  ,CEE0374C CONDITION=IBM0441W TOKEN=000101B9 49C9C2D4 00002F6B,
  ,         WHILE RUNNING PROGRAM IBMBERRI WHICH STARTS AT
  when running online or a ONCODE150:
  IBM0441W  ONCODE=150  The STRINGSIZE condition was raised.
           From entry point _Concnvs at compile unit offset
  +00000062 at entry offset +00000062 at address nnnnnnnn.
           From entry point APPLY_PATHSCHEMA_MASKS at statement
  9017 at compile unit offset +000007AE at entry offset
           +000007AE at address nnnnnnnn.
           From entry point APPLY_RECORD_MASKS at statement 7765
  at compile unit offset +00001AEC at entry offset at address
  nnnnnnnn.
  when executed as a batch job when amending an object which has
  a PACKAGE which has a PATH of USER.
  

Local fix

• Rebind the PACKAGE amending the PATH from USER to "USER".
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'Alter Table ALT' (ALT)     *
  *                 command on panel ADB21T 'Tables, Views,      *
  *                 and Aliases'.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      ALT command can result in an ABENDx37   *
  *                      and ONCODE150 / ONCODE=150 error:       *
  *                                                              *
  *                      IEC030I                                 *
  *                      B37-04,IFG0554A,xxxx,xxxxx,SYSOUT,      *
  *                              xxxx,xxxxxx,SYSnnnnn.           *
  *                              Tnnnnnn.                        *
  *                      Rannn.Taaa.Rnnnnnnn                     *
  *                      ,CEE0374C CONDITION=IBM0441W            *
  *                        TOKEN=000101B9 49C9C2D4 00002F6B,     *
  *                      , WHILE RUNNING PROGRAM IBMBERRI        *
  *                        WHICH STARTS AT when running          *
  *                        online or a ONCODE150:                *
  *                      IBM0441W  ONCODE=150  The STRINGSIZE    *
  *                          condition was raised.               *
  *                          From entry point _Concnvs at        *
  *                          compile unit offset +00000062       *
  *                          at entry offset +00000062           *
  *                          at address nnnnnnnn.                *
  *                          From entry point                    *
  *                          APPLY_PATHSCHEMA_MASKS              *
  *                          at statement 9017 at compile        *
  *                          unit offset +000007AE               *
  *                          at entry offset +000007AE           *
  *                          at address nnnnnnnn.                *
  *                          From entry point                    *
  *                          APPLY_RECORD_MASKS                  *
  *                          at statement 7765 at compile unit   *
  *                          offset +00001AEC at entry offset    *
  *                          at address nnnnnnnn.                *
  *                                                              *
  *                      when executing a batch job that has     *
  *                      an amended PACKAGE object whose         *
  *                      PATH option is USER.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 Administration Tool for z/OS module ADBALT will cause a
  loop which results in an ABENDx37 and ONCODE 150 /
  ONCODE=150 error when a table has a package whose PATH
  option is USER.
  

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:

  UK83590 UK83591

Modules/Macros

•    ADB2MSK
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK83590

     UP12/11/21 P F211

• RA20 PSY UK83591

     UP12/11/21 P F211

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.