![Close [x]](http://dw1.s81c.com/i/c.gif){kind=small}
Before you start
If you are preparing to take the DB2 DBA certification exam 731, you've come to the right place -- a study hall, of sorts. This series of seven DB2 certification preparation tutorials covers the major concepts you'll need to know for the test. Do your homework here and ease the stress on test day.
This tutorial introduces skills you must have to properly manage a DB2 server. This is the first tutorial in a series of seven tutorials to help you prepare for the DB2 9 for Linux, UNIX, and Windows Database Administration Certification (Exam 731). The material in this tutorial primarily covers the objectives in Section 1 of the exam, Server Management. You can view these objectives at: http://www-03.ibm.com/certify/tests/test_index.shtml.
Topics covered in this tutorial include:
- What data consistency is
- What transactions are and how they are initiated and terminated
- How transactions are isolated from each other in a multi-user environment
- How DB2 9 provides concurrency control through the use of locks
- What types of locks are available and how locks are acquired
- What factors influence locking
You should also review the Resources at the end of this tutorial for more information about DB2 server management.
After completing this tutorial, you should be able to:
- Understand the basic skills of managing DB2 servers, including how to create, drop, start, stop, list, migrate, and update instances.
- Use three methods of configuring DB2 client and server connectivity.
- Manage a DB2 server's access and security.
- Use the Task Center to create tasks that are coded in DB2 commands, OS commands, or MVS shell commands.
- Troubleshoot errors encountered in DB2.
To understand some of the material presented in this tutorial, you should be familiar with the following terms:
- Object: Anything in a database that can be created or manipulated with SQL (for example, tables, views, indexes, packages).
- Table: A logical structure that is used to present data as a collection of unordered rows with a fixed number of columns. Each column contains a set of values, each value of the same data type (or a subtype of the column's data type); the definitions of the columns make up the table structure, and the rows contain the actual table data.
- Record: The storage representation of a row in a table.
- Field: The storage representation of a column in a table.
- Value: A specific data item that can be found at each intersection of a row and column in a database table.
- Structured Query Language (SQL): A standardized language used to define objects and manipulate data in a relational database. (For more on SQL, see the fourth tutorial in this series.
- DB2 optimizer: A component of the SQL precompiler that chooses an access plan for a Data Manipulation Language (DML) SQL statement by modeling the execution cost of several alternative access plans and choosing the one with the minimal estimated cost.
To take the DB2 9 DBA exam, you must have already passed the DB2 9 Fundamentals exam 730. If it's available, we recommend that you take the DB2 Fundamentals tutorial series before starting this series.
Although not all materials discussed in the Fundamentals tutorial series are required to understand the concepts described in this tutorial, you should at least have a basic knowledge of:
- DB2 products
- DB2 tools
- DB2 instances
- Databases
- Database objects
You do not need a copy of DB2 to complete this tutorial. However, you will get more out of the tutorial if you download the free trial version of IBM DB2 9 to work along with this tutorial.
Table of contents
Next steps from IBM
Tags
Use the slider bar to see more or fewer tags.
Popular tags shows the top tags for this particular content zone (for example, Java technology, Linux, WebSphere).
My tags shows your tags for this particular content zone (for example, Java technology, Linux, WebSphere).
Popular tutorial tags |
My tutorial tagsSkip to tags list
Popular tutorial tags |
My tutorial tags
