|
Problem IC68159
|
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 / 970 - 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: |
SYSPROC.AUTOMAINT_GET_POLICYFILE CALL FOR REORG POLICY
TRUNCATESTHE REORG TABLE SIZE VALUE IF IT CONTAINS > 6 DIGITS |
| Local Fix: |
No local fix. |
| available fix packs: |
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
|
| Solution |
Fixed in DB2 V97FP3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.04.2010
29.09.2010
29.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
