IT30825: AUTO REORG EVALUATION MAY REPORT TABLE PARTITION SIZE EXCEEDS OFFLINE REORG SIZE CRITERIA BUT LESS THAN MAXOFFLINEREORGTABLESIZE

Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• If Auto Reorg excludes data partitioned tables from automatic
  reorg due to the following error:
               TABLE EXCEEDS OFFLINE REORG SIZE CRITERIA
  
  As seen from either db2trc of the AUTO_REORG evaluation phase or
  as per the health monitor snapshots
  
  The possible cause maybe a mishandling of partition size
  determined from the catalog tables
  
  This can happen when the Table Partition is less than
  maxOfflineReorgTableSize
  
  For little endian systems a very large Data Partition size
  (larger than the 32-bit unsigned
  integer max value, 4 294 967 295) and maxOfflineReorgTableSize
  (larger than 32-bit unsigned integer value / 1024, 4 194 303) is
  required
  
  For big endian systems all partition sizes are susceptible to
  this issue
  
  Non-partitioned tables are not susceptible to this issue
  

Local fix

• No workaround please apply fix
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to db2_v111m4fp6 or later                            *
  ****************************************************************
  

Problem conclusion

• Upgrade to db2_v111m4fp6 or later
  

Temporary fix

Comments

APAR Information

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

  IT30821

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

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSY

     UP

• RB50 PSY

     UP