IBM Support

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

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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.
    

Local fix

  • No local fix.
    

Problem summary

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

Problem conclusion

  • Fixed in DB2 V97FP3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC68159

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-04-26

  • Closed date

    2010-09-29

  • Last modified date

    2010-09-29

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

    IZ75015

  • 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

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC68159

Modified date: 29 September 2010