DSNJ319I csect name CURRENT ACTIVE LOG DATA SET IS THE LAST AVAILABLE ACTIVE LOG DATA SET. ARCHIVE LOG PROCESSING WILL BE TERMINATED.

Explanation

The -ARCHIVE LOG command was rejected because the current active log is the last available active log data set. To process the command when these conditions exist would cause the Db2 subsystem to exhaust its available active log resources and immediately halt processing.

System action

Processing for the command is terminated. If the situation is not corrected, the Db2 subsystem will issue the DSNJ110E message (if it has not already done so) as the available active log data space reaches critically low levels. Ultimately, message DSNJ111E will be issued when the available active log data space is exhausted, and the Db2 online processing will halt until active log space is made available.

Operator response

To clear this condition, steps must be taken to complete other waiting offload tasks. Once another active log is made available (re-usable) by completing the offload process for it, the command processing for the current active log can proceed.

Execute an MVS Display System Requests command (D R,L for example) to determine the outstanding requests related to the log offload process. Take the necessary action to satisfy any requests, and permit offload to continue. If offload fails to complete normally, or cannot be initiated, notify the systems programmer.

System programmer response

Either correct the problem that is causing the offload process to fail, or add more active log data sets. Note that the latter action requires Db2 to be down and the change log inventory (DSNJU003) utility to be run.

Possible causes for the shortage of active log data space are:
  • Excessive logging. For example, too many users requesting logs at the same time, or too many utilities specifying LOG (YES).
  • Delayed or slow offloading. For example, failure to mount archive volumes, incorrect replies to offload messages, or slow device speeds.
  • Excessive use of the -ARCHIVE LOG command. Each invocation of the command causes the Db2 subsystem to switch to a new active log data set. Excessive use could consume the available active log data space if the resulting offloads were not processed in a timely manner.
  • Off-loads(s) failed (see Operator Response).
  • Insufficient active log space (see Operator Response).

User response

Notify the operator or system programmer.