Fix (APAR):  PI35667

Status:  Fix

Release:  8.5.5.5

Operating System:  AIX,HP-UX,IBM i,Inspur K-UX,Linux,Mac OS,Solaris,Windows,z/OS

Supersedes Fixes:  

CMVC Defect:  xxxxxx

Byte size of APAR:  279700

Date: 2015-03-12

Abstract:  poor transaction performance when storing transaction logs in an a database

Description/symptom of problem:  
PI35667 resolves the following problem:

ERROR DESCRIPTION:                                              
When using a database to store transaction logs, poor           
performance may be observed.  Database performance analysis     
suggests that indexes could be used to improve performance.     

LOCAL FIX:                                                      

PROBLEM SUMMARY

USERS AFFECTED:
 All users of IBM WebSphere Application
Server

PROBLEM DESCRIPTION:
Poort performance when using a
database to store transaction logs.

RECOMMENDATION:
None

Performance issues accessing transaction logs can be observed
when these logs are stored in a relational database.
Performance can be significantly improved if the tables
related to the transaction logs are indexed.

PROBLEM CONCLUSION:                                             
This APAR Applies indexing to the tables related to transaction 
logging in a relational database to improve performance.        
                                                                
The fix for this APAR is currently targeted for inclusion in    
fix pack 8.0.0.11 and 8.5.5.6.  Please refer to the Recommended 
Updates page for delivery information:                          
                                                                
http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980   


Directions to apply fix:  
NOTE: Mark with an X the:
1) Release the fix applies to
2) The Editions that apply
3) And then DELETE THIS NOTE

Fix applies to Editions:
Release 8.0
__ Application Server (Express or BASE)
__ Network Deployment (ND)
__ Edge Components
__ Developer

Install Fix to all WebSphere installations unless special instructions are included below.

Special Instructions: None

NOTE:
The user must:
* Logged in with the same authority level when unpacking a fix, fix pack or refresh pack.
* Be at V1.4.3 or newer of the Installation Manager. Certain iFixes may require a newer version of the Installation Manager and the Installation Manager will inform you during the installation process if a newer version is required.

The IBM Information Center can provide details, if needed, on the use of the Installation Manager to apply the iFixes.
http://publib.boulder.ibm.com/infocenter/install/v1r4/index.jsp.  Shutdown WebSphere Application Server before applying the iFixes.  Restart WebSphere Application Server after applying the iFixes.

Directions to remove fix:  

The IBM Information Center can provide details, if needed, on the use of the Installation Manager to remove the iFixes.
http://publib.boulder.ibm.com/infocenter/install/v1r4/index.jsp.  Shutdown WebSphere Application Server before removing the iFixes.  Restart WebSphere Application Server after removing the iFixes.

Directions to re-apply fix:  
1) Shutdown WebSphere Application Server.

2) Follow the Fix instructions to apply the fix.

3) Restart WebSphere Application Server.



Additional Information: