March 25, 2008
As the 20th IDUG convention nears, you might be considering taking advantage of the free certification exams that will be offered there. If you're considering the DB2 9 DBA certificiation exam, try your hand at these sample certification questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press and reprinted with permission. Check back each week for more, and try past questions here.
Given the following information about a DB2 server:
Instance name: db2inst1
Port number: 60000
Service name: db2c_db2inst1
Host name: db2host
Host TCP/IP address: 10.205.15.100
Protocol: TCP/IP
Database name: PROD_DB
Assuming the following entry has been made to the services file:
db2c_db2inst1 60000/tcp
Which two of the following commands must be executed to correctly configure communications for the server?
A. UPDATE DBM CFG USING SVCENAME db2c_db2inst1
B. UPDATE DBM CFG USING SVCEPORT 60000
C. db2set DB2COMM=TCPIP
D. UPDATE DBM CFG USING NNAME db2host
E. db2set DB2COMM=TCP/IP
QUESTION 26
Which of the following is NOT a true statement about SMS table spaces?
A. Regular data and long data cannot be split across multiple table spaces.
B. Storage space is allocated by the operating system as it is needed.
C. Containers can be added to or deleted from existing table spaces using the ALTER TABLESPACE command.
D. Only directory containers can be used for storage; file and device containers cannot be used.
Answers
QUESTION 25
The correct answers are A and C. If you choose to manually configure communications, the steps you must follow can vary according to the communications protocol being used. For example, if you wanted to configure a server to use TCP/IP, you would have to perform the following steps:
1. Assign the value TCPIP to the DB2COMM registry variable.
The value assigned to the DB2COMM registry variable is used to determine which communications managers will be activated when the DB2 Database Manager for a particular instance is started. The DB2COMM registry variable is assigned the value TCPIP by executing a db2set command that looks something like this:
db2set DB2COMM=tcpip
2. Assign the name of the TCP/IP port that the database server will use to receive communications from remote clients to the svcename parameter of the DB2 Database Manager configuration file.
The svcename parameter should be set to the service name associated with the main connection port so that when the database server is started, it can determine which port to listen on for incoming connection requests. This parameter is set by executing an UPDATE DATABASE MANAGER CONGIGURATION command that looks something like this:
UPDATE DBM CFG USING SVCENAME db2c_db2inst1
3. Update the services file on the database server.
The TCP/IP services file identifies the ports that server applications will listen on for client requests. If you specified a service name in the svcename parameter of the DB2 Database Manager configuration file, the appropriate service name-to-port number/protocol mapping must be added to the services file on the server. (If you specified a port number in the svcename parameter, the services file does not need to be updated.)
An entry in the services file for a DB2 database server might look something like this:
db2c_db2inst1 50001/tcp
QUESTION 26
The correct answer is C. Additional containers cannot be added to an SMS table space (using the ALTER TABLESPACE SQL statement) once the table space has been created. (Additional containers can be added to a DMS table space after it has been created; when new containers are added, existing data can automatically be rebalanced across the new set of containers to retain optimal I/O efficiency.)
Trackback Pings
TrackBack URL for this entry:
http://www.ibmdatabasemag.com/blog/main/archives/2008/03/r_sanders_14.html
« DB2 LUW Performance: The Death of DB2 | Main | Will declaring things dead ever die? »
This is a public forum. CMP Media and its affiliates are not responsible for and do not control what is posted herein. CMP Media makes no warranties or guarantees concerning any advice dispensed by its staff members or readers.
Community standards in this comment area do not permit hate language, excessive profanity, or other patently offensive language. Please be aware that all information posted to this comment area becomes the property of CMP Media LLC and may be edited and republished in print or electronic format as outlined in CMP Media's Terms of Service.
Important Note: This comment area is NOT intended for commercial messages or solicitations of business.