StorageTek 312564001 manual Resource unavailable condition

•Extended CSA storage used by DB2 Manager (approximately 212k in extended subpool 241) will not be released, and will be unavailable for use by other jobs in the system until the next IPL.

'Resource unavailable' condition

DB2 Manager will return a ‘resource unavailable’ condition to an SQL command which generates access to a migrated row (SQL –652 error and reason code of X'1015' set in field SQLERRD(6) in the SQLCA) in the following circumstances:

1.a row retrieval request requires a new tape cartridge volume to be mounted, but DB2 Manager is unable to allocate a new drive because the MAXTRDR limit has already been reached.

2.a row retrieval request requires access to a tape cartridge volume that is already being processed, but the number of requests already queued for that volume is at the limit specified by the MAXQLEN parameter.

3.allocation recovery has occurred due to lack of available tape cartridge drives, and a reply of 'CANCEL' was made to the IEF238D message.

4.a ‘force purge’ command was issued by the operator for the task currently processing the queue containing the row retrieval request.

5.an immediate DB2 Manager control region shutdown was issued by the operator while a row retrieval request was being processed, or while it was in a task request queue.

6.the DB2 Manager control region is in the process of terminating when the SQL command was issued.

Note that the TAPEWAIT parameter of the TAPECNTL parameter library member may be used to internally queue requests which have been rejected in circumstances 1 to 3 above. In this case a request will be retried until sufficient resources become available to satisfy it, or until the TAPEWAIT interval has been exceeded, at which time it will be rejected as above. Use of this facility may reduce the likelihood of ‘resource unavailable’ conditions occurring.

This page is intentionally left blank

74	DB2 Manager User Guide
	StorageTek Proprietary