Fix (APAR):                IZ94322

Status:                    Fix

Product:                   WBI

Release:                   7.0.0.3

Operating System:          All operating systems

Supersedes Fixes:          

Pre-requisite Fixes:       IZ90994

Exclusive-requisite Fixes: 

CMVC Defect:               IZ94322

Byte size of APAR:         239927

Date:                      2011-02-14

Abstract:                  Shared work item daemon might run into transaction timeout.

Description/symptom of problem:
When the shared work item daemon is running it also checks if there are any unused
cached people assignment criteria results in the database. If any exist they are removed from
the database. Depending on the number of unused cached people assignment criteria the
delete operation might cause a transaction log overflow or a timeout and reports an error
like the following:
WTRN0006W: Transaction 00000001 has timed out after 120 seconds.
WTRN0124I: When the timeout occurred the thread with which the transaction is, or was most recently, associated was Thread[Default : 0,5,main]. The stack trace of this thread when the timeout occurred was: 
java.net.SocketInputStream.socketRead0(Native Method)
java.net.SocketInputStream.read(SocketInputStream.java:141)
com.ibm.db2.jcc.t4.z.b(z.java:200)
com.ibm.db2.jcc.t4.z.c(z.java:260)
com.ibm.db2.jcc.t4.z.c(z.java:371)
com.ibm.db2.jcc.t4.z.v(z.java:1146)
com.ibm.db2.jcc.t4.cb.a(cb.java:60)
com.ibm.db2.jcc.t4.q.a(q.java:50)
com.ibm.db2.jcc.t4.sb.b(sb.java:218)
com.ibm.db2.jcc.am.cn.lc(cn.java:2880)
com.ibm.db2.jcc.am.cn.b(cn.java:3456)
com.ibm.db2.jcc.am.cn.cc(cn.java:715)
com.ibm.db2.jcc.am.cn.executeUpdate(cn.java:698)
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:813)
com.ibm.bpe.database.DbHelper.executeUpdateStatement(DbHelper.java:365)
com.ibm.bpe.database.Tom.cleanupUnusedStaffQueryInstances(Tom.java:983)
com.ibm.bpe.database.WIPatternCleanup.processPatterns(WIPatternCleanup.java:464)
com.ibm.bpe.database.WIPatternCleanup.cleanupInternal(WIPatternCleanup.java:205)
 

NOTE: IBM Installation Manager is required to install this interim.fix (1.4.1 or later recommended). For further details see:
      http://publib.boulder.ibm.com/infocenter/dmndhelp/v7r0mx/index.jsp?topic=/com.ibm.websphere.wps.doc/doc/tins_installingfix_manually.html


NOTE: This interim fix is applicable to both a full WPS installation as well as a WPS client installation.


Directions to apply fix:


1) Shutdown WebSphere. It is important that you perform a controlled and complete shutdown of the server to ensure
   that all transactions have completed, before installing the fix.

2) Extract the .zip file to a directory. For example, extract to C:\temp.

3) Add the fix pack repository location in IBM Installation Manager:
   a. Start IBM Installation Manager.
   b. In Installation Manager, click File > Preferences > Repositories.
   c. Click Add Repository.
   d. Browse to or enter the file path to the repository.config file. The repository.config file is located in the directory where
      you extracted the compressed files. For example, enter C:\temp\repository.config, and then click OK.

4) On the main page of the Installation Manager, click Update.

5) Restart WebSphere


Directions to remove fix:
NOTE:  FIXES MUST BE REMOVED IN THE ORDER THEY WERE APPLIED.  DO NOT REMOVE A FIX UNLESS
       ALL FIXES APPLIED AFTER IT HAVE FIRST BEEN REMOVED.  YOU MAY REAPPLY ANY REMOVED FIX.

Example:  If your system has fix1, fix2, and fix3 applied in that order and fix2 is to be
          removed, fix3 must be removed first, then fix2 may be removed

1) Shutdown WebSphere. It is important that you perform a controlled and complete shutdown of the server to ensure
   that all transactions have completed, before installing the fix.

2) Start IBM Installation Manager.

3) On the main page of the Installation Manager, click Unistall.

4) Select the package to uninstall and follow the prompts on screen.

5) Restart WebSphere

Directions to re-apply fix:

1) Shutdown WebSphere. It is important that you perform a controlled and complete shutdown of the server to ensure
   that all transactions have completed, before installing the fix.

2) Extract the .zip file to a directory. For example, extract to C:\temp.

3) Add the fix pack repository location in IBM Installation Manager:
   a. Start IBM Installation Manager.
   b. In Installation Manager, click File > Preferences > Repositories.
   c. Click Add Repository.
   d. Browse to or enter the file path to the repository.config file. The repository.config file is located in the directory where
      you extracted the compressed files. For example, enter C:\temp\repository.config, and then click OK.

4) On the main page of the Installation Manager, click Update.

5) Restart WebSphere.


Additional Information: