Which table function can be used to determine whether all of a particular table space? data objects have been
Which table function can be used to determine whether all of a particular table space data objects
have been moved from one storage group toWhich table function can be used to determine
whether all of a particular table space? data objects have been moved from one storage group to
another?
What can be done to prevent applications from failing when DB2 cannot create a new log file?
What can be done to prevent applications from failing when DB2 cannot create a new log file?
What values can be assigned to the HADR_SYNCMODE configuration parameter?
What values can be assigned to the HADR_SYNCMODE configuration parameter?
which database(s)?
With HADR, IBM Tivoli System Automation for Multiplatforms (SA MP) automated failover can be
used with which database(s)?
Which configuration parameter is used to designate a storage area for archived log files that are retrieved fo
Which configuration parameter is used to designate a storage area for archived log files that are
retrieved for recovery purposes?
Which command can now be used to perform the same backup operation?
Prior to migrating to DB2 10.1, a DBA executed the following command on a daily basis: db2_all
“<<-1< db2 BACKUP DATABASE sales TO /mnt/backup” Which command can now be used to
perform the same backup operation?
Which diagnostic tool can be used to show high-watermark consumptions of Fast Communication Manager (FCM) buff
Which diagnostic tool can be used to show high-watermark consumptions of Fast Communication
Manager (FCM) buffers and channels?
What can be used to provide this information?
You need to restore a table space that was backed up earlier, but before you begin a restore
operation you want to determine whether any tables in the table space were populated with a
LOAD … NONRECOVERABLE operation. What can be used to provide this information?
what situation should you use a redirected restore operation?
In what situation should you use a redirected restore operation?
What diagnostic tool would you use to determine which LOAD operation is being problematic?
After starting a series of LOAD operations it appears that one LOAD is failing. What diagnostic tool
would you use to determine which LOAD operation is being problematic?