PI85945: IBM0441W ONCODE=150 THE STRINGSIZE CONDITION WAS RAISED EXTRACTING CATALOG STATISTICS VIA GEN WITH MASKING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Extracting DB2 CATALOG STATISTICS with masking via the GEN
  command may result in the following messages:
  
  IBM0441W  ONCODE=150  The STRINGSIZE condition was raised.
            From entry point APPLY_RECORD_MASKS at statement
  21744 at compile unit offset >offset< at entry offset
            >offset> at address >address<.
   IBM0441W  ONCODE=150  The STRINGSIZE condition was raised.
            From entry point APPLY_RECORD_MASKS at statement
  21745 at compile unit offset >offset< at entry offset
            >offset< at address >address<.
   IBM0441W  ONCODE=150  The STRINGSIZE condition was raised.
            From entry point APPLY_STR_MASKV at statement 14850
            at compile unit offset >offset< at entry offset
            >offset< at address >address<.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration for z/OS     *
  *                 who use the GEN function with DB2 catalog    *
  *                 statistics and masking.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Using the GEN function with masking     *
  *                      and with the DB2 catalog statistics     *
  *                      option turned on may result in the      *
  *                      following error:                        *
  *                                                              *
  *                      IBM0441W ONCODE=150 The                 *
  *                      STRINGSIZE condition was raised.        *
  *                      From entry point                        *
  *                      APPLY_RECORD_MASKS at                   *
  *                      statement 22279                         *
  *                      at compile unit offset >offset< at      *
  *                      address >address<.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In DB2 V10 new function mode and with CCSID 1147,
  when the GEN function is used with masking and with the
  DB2 catalog statistics option turned on, the following
  ONCODE 150 error may result:
  
  IBM0441W ONCODE=150 The STRINGSIZE
  condition was raised. From entry point
  APPLY_RECORD_MASKS at statement 22279
  at compile unit offset >offset< at
  address >address<.
  

Problem conclusion

• Problem has been resolved.
  

Temporary fix

Comments

• ×**** PE18/01/24 PTF IN ERROR. SEE APAR PI92812  FOR DESCRIPTION
  ×**** PE18/01/24 PTF IN ERROR. SEE APAR PI92812  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

•    ADBCCM   ADBCP    ADBCRCM  ADBCRSP  ADBCVOC
  ADB2CID  ADB2CMF  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2MSK
  ADB2MSQ  ADB2RE   ADB2REE  ADB2REG  ADB2REH  ADB2REU  ADB2REZ
  ADB2WCL  ADB28MC  ADB28MM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI52220

     UP17/11/30 P F711

• RC10 PSY UI52221

     UP17/11/30 P F711

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.