Part 2 ” DB2 UDB Family Fundamentals (Chapters 2 “7)
This section consists of six chapters (Chapters 2 through 7), which are designed to provide you with the concepts you will need to master before you can pass the DB2 UDB V8.1 Family Fundamentals exam (Exam 700).
Chapter 2 is designed to introduce you to the various products that make up the DB2 UDB Family and to the comprehensive toolset provided with DB2 UDB V8.1. In this chapter, you will learn about the various editions of DB2 UDB available, the functionality each edition provides, the functionality each DB2 UDB client component provides, and the purpose of each add-on product that makes up the DB2 UDB Family. You will also see what DB2 UDB GUI tools are available and what each tool looks like on the Windows 2000 operating system, as well as what each tool is designed to be used for.
Chapter 3 is designed to introduce you to the concept of database security and to the various authorization levels and privileges supported by DB2 UDB V8.1. In this chapter, you will learn how and where users are authenticated, how authorities and privileges determine what a user can and cannot do while working with a database, and how authorities and privileges are given to and taken away from individual users and/or groups of individual users.
Chapter 4 is designed to introduce you to the concept of servers, instances, databases, and database objects. In this chapter, you will learn how to create a DB2 UDB database and you will see what a DB2 UDB database's underlying structure looks like, as well as how that structure is stored (physically). You will also learn how to destroy a DB2 UDB database, how to catalog and uncatalog a DB2 UDB database, what kinds of objects can exist in a DB2 UDB database, and what each object available is used for.
Chapter 5 is designed to introduce you to the GUI tools and SQL statements that can be used to create DB2 UDB database objects and manipulate user data. In this chapter, you will learn what SQL is, as well as which SQL statements are classified as Data Control Language (DCL) statements, which statements are classified as Data Definition Language (DDL) statements, and which statements are classified as Data Manipulation Language (DML) statements. You will also learn how DDL, DCL, and DML statements are used to create database objects, control access to the database objects created, and store, manipulate, and/or retrieve data stored in those objects.
Chapter 6 is designed to provide you with everything you need to know about DB2 UDB data types and table constraints. In this chapter you will learn about the various built-in data types available with DB2 UDB V8.1, as well as how built-in data types, user-defined data types, DataLinks, and extenders can be incorporated into a table object's definition. You will also learn what constraints are, what types of constraints are available, and how constraints can be incorporated into a table object's definition.
Chapter 7 is designed to introduce you to the concept of data consistency and to the various mechanisms that DB2 UDB V8.1 uses to maintain data consistency in both single- and multi-user environments. In this chapter you will learn what isolation levels are, what isolation levels are available, and how isolation levels are used to keep transactions from interfering with each other in a multiuser environment. You will also learn how DB2 UDB provides concurrency control through the use of locking, what types of locks are available, how locks are acquired , and what factors can influence overall locking performance.
