PI93052: CM BATCH ANALYZE VERIFICATION REXX EXIT FK NAME TRUNCATED IBM0441W ONCODE=150 STRINGSIZE CONDITION COMPUTE_REXX_INP

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When analyzing a CM Batch change which includes an ALTER
  defining  a relatively long foreigh key, and a verification
  rexx exit, the FK name may get truncated in the Verification
  Mask List Report, and the following error may appear in the
  sysout:
  
  IBM0441W ONCODE=150 The STRINGSIZE condition was
  raised.
  
  From entry point COMPUTE_REXX_INPUT at statement 19151 at
  compile unit offset >offset< at entry offset
  >offset< at address
  >address<.
  
  From entry point PROCESS_VER_REXX_EXITS at statement 18712 at
  compile unit offset >offset< at entry offset
  >offset< at address
  >address<.
  
  From entry point VERIFY_VEROVERWRITE at statement 10108 at
  compile unit offset >offset< at entry offset
  >offset< at address
  >address<.
  
  From entry point APPLY_OBJTYPEMASK at statement 18187 at
  compile unit offset >offset< at entry offset
  >offset< at address
  >address<.
  
  From entry point APPLY_RECORD_MASKS at statement 21748 at
  compile unit offset >offset< at entry offset
  >offset< at address
  >address<.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Administration Tool for z/OS who    *
  *                 use the Change Management function to        *
  *                 import and analyze a change, and use a       *
  *                 REXX exit for verification masking.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: When importing and analyzing a          *
  *                      change that includes a foreign          *
  *                      key longer than 40 characters, the      *
  *                      foreign key name gets truncated,        *
  *                      and IBM0441W ONCODE=150                 *
  *                      STRINGSIZE condition message            *
  *                      is issued.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When importing and analyzing a change that includes:
  
   ALTER TABLE >table name<
     FOREIGN KEY FK_>relation name<
      (>columns<)
     REFERENCES <table name>
     (>columns<)
     ON DELETE NO ACTION ENFORCED ;
  
  If the <relation name> is longer than 40 characters, it
  gets truncated to 40 chars in the Verification
  Mask List Report (DD SRVERPRM).
  
  The following messages are also displayed in DD
  SYSOUT:
  
  IBM0441W ONCODE=150 The STRINGSIZE condition
  was raised.
  From entry point COMPUTE_REXX_INPUT at statement
  19151 at compile unit offset >offset< at entry offset
  >offset< at address >address< .
  From entry point PROCESS_VER_REXX_EXITS at
  statement 18712 at compile unit offset >offset< at entry
  offset >offset< at address >address<.
  From entry point VERIFY_VEROVERWRITE at statement
  10108 at compile unit offset >offset< at entry offset
  >offset< at address >address<.
  From entry point APPLY_OBJTYPEMASK at statement
  18187 at compile unit offset >offset< at entry offset
  >offset< at address >address<.
  From entry point APPLY_RECORD_MASKS at statement
  21748 at compile unit offset >offset< at entry offset
  >offset< at address >address<.
  

Problem conclusion

• Problem is resolved to support 128 length for relation name.
  

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:

  UI54251 UI54252

Modules/Macros

•    ADB2MSK
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI54251

     UP18/03/10 P F803

• RC10 PSY UI54252

     UP18/03/10 P F803

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.