|
Problem IC77517
|
Status: Closed |
SYSPROC.AUTOMAINT_GET_POLICYFILE CALL FOR REORG POLICY TRUNCATESTHE REORG TABLE SIZE VALUE IF IT CONTAINS > 6 DIGITS |
| product: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* 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 *
**************************************************************** |
| Local Fix: |
No local fix. |
| available fix packs: |
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Solution |
Fixed in DB2 V98FP4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.07.2011
05.08.2011
05.08.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.8.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.8.0.4
|
 |
