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

DB2 UDB Version 8.1 FixPak 16 (also known as Version 8.2 FixPak 9 )

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

• User Affected: All users who use DPF 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

• This problem was first fixed in DB2 UDB V8.1 FixPak 16.
  

Temporary fix

Comments

APAR Information

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

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

  IY97841

Fix information

• Fixed component name

  DB2 UDB ESE HP-

• Fixed component ID

  5765F4103

Applicable component levels

• R810 PSY

     UP

• R910 PSY

     UP

• R950 PSY

     UP

• R820 PSN

     UP