DB2 Universal Database V8.1 Certification Exam 700 Study Guide
| Fifteen percent (15%) of the DB2 UDB V8.1 Family Fundamentals certification exam (Exam 700) is designed to test your knowledge of the different objects that are available with DB2 Universal Database and to test your ability to create a DB2 UDB database. The questions that make up this portion of the exam are intended to evaluate the following:
This chapter is designed to introduce you to instances and databases, to walk you through the database creation process, and to provide you with an overview of the various objects that can be developed once a database has been created. Terms you will learn: System Instance DB2 Database Manager Database Registry Variables Instance Configuration File Database Configuration File Recovery History File Transaction Log Files Buffer Pools Containers Tablespaces Create Database Wizard System Catalog Tables Directory Files System Database Directory Local Database Directory Node Directory Database Connection Services (DCS) Directory Add Database Wizard Access Profiles DB2 Discovery Tables Rows Columns Record Field Value Base Table Result Table Summary Table Declared Temporary Table Typed Table Indexes Views Aliases Schemas Triggers Subject Table Trigger Event Trigger Activation Time Set of Affected Rows Trigger Granularity Triggered Action Transition Variables Transition Tables Trigger Cascading User-Defined Data Types (UDTs) User-Defined Functions (UDFs) Sequences Techniques you will master: Understanding how DB2 UDB databases are created. Understanding how local and remote DB2 UDB databases and servers are cataloged and uncataloged. Understanding what the system database directory, local database directory, node directory, and Database Connection Services (DCS) directory are used for. Recognizing the types of objects that are available and understanding when each is to be used. |