IBM Support

LI73709: AUTOMAINT_SET_POLICY CAN FAIL WITH SQL1131, SQL1438 OR STORES WRONG VALUE FOR MANY ATTRIBUTES IN DB2 V9.5 FP3

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Starting with DB2 V9.5 FP3 AUTOMAINT_SET_POLICY can fail with
    different errors and symptoms on different platforms.
    
    On Linux, you can get errors SQL1131 or SQL1438. The following
    stack will be reported in the trap file:
    
    strtol + 0x0040
    atoi + 0x0021
    _Z19sqlpiGetReorgPolicyPciP16sqlpiReorgPolicy + 0x0290
    _Z28sqpiGetPolicyOldFormatStringPcS_iP5sqlca + 0x0336
    _Z31sqlpiAutomaintSetPolicySpCommonPcS_P13sqludf_dbinfoP5sqlca +
    0x050d
    db2AutomaintSetPolicyDocSpLocal + 0x0325
    sqloInvokeFnArgs + 0x003c
    
    On AIX, the command finishes without error, but will not add the
    correct values for some of the provided atributes to the system.
    
    This APAR was introduced by the fix for APAR IZ26966.
    

Local fix

Problem summary

  • USERS AFFECTED:
    All.
    
    PROBLEM DESCRIPTION:
    Starting with DB2 V9.5 FP3 AUTOMAINT_SET_POLICY can fail with
    different errors and symptoms on different platforms.
    
    On Linux, you can get errors SQL1131 or SQL1438.
    
    On AIX, the command finishes without error, but will not add the
    correct values for some of the provided atributes to the system.
    
    The issue in this APAR was introduced by the fix for APAR
    IZ26966.
    
    PROBLEM SUMMARY:
    See PROBLEM DESCRIPTION.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.5, FixPak 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI73709

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-01-12

  • Closed date

    2009-05-29

  • Last modified date

    2009-06-16

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

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

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2009