PrepAway - Latest Free Exam Questions & Answers

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

Refer to the Exhibit.

Refer to the logging configuration parameters shown in the exhibit.
If the active log path was only configured to have enough space for 100 active
log files, what will happen if there are currently 100 active log files and
DB2 needs to create active log file 101?

PrepAway - Latest Free Exam Questions & Answers

A.
The database will appear to be hung because the BLK_LOG_DSK_FUL
configuration parameter is set to YES. Once some active log files are archived,
the database will resume normal operation.

B.
The database will continue normal operation because infinite logging has
been enabled and any logs that will not fit in the active log path will
automatically be created within the OVERFLOWLOGPATH until logs in the active
log path begin to be archived.

C.
The transaction that prompts DB2 to try and create log file 101 will receive
a “log full” error because the active log space and active log path are both
full. The transaction will be rolled back and it’s associated application
will be forced off.

D.
The transaction that prompts DB2 to try and create log file 101 will receive
a “log full” error because the active log path is full. The transaction will
be rolled back and it’s associated application will be forced off.


Leave a Reply