Which action can a DBA take to retrieve bufferpool metr…
Which action can a DBA take to retrieve bufferpool metrics information?
Which tool should be used to collect data during a pote…
Which tool should be used to collect data during a potential hang without stopping the database manager?
How is the time that an agent waits for log records to …
How is the time that an agent waits for log records to be flushed to disk calculated?
What information can be obtained by analyzing EXPLAIN data?
What information can be obtained by analyzing EXPLAIN data?
Which statement is true regarding the workload manageme…
Which statement is true regarding the workload management dispatcher?
Which user-managed file system is required for DB2 pure…
Which user-managed file system is required for DB2 pureScale deployments?
what utility should you use to get the status of cluster?
If you are running DB2 in clustered environment, what utility should you use to get the status of cluster?
Which statement about the db2pd tool is true?
Which statement about the db2pd tool is true?
Which system command can be used to locate and return o…
Which system command can be used to locate and return only ADM4500W messages from the DB2
diagnostics log file?
what should be done before issuing the RUNSTATS command…
By analyzing EXPLAIN data, you notice that a table scan is being performed instead of an index scan even
though an index exists. In order to utilize the existing index, what should be done before issuing the
RUNSTATS command to collect statistics for both the index and table?