00E30508

Explanation

Db2 was unable to process the SQL statement because the number of concurrent active threads exceeded the exception threshold for the MONITOR THREADS keyword in a monitor profile for one of the following filtering scopes.

  • COLLID
  • PKGNAME
  • COLLID_PKGNAME
  • CLIENT_APPLNAME
  • CLIENT_USERID
  • CLIENT_WRKSTNNAME

System action

When the MONITOR THREADS exception threshold value is set to zero, the connection is terminated.

Otherwise, the connection remains active and the thread is queued until other threads deallocate or go inactive, providing an available slot. The thread resumes when a slot becomes available and the number of the concurrent active threads goes below the profile exception threshold, unless another thread is next in the queue. Db2 queues and suspends the number of the concurrent active threads up to the profile exception threshold. Once it is exceeded, Db2 rejects the connection request and returns SQLCODE -30041.

In both cases, Db2 issues message DSNT772I.

Operator response

Notify the system programmer.

System programmer response

Review the information provided in message DSNT772I.

Determine if there are sufficient threads allowed for the applicable filtering scope or scopes. If additional threads are required:

  1. Increase the MONITOR THREADS exception threshold value in the SYSIBM.DSN_PROFILE_ATTRIBUTES table.
  2. Issue the START PROFILE command to refresh the exception threshold value.

Application programmer response

If the connection is terminated, review the information provided in SQLCODE -30041. Retry the connection request.