| A1: | Besides crash recovery, DB2 also supports version recovery and roll forward recovery. |
| A2: | You can backup the transaction logs along with the database by using the INCLUDE LOGS option in the BACKUP DATABASE command. |
| A3: | Secondary logs are created when needed and are destroyed when the database is restarted. |
| A4: | Log buffer is flushed to log files when the log buffer is full or when the MINCOMMIT number of commits has been issued. Note that MINCOMMIT is a database configuration parameter. |
| A5: | The maximum log space you can configure for a database is 256GB. |
| A6: | You can use the INSPECT command to inspect a database while it is online. |
| A7: | You can either restore from a good database backup or use the db2dart tool to mark the index invalid. Depending on the value of the INDEXREC database parameter, the index will be recreated either when the database is restarted or when the index is being accessed for the first time. |
| A8: | You can find out the minimum recovery time for a table space by using the LIST TABLSPACES SHOW DETAIL command. The time is shown in UTC time. |
| A9: | C. The LOGRETAIN database configuration parameter can be used to enable archival logging. When a log file is no longer active, it should be manually archived to a backup device to avoid the log path being filled up. In addition, you also need to manual retrieve those archived log files when they are required in case of recovery. |
| A10: | A. COMMIT or ROLLBACK (one word) can be used to complete or rollback a unit of work. |
| A11: | B. Circular logging is the default logging method used by DB2. |
| A12: | C. You can use the LOGFILSIZ parameter to customize the size of the log file. |
| A13: | C. FAILARCHPATH specifies a path to which DB2 will try to archive log files if the log files cannot be archived to the archive destinations. |
| A14: | C. Roll forward recovery replays the transactions in the database logs to recover any transactions after the backup was performed. |
| A15: | A. DB2 does not allocate the secondary logs until they are needed, so they would not be allocated immediately after activating the database. DB2 also starts numbering the logs using the number 0, so the correct answer is A. |
| A16: | C. Infinite active logging is activated by setting log second to 1. |
| A17: | C. Archival logging must be enabled in order to perform online backups. Archival logging is enabled by setting LOGARCHMETH1 to a value other than OFF. |
| A18: | C. Archival logging must be enabled in order to perform online backups. Archival logging is enabled by setting LOGARCHMETH1 to a value other than OFF. |
| A19: | B. You cannot change from DMS to SMS or SMS to DMS using a redirected restore. |
| A20: | B. When using local time, it is always local relative to the server. |
| A21: | D. Backup is not a valid option of the db2inidb command. |
| A22: | B. You can use the Mirror option to create a backup image of a source database. |
