PrepAway - Latest Free Exam Questions & Answers

What will happen if there are currently 100 active log files and DB2 needs to create log file 101?

Refer to the Exhibit.

Refer to the logging configuration parameters shown in the exhibit.
What will happen if there are currently 100 active log files and DB2 needs to create log file 101?

PrepAway - Latest Free Exam Questions & Answers

A.
At least one application will receive a “log full” error and at least one transaction will be rolled
back because the active log space is full.

B.
Log file 101 will go into the OVERFLOWLOGPATH directory since the active log space is full and
infinite logging has been enabled.

C.
The database will appear to be hung since the active log space is full and the BLK_LOG_DSK_FUL
parameter is set to YES.

D.
Log file 101 will be successfully created in the primary log path since infinite logging has been
enabled. Applications will continue processing normally.


Leave a Reply