DB2 FOR LUW / DB2FORLUW / 980 - DB2

sysproc.automaint_get_policyfile call for reorg policy truncates 
the reorg table size value if it contains more than 6 digits. 
 
 
EX: 
 
If you specify the table size as 1 000 000 in the reorg policy 
file as follows: 
 
<?xml version="1.0" encoding="UTF-8"?> 
 
<DB2AutoReorgPolicy 
xmlns="http://www.ibm.com/xmlns/prod/db2/autonomic/config" > 
 <ReorgOptions  dictionaryOption="Keep" indexReorgMode="Offline" 
useSystemTempTableSpace="false" /> 
 <ReorgTableScope  maxOfflineReorgTableSize="1000000"> 
  <FilterClause>TYPE = 'T'</FilterClause> 
 </ReorgTableScope> 
</DB2AutoReorgPolicy> 
 
 
Then run sysproc.automaint_set_policyfile to set the reorg 
profile, it will be set just fine. 
 
db2diag.log entries: 
 
2010-04-02-13.26.25.004933-300 E16367006A783      LEVEL: Warning 
 
PID     : 753892               TID  : 2057        PROC : db2fmp 
(C) 0 
INSTANCE: db2inst1               NODE : 000 
EDUID   : 2057                 EDUNAME: db2fmp (C) 0 
FUNCTION: DB2 UDB, Policy, sqlpiAutomaintSetPolicySpCommon, 
probe:10 
MESSAGE : ADM10515I  The automatic maintenance policy 
"AUTO_REORG" has 
been 
          updated in database "SAMPLE". The policy options have 
been 
updated 
          from "Table Scope: TYPE = 'T'  Reorganization options: 
Keep 
          dictionary  Index Reorganization Mode: Offline  Table 
size 
limit: 
          1000000 KB" to "Table Scope: TYPE = 'T' 
Reorganization 
options: Keep 
          dictionary  Index Reorganization Mode: Offline  Table 
size 
limit: 
          1000000 KB". 
 
 
However, after calling the get policy, we see that the table 
size in the output policy file is truncated: 
 
db2 "call sysproc. 
automaint_get_policyfile( 'AUTO_REORG', 'AutoReorg.xml> 
 
 
AutoReorg.xml contains the following: 
 
<?xml version="1.0" encoding="UTF-8"?> 
 
<DB2AutoReorgPolicy 
xmlns="http://www.ibm.com/xmlns/prod/db2/autonomic/config" > 
 <ReorgOptions  dictionaryOption="Keep" indexReorgMode="Offline" 
useSystemTempTableSpace="false" /> 
 <ReorgTableScope  maxOfflineReorgTableSize="100000"> 
  <FilterClause>TYPE = 'T'</FilterClause> 
 </ReorgTableScope> 
</DB2AutoReorgPolicy> 
 
 
The maximum allowed table size is 10 digits.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* SYSPROC.AUTOMAINT_GET_POLICYFILE CALL FOR REORG POLICY       * 
* TRUNCATESTHE REORG TABLE SIZE VALUE IF IT CONTAINS > 6       * 
* DIGITS                                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V98Fp4                                        * 
****************************************************************

No local fix.

DB2 Version 9.8 Fix Pack 4 for AIX and Linux
 DB2 Version 9.8 Fix Pack 5 for AIX and Linux
 

Fixed in DB2 V98FP4

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

15.07.2011
05.08.2011
05.08.2011

9.8.FP4