What is the MAX_LOG database configuration parameter us…
What is the MAX_LOG database configuration parameter used for?
Which command will define the alternate diagnostic data…
Which command will define the alternate diagnostic data directory path as /db2data/db2dump2?
What is the correct procedure for recovering a dropped …
What is the correct procedure for recovering a dropped table when DROPPED TABLE RECOVERY has been
enabled and the database must remain online?
Which command can be used to restore a corrupted databa…
Which command can be used to restore a corrupted database using only the recovery history file?
What must you do?
You have an High Availability and Disaster Recovery (HADR) environment set up and you want to read from the
standby database. What must you do?
what method is used to bring the database back to a con…
If a single node database is actively being used by applications when a power failure occurs, what method is
used to bring the database back to a consistent state once power has been restored?
What command can be used to recover the database and re…
Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting
a “bad page”. DB2DART is performed for the entire database and it appears that several bad pages were
detected in table space TBSP_1. What command can be used to recover the database and repair the
corruption in table space TBSP_1?