An employee is not able to connect to the PRODDB database using the correct user ID and password. The TCP/IP protocol is running normally; other remote clients are also having problems connecting to this database. Which two could be the cause of the problem? (Choose two.)

A. The DB2COMM environment variable at the server is not set to TCPIP.

B. The DB2 Administration Server is not started.

C. The port number is not assigned in the server's services file.

D. The client's authentication type is not compatible with the server.

E. The server node and/or database are not cataloged correctly on the client.

What determines the degree of inter-partition parallelism used?

A. The number of database partitions and the definition of partition groups.

B. The number of database connections and the definition of partitions groups.

C. The value of the INTER_PARALLEL Database Manager configuration parameter.

D. The value of the DFT_DEGREE database configuration parameter.

A DBA would like to examine repartitioning options for a partitioned database named PRODDB. Which tool can be used to provide recommendations on re-partitioning?

A. Configuration Advisor

B. Partition Assistant

C. Design Advisor

D. Workload Manager

What would indicate intra-partition parallelism in an Optimizer Plan?

A. BTQ

B. LTQ

C. IP

D. DTQ

What new security authorities have been introduced in DB2 V9.7?

A. WLMADM, ACCESSCTRL, SECADMIN

B. EXPLAIN, SECADMIN, DATAACCESS

C. SECADMIN, ACCESSCTRL, SQLADM

D. WLMADM, SQLADM, EXPLAIN