DB2 FOR LUW / DB2FORLUW / 970 - 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.

SYSPROC.AUTOMAINT_GET_POLICYFILE CALL FOR REORG POLICY 
TRUNCATESTHE REORG TABLE SIZE VALUE IF IT CONTAINS > 6 DIGITS

No local fix.

DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Fixed in DB2 V97FP3

keiner bekannt / siehe Local-Fix

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

26.04.2010
29.09.2010
29.09.2010

9.7.FP3