PrepAway - Latest Free Exam Questions & Answers

what will happen when DB2 attempts to create log file 101?

Refer to the Exhibit

Refer to the logging configuration parameters shown in the exhibit.
If there are currently 100 active log files and there is an error with archiving
log file 1. what will happen when DB2 attempts to create log file 101?

PrepAway - Latest Free Exam Questions & Answers

A.
The database will appear hung because the active log space will be full
and BLK_LOG_DSK_FUL is set to YES. Once log file 1 is archived, DB2 will begin
normal processing.

B.
DB2 will continue normal processing. It will create log file 101 while
attempting to archive log file 1 up to five times. If the fifth attempt to
archive log file 1 to the regular archive location fails, it will be placed
in the FAILARCHPATH location until the regular archive location becomes
available.

C.
DB2 will attempt to archive log file 1 to the regular archive location
up to five times. If log archival still fails after the fifth attempt, the
application will receive a “log full” error and at least one transaction will
be rolled back.

D.
The transaction that prompts DB2 to try and create log file 101 receives
a “log full” error and is rolled back because the active log space is full.
Since the physical log path is not full, the BLK_LOG_DSK_FUL parameter does
not take effect, so the database does not appear hung.


Leave a Reply