January 07, 2008
If DB2 9 DBA certificiation is on your list of resolutions this year, spend some time looking over some sample questions to help you prepare. Here are more questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press. The questions are reprinted with permission. Check back each week for more, and try past questions here.
QUESTION 9
Which of the following best describes the function of the db2ls command?
A. It retrieves information about the DB2 products that have been installed on a particular server.
B. It locks a DB2 system and limits access to users who hold System Administrator authority.
C. It generates a list of all remote servers that have been cataloged on a client workstation.
D. It returns the location of the system catalog for a particular database.
QUESTION 10
The Design Advisor can be used to analyze SQL from which two of the following?
A. The EXPLAIN_STATEMENT table
B. A file containing a workload
C. The SYSIBM.SYSPLANS system catalog table
D. The EXPLAIN_STREAM table
E. The ADVISE_WORKLOAD table
Answers
QUESTION 9
The correct answer is A. The system catalog can only be used to obtain information about a specific database. If you want to obtain information at the system level, you must resort to executing administrative system commands or querying the administrative views available. For example, to obtain information about the DB2 products that have been installed on a particular server, you would have to execute the system command db2ls –q -a (if you are on a Linux or UNIX server).
When executed, the db2ls command lists the DB2 products and features installed on your system, including the DB2 Version 9 HTML documentation. You can use the db2ls command to find out where DB2 products are installed on a system, what DB2 product levels are installed, and what specific Db2 products and features were installed using a particular installation path.
QUESTION 10
The correct answers are B and E. The Design Advisor recommends one or more indexes that would improve query/workload performance using current database statistics, the DB2 Optimizer, snapshot monitor information, and/or a specific query or set of SQL statements (known as a workload) you provide. The indexes/MQTs/MDCs recommended, the statistics derived for them, and the data definition language (DDL) statements required to create them can be written to a user-created table named ADVISE_INDEX, if so desired. (If the db2advis command is executed with the –p option specified, the plans that were generated while running the Design Advisor will be saved in the ADVISE_WORKLOAD table and the workload query plans that use the final recommendation to be written to the Explain tables. However, input for the Design Advisor does not come from the Explain tables.)
Trackback Pings
TrackBack URL for this entry:
http://www.ibmdatabasemag.com/blog/main/archives/2008/01/post_7.html
« DB2 LUW Performance: Sorts - The silent performance killer | Main | DB2_CAPTURE_LOCKTIMEOUT »
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.