StorageTek Lifecycle Director DB2 Manager 312564001 User Manual
74
DB2 Manager User Guide
StorageTek
Proprietary
• 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.
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:
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.
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.
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.
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.
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