PrepAway - Latest Free Exam Questions & Answers

Which action does DB2 take and how are the copies of the archive log data sets recorded in the BSDS?

DB2 subsystem DB2A has been defined to run in dual active and dual archive logging modes with
all archive log data sets written to disk. A DB2 archive log offload process on DB2A has
terminated due to an out of space condition on one copy of the archive log. The message shown
below is written to the JES log: DSNJ128I – LOG OFFLOAD TASK FAILED FOR ACTIVE LOG
DB2A.LOGCOPY1.DS02 Which action does DB2 take and how are the copies of the archive log
data sets recorded in the BSDS?

PrepAway - Latest Free Exam Questions & Answers

A.
DB2 continues the offload task in single archive mode; if the offload is successful, only one
copy of archive log data set is recorded in the BSDS.

B.
DB2 truncates both copies of the archive log; both archive data set copies are recorded in the
BSDS.

C.
DB2 attempts to allocate a new archive log data set with a smaller primary space allocation; if
the offload issuccessful, both archive log data set copies are recorded in the BSDS.

D.
DB2 terminates the offload operation immediately; no archive log data set copies are recorded
in the BSDS.


Leave a Reply