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: SQL - 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
    Computer Exercise (optional): QMF

Course information: G-551 / 3 Days   These Materials © Copyright 2007 by Hunter Cobb    V6.x

Course Objectives
Course description
Home page

this page last updated: 02 February, 2007
this page copyright © 2007 by The Trainer's Friend, Inc.