IBM Support

IY97841: QUERY PERFORMANCE MAY BE DEGRADED IN HP-PA PLATFORM IF THERE ARE TABLE QUEUES INVOLVED

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In a partitioned environment, After you upgrade to FixPak 12,
    query performance may be degraded if there are table queues
    involved.
    
    For example,  you defined a table t1 with partition key id1,
    then you defined another table t2 with same structure but
    another partition key id2.  In this case, if you run query like
    "insert into t2 select * from t1", you may see performance
    degradation.
    
    If you encounter this problem, you can observe high sys CPU
    usage.
    
    This problem was introduced since FixPak 12 and only exists in
    HP-PA platform.
    

Local fix

Problem summary

  • Users Affected: Users who using DB2 DPF feature in HP-PA
    
    platform Problem Description:
    
    In a partitioned environment, After you upgrade to FixPak 12,
    query performance may be degraded if there are table queues
    involved.
    
    For example,  you defined a table t1 with partition key id1,
    then you defined another table t2 with same structure but
    another partition key id2.  In this case, if you run query like
    "insert into t2 select * from t1", you may see performance
    degradation.
    
    If you encounter this problem, you can observe high sys CPU
    usage.
    
    Problem Summary:
    This problem was introduced since FixPak 12 and only exists in
    HP-PA platform.
    

Problem conclusion

  • Problem was first fixed in Version 9.1 FixPak 3.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IY97841

  • Reported component name

    DB2 UDB ESE HP-

  • Reported component ID

    5765F4103

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / Serviceability

  • Submitted date

    2007-04-24

  • Closed date

    2007-07-26

  • Last modified date

    2008-05-27

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

    IY97505

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

Fix information

  • Fixed component name

    DB2 UDB ESE HP-

  • Fixed component ID

    5765F4103

Applicable component levels

  • R820 PSN

       UP

  • R910 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
08 January 2022