Understanding DB2: Learning Visually with Examples (2nd Edition)

6.7. Review Questions

1:

Which DB2 directory contains information about all the databases you can connect to from a DB2 client machine?

2:

Which command is used to review the contents of the local database directory located in drive H: on a Windows machine?

3:

If the system database directory contains an entry with a type of indirect, what does this say about the entry?

4:

If the SVCENAME database manager parameter has a value of db2_cDB2, which port is being used?

5:

Which communication protocols are supported when connecting from a DB2 Connect gateway to a DB2 for z/OS server?

6:

Why is DB2 Connect Enterprise Edition the recommended DB2 Connect product to use to support 1,000 clients connecting to a DB2 for iSeries server?

7:

Which command can you use to remove an incorrect entry from the DCS directory?

8:

Which command can you use to remove an incorrect entry from the node directory?

9:

Which command can you use to remove an incorrect entry from the system database directory?

10:

In which case would "Search the network" not be an appropriate choice to set up connectivity to your databases?

11:

Given the following command:

catalog tcpip node srv2 remote server2 server db2port

which of the following DB2 directories will be updated?

  1. DCS directory

  2. System database directory

  3. Local database directory

  4. Node directory

12:

Which of the following products will not make use of the DCS directory?

  1. DB2 Connect Personal Edition

  2. DB2 Connect Enterprise Edition

  3. DB2 Personal Edition

  4. DB2 Enterprise Server Edition

13:

The following entry appears in the Windows services file of the DB2 client machine:

db2c_DB2 60000

while the SVCENAME value for the DB2 instance at the server is 50005. Which of the following commands is the correct one to use?

  1. catalog tcpip node mynode remote aries server 60000

  2. catalog tcpip node mynode remote aries server 50005

  3. catalog tcpip node mynode remote aries server db2c_DB2

  4. catalog tcpip node mynode remote aries server 50000

14:

Which of the following commands inserts an entry in the system database directory?

  1. catalog system database directory mydb at node mynode

  2. insert into system db value (mydb)

  3. create database mydb on F:

  4. catalog dcs db mydb

15:

Which of the following commands is required to enable a DB2 server for TCPIP connectivity? (Choose all that apply.)

  1. update dbm cfg using SVCENAME 50000

  2. db2set DB2COMM=TCPIP

  3. connect to sample

  4. ping myhost

16:

Which of the following is not a supported method from the DB2 Configuration Assistant?

  1. Manually configure a connection to a database

  2. Search the network

  3. Use a Profile

  4. Unknown discovery

17:

Which of the following commands is required to prevent the use of the Discover method for a database server from any DB2 client?

  1. update admin cfg using DISCOVER disable (at the server machine)

  2. update dbm cfg using DISCOVER disable (at the server machine)

  3. update admin cfg using DISCOVER disable (at the client machine)

  4. update dbm cfg using DISCOVER disable (at the client machine)

18:

Which of the following commands is required to prevent the use of the Discover method only for database mydb while connected to that database?

  1. update admin cfg using DISCOVER disable

  2. update dbm cfg using DISCOVER disable

  3. update dbm cfg using DISCOVER_INST disable

  4. update db cfg using DISCOVER_DB disable

19:

Which of the following commands removes an entry from the local database directory?

  1. uncatalog local database directory mydb at node mynode

  2. delete from local db where value = 'mydb'

  3. drop database mydb

  4. uncatalog dcs db mydb

20:

The command get dbm cfg | grep DISCOVER returns two lines in my Linux server:

Discovery mode (DISCOVER) = SEARCH Discover server instance (DISCOVER_INST) = ENABLE

Which command prevents this server from using the Discover method against other server machines?

  1. db2 update dbm cfg using DISCOVER_INST disable

  2. db2 update dbm cfg using DISCOVER disable

  3. db2 update dbm cfg using DISCOVER known

  4. db2 update dbm cfg using DISCOVER_INST known

Категории