IBM Assessment DB2 9.7 Advanced DBA for LUW - Assessment Set 1

While attempting to establish connectivity between a Windows client and a UNIX server, the following commands were issued from the Windows client: CATALOG TCPIP NODE node001 REMOTE hostnm01 SERVER 50000; CATALOG DATABASE samp001 AS samp001 AT NODE node001;
TERMINATE;
When trying to connect to the SAMP001 database the following error was received: SQL30061N The database alias or database name name was not found at the remote node. The database name is not an existing database at the remote database node. The statement cannot be processed. What should be done resolve the problem?

A DBA has established connectivity to a DB2 for z/OS database and is exploiting a System z sysplex for load balancing and fault-tolerance. Which series of statements and commands can be issued to ensure that agents remain allocated to help maintain the sysplex server list?

Given INTRA_PARALLEL is OFF, average row length is 900 bytes, and temporary table cardinality is 1000, which setting would prevent a SORTHEAP overflow when the temporary table is sorted?

Setting the DB2_FMP_COMM_HEAPSZ=0 will result in which the following?

 

Which command CANNOT be used to explicitly build a compression dictionary for a table?

What determines the degree of inter-partition parallelism used?

Which statement about compression and temporary tables is NOT correct?

A journaling application inserts data with continually increasing sequential keys while a clean up process randomly deletes erroneous rows. What can be done to maximize insert performance?

Which command will prevent prefetching during crash recovery?

What steps, in the correct order, are performed by the SQL and XQuery compilers to generate executable code for non-federated queries?