Technote (troubleshooting)
Problem(Abstract)
You added users to groups that control human task ownership or administration. You add users to groups that control human task ownership or administration. After you update the LDAP user registry, you cannot view the human tasks. After you review the log files, you notice a CWTKE0021W warning message.
Symptom
The following message is the complete warning message:
CWTKE0021W: Cannot refresh expired people assignment (staff query result)
In the stack trace, you see the following exceptions:
Exception = com.ibm.bpe.api.WorkItemManagerException
Source = com.ibm.task.core.message.RefreshStaffQueryMessage.processMessage
probeid = 109
Stack Dump = com.ibm.bpe.database.TomSQLException:
com.ibm.db2.jcc.am.SqlException: [jcc][50053][12311][3.59.83] T2zOS
exception: [jcc][T2zos]T2zosResultSet.readFetch_:nativeFetch:3045: DB2 engine SQL error, SQLCODE = -904, SQLSTATE = 57011, error tokens = 00C90096;00000304;WPS01DB .WORKI01 .X'00373F' '.X'28' ERRORCODE=-904, SQLSTATE=57011
Cause
You exceeded the maximum number of locks that can be held per user The error tokens = 00C90096 for object WPS01DB .WORKI01 means you are using ROW level locking.
Diagnosing the problem
The page lock on the page or subpage that is identified by NAME in the DSNT500I message caused the total number of page locks concurrently held to reach the installation maximum number of page locks (NUMLKUS) that are allowed for a single agent in the system.
Resolving the problem
To resolve this issue, your database administrator can increase or decrease the NUMLKUS value. You need to either increase the number of locks that can be held by a user in zparm or decrease the number of locks that are held by the user. To take these actions, use the following statement:
ALTER ... LOCKSIZE TABLE SPACE or LOCK TABLE
Your database administrator can increase or decrease the numlkus values of the following entities:
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.