DSNJ008E nn OF mm ACTIVE LOGS ARE FULL. ssname NEEDS ARCHIVE SCRATCH. REPLY Y WHEN DEVICE READY OR N TO CANCEL.

Explanation

The installation has requested a WTOR before archive log data set allocation. Db2 needs a scratch volume for offloading an active log data set.

ssname
The name of the Db2 subsystem.
nn
The number of full active log data sets.
mm
The total number of active log data sets.

System action

The offload task waits for the operator's reply.

Operator response

The operator has three options:
  • Get a scratch volume ready, make sure there is an available unit for the volume, and reply 'Y'. Db2 then continues with the offload.
  • Determine from the number of active log data sets available whether the offload can be delayed until the next time an active log data set becomes full. If the process can be delayed, then reply 'N'.
    This response has two possible effects.
    • If dual archive logging is in effect and this allocation is for a copy 1 archive data set, the 'N' response delays the offload process until the next active log data set becomes full.
    • However, if the copy 1 archive data set has already been allocated and this request is for copy 2, the 'N' response causes the offload to switch to single archive mode (the switch is for this data set only).
  • Defer giving a response. This causes offload to wait before processing. However, because offload is a separate service task, the wait does not affect Db2 performance.

If offloading to DASD, an error has occurred attempting to allocate an archive log data set. Reply 'Y' to receive the error messages.