Standby

Overview of DB2 UDB • •

This unit provides a general overview of the IBM DB2 UDB family of products that run on Intel-based and UNIX-based platforms. In the DB2 customization lab, you will create a DB2 system administrator user ID and use it to customize your DB2 system and instance. You will set the system environment variables and update the necessary database manager configuration parameters.

Getting started with DB2 UDB GUIs •

•

This unit provides an introduction to the DB2 UDB tools and identifies the features and functions of the tools. Various ways of accessing the GUI tools and different methods of executing a command or statement in DB2 UDB will be explored. The hands-on labs reinforce the GUI tools and the command interfaces

Creating databases and data placement •

•

When you are ready to implement your database, there are a number of factors that should be considered about the physical environment in which the database will be implemented. These factors include choosing an instance in which you will create your database, how much space will be required to store your data, where data should be physically located, and what kind of tablespace should be used for storing data. This unit will address considerations in these areas. During the lab, you will use the Control Center and Command Center to create a MUSICDB database and associated tablespaces. Also, in the lab, you will select information on tablespaces from the system catalog (SYSCAT) views.

Creating objects •

•

This unit provides information about DB2's physical structure (files and directories), tables, views, etc. Database objects can be created, updated and listed with the Command Line Processor (CLP) or the Command Center graphical tool. During the lab, you will create objects used in a database. The Control Center will be used to create the objects as well as script command files that will be executed from the Command Center.

Moving data •

This unit provides information on tools that can be used to manage table data, including the export utility, import utility, etc.

Recovery •

•

This unit provides you with the information necessary to develop a recovery strategy necessary to support your installation's business requirements. You can use the information in this unit, as well as the product documentation, to plan, define, and implement a recovery strategy. In the lab, you will create backup images of a database and of tablespaces, restore a database from a backup image, rollforward a database/tablespaces to perform full recovery, and perform actions to reactivate databases in exception states.

Monitoring and problem determination •

This unit provides information about DB2 monitoring and problem determination tools. Use of error logs, different monitor types, how to obtain a db2trc, using Explain to assist basic analysis, and additional commands for listing application information will be covered.

Concurrency •

•

This unit addresses the concepts of the DB2 database manager's implementation of locking to ensure data integrity while permitting multiple applications access to data. In order to successfully manage factors that may influence the locking strategies utilized, it is necessary for the database administrator to gain a working knowledge of locking implementation and understand what influences the locking strategies used by the database manager. In the lab, you will use the system monitor to analyze locking occurring on your database. You will use the Control Center and a DB2 Command Window to represent transactions accessing your database. You will use the Snapshot Monitor in order to perform basic lock monitoring, understand the concepts of lock time-outs, and illustrate the concept of deadlocks.

Security •

•

This unit provides information about controlling access to DB2 objects through privileges using either explicit or implicit grants to group IDs and user IDs. The privileges within a database and privileges required for binding/executing a package will be addressed. The various DB2 authorization levels and items to watch out for are discussed in detail. DB2 provides the capability to control access to its data by granting privileges to authorized individuals and groups. In the lab, you will have the opportunity to investigate how privileges can be provided to individual users through the use of variety authority levels. You will administer DB2 authorities (SYSADM, SYSCTRL, SYSMAINT, and DBADM) and identify the functional capabilities of each authority. Many areas concerning DB2 security are addressed.