00E30506

Explanation

Db2 was unable to service the connection request because the number of concurrent active threads exceeded the exception threshold for the MONITOR THREADS keyword in a monitor profile for the LOCATION filtering scope.

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.

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 LOCATION filtering scope. 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, retry the connection request.