G551 DB2 Operations - Topical Outline

DB2 Operations - Topical Outline

Introduction - Overview of DB2

The Sample Databases - Employees and Departments

Overview of DB2 SQL - the SELECT statement: WHERE clause

Basic SPUFI usage

Computer Exercise: Basic SELECTs

DB2 environment overview

DB2 address spaces

DB2 interfaces

DB2 objects

DB2 catalog tables: SYSDATABASE, SYSTABLESPACE, SYSTABLES

SYSCOLUMNS, SYSINDEXES, SYSPACKAUTH, SYSPLANAUTH

Computer Exercise: Querying the Catalog Tables

Application development control flow overview

BIND/REBIND/FREE

Locks and locking

Authorizing Users

Executing a Program

Common Problems

Computer Exercise: BINDing and RUNning a DB2 Program

Backup and recovery

DB2 logs

COMMIT / ROLLBACK

DB2 utilities

DB2 utilities: COPY and MERGECOPY

DB2 catalog table: SYSCOPY

DB2 utilities: RECOVER

DB2 utilities: MODIFY

Computer Exercise: Backup and Recover

DB2 utilities: LOAD

DB2 utilities: REORG, RUNSTATS

DB2 utilities: QUIESCE, CHECK, REPORT

Utility related DB2 commands

Restarting utilities

Common problems

Computer Exercise: Other Utilities

Threads

Thread related commands

Trace related commands

Database related commands

DB2 manuals

SQLCODES, abend codes, reason codes, DSN messages

Problem resolution

Computer Exercise: DB2 Commands

DB2 security

GRANT and REVOKE

Privileges and GRANT option

DB2 catalog tables for security

QMF overview

DB2 VSAM files

Application performance monitoring - EXPLAIN

Optional Computer Exercise: QMF

G551 / 3 Days

Materials version: V6.x

Course Objectives
Course Description
Home page