What command can be used to recover the database and repair the corruption in table space TBSP_1?
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?
what method is used to bring the database back to a consistent state once power has been restored?
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 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?
Which command can be used to restore a corrupted database using only the recovery history file?
Which command can be used to restore a corrupted database using only the recovery
history file?
What is the correct procedure for recovering a dropped table when DROPPED TABLE RECOVERY has been enabled and
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 will define the alternate diagnostic data directory path as /db2data/db2dump2?
Which command will define the alternate diagnostic data directory path as
/db2data/db2dump2?
What is the MAX_LOG database configuration parameter used for?
What is the MAX_LOG database configuration parameter used for?
What unit of measurement is used to represent the cumulative total cost of a node in a Visual Explain access p
What unit of measurement is used to represent the cumulative total cost of a node in a
Visual Explain access plan diagram?
where can you schedule script-based jobs?
In IBM Data Studio, where can you schedule script-based jobs?