DB2 Database Administration

COURSE NUMBER: MFM120

DURATION: 4 Days

TABLE OF CONTENTS

DAY 1

DB2 Architecture

DB2 Environment 9:00 - 9:30 am

Accessing DB2 DB2 Components-1

DB2 Address Spaces DB2 Components-2

DB2 Object Hierarchy DB2 Objects-1

DB2 Physical Space 9:30 - 10 am

DB2 Storage Groups STOGROUPS and

User-defined VSAM-1

User-Defined VSAM Data Sets STOGROUPS and

User-defined VSAM-3

DB2 Bufferpools 10:15 - 10:45 am

Alter Bufferpool Statement Alter Bufferpool-1

Displaying Bufferpool Information Alter Bufferpool-5

DB2 User Privileges 10:45 - 11:45 am

DB2 Authorization Grant DB2 Security and

Authorization-1

DB2 Authorization Ids DB2 Security and

Authorization-2

DB2 Authorization Privileges DB2 Security and

Authorization-3

DB2 Security and Authorization Quiz DB2 Security and

Auth Quiz-1

DB2 New Features 12:45 - 1:15 pm

DB2 V4 New Features DB2 New Features-1

DB2 V5 New Features DB2 New Features-3

DB2 V6 New Features DB2 New Features-6

Data Definition Language

DAY 1 - 1:15 - 4:30 pm

Base Tables Creating & Building-2

DB2 Data Types Creating & Building-6

Creating Constraints Creating & Building-8

Indexes Creating & Building-14

Indexes Exercises Creating & Building-25

Synonyms Creating & Building-27

Views Creating & Building-29

DAY 2

DAY 2 - 8:30 - 10:30 am

Lab - Creating Tables and Indexes Creating & Building-38

DAY 2 - 10:45 - 11:45 am

Type 2 Indexes Additional Topics-1

Partitioned Tablespaces Additional Topics-7

Segmented Tablespaces Additional Topics-10

DAY 2 - 1:00 - 2:15 pm

Lab - DDL Additional Topics Additional Topics-12

IBM Administration Utilities

DAY 2 - 2:30 - 4:30 pm

Using DB2 Utility Screens DB2 Utility Screens-1

DB2 Utility Categories DB2 Utility Screens-3

The DB2 LOAD Utility Features DB2 Load Utility-1

DB2 Load Utility JCL DB2 Load Utility-5

Some DB2 Load Utility Guidelines DB2 Load Utility-7

The DB2 REORG Utility Considerations DB2 Reorg Utility-1

DB2 REORG Utility Online REORG Processing DB2 Reorg Utility-4

Some DB2 REORG Utility Guidelines DB2 Reorg Utility-8

DAY 3

DAY 3 - 8:30 - 10:30 am

The COPY Utility DB2 Image Copy-1

Parallel Image Copy DB2 Image Copy-5

Some Image Copy Guidelines DB2 Image Copy-8

The MERGECOPY Utility DB2 Image Copy-9

DB2 Logging Components DB2 Logging-1

DB2 Log Hierarchy DB2 Logging-3

DB2 RECOVER Utility Overview DB2 Recover Utility-1

DB2 RECOVER Utility Control Statements DB2 Recover Utility-3

DB2 Image Copy, Logging, and Recover Utility Quiz

DAY 3 - 10:45 - 11:45 am

DB2 Backup and Recovery Strategies DB2 Backup and

Recovery Schemes-2

The DB2 STOSPACE Utility Considerations DB2 Stospace Utility-1

The DB2 QUIESCE Utility Considerations DB2 Quiesce Utility-1

DAY 3 - 1:00 - 3:15 pm

Lab - IBM Administration Utilities IBM Utility Lab-1

DB2 Database Administration

Table of Contents

Database Tuning

DAY 3 - 3:30 - 4:30 pm

Explain Plan Optimizing SQL-2

Optimizing SQL Statements Optimizing SQL-7

DAY 4

DAY 4 - 8:30 - 9:15 am

Lab - Using Explain Plan Optimizing SQL-14

DAY 4 - 9:15 - 10:30 am

DB2 Catalog Tables Updated by RUNSTATS DB2 Catalog and Runstats-3

Lab - DB2 Catalog and RUNSTATS DB2 Catalog and Runstats-10

DB2 Stage 1 and Stage 2 Predicates Predicates and Filter Factors-1

DB2 Filter Factors Predicates and Filter Factors-3

DB2 Filter Factors Lab Predicates and Filter Factors-4

DAY 4 - 10:45 - 11:45 am

DB2 Outer Join DB2 Joins-2

DB2 Join Methods DB2 Joins-3

DAY 4 - 1:00 - 2:00 pm

DB2 Joins Lab DB2 Joins-7

DB2 Miscellaneous Topics Day 4 - 2:15 - 4:00 pm

DB2 Catalog Table Analysis DB2 Catalog Table

Statistical Analysis-1

Monitoring DB2 Catalog Tables Reviewing DB2 Catalog

for Performance-1

Optimizer Tasks DB2 Optimizer Tasks-1

Error Handling DB2 Error Handling-1

DB2 Row Locking Row Locking-1

Appendix A

The Plan Table through DB2 V5 Explain Plan Syntax-1

Bibliography Bibliography-1