Which statement is true regarding client-server database connectivity?
Which statement is true regarding client-server database connectivity?
What can be done to prevent a DB2 Discovery operation from seeing the DEV instance and its databases?
A DB2 for AIX server has two instances named DEV and PROD. Each instance contains a
database named ACCOUNTS and a database named PAYROLL. What can be done to
prevent a DB2 Discovery operation from seeing the DEV instance and its databases?
What authority is required to create, alter and drop workload management objects?
What authority is required to create, alter and drop workload management objects?
Which statement regarding snapshot administrative views and snapshot monitor table functions is true?
Which statement regarding snapshot administrative views and snapshot monitor table
functions is true?
what should be done before issuing the RUNSTATS command to collect statistics for both the index and table?
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?
Which system command can be used to locate and return only ADM4500W messages from the DB2 diagnostics log file
Which system command can be used to locate and return only ADM4500W messages from
the DB2 diagnostics log file?
Which statement about the db2pd tool is true?
Which statement about the db2pd tool is true?
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 user-managed file system is required for DB2 pureScale deployments?
Which user-managed file system is required for DB2 pureScale deployments?
Which statement is true regarding the workload management dispatcher?
Which statement is true regarding the workload management dispatcher?