Tuesday 16 April 2013

DB2 DBA training on z/OS  -


DB2 Overview

Introduction to DB2 for z/OS
An Overview of DB2 and Information management


DB2 Concepts

DB2 data Structures
DB2 Tables
An Overview of DB2 and Information management
DB2 indexes
DB2 keys
DB2 views
DB2 schemas and schema qualifiers
DB2 table spaces
DB2 index spaces
DB2 storage groups
DB2 databases
DB2 Synonyms
DB2 Alias


DB2 system objects

DB2 catalog
DB2 directory
Active and archive logs
Bootstrap data set
Buffer pools
Data definition control support database
Resource limit facility database
Work file database

 

DB2 commands

DB2 and related commands like
START DATABASE (DB2)
STOP DATABASE (DB2)
DISPLAY DATABASE (DB2)
ACCESS DATABASE (DB2)


Catalog and Directory


Catalog Tables:
SYS IBM.SYSTABLES
SYS IBM.SYSCOLUMNS
SYS IBM.SYSDATABASE
SYS IBM.SYSSTOGROUP
SYS IBM.SYSTABLESPACE
SYS IBM.SYSINDEXES etc ... in DB2 ver 9.1
Directory Tables:
SPT01
SCT02
DBD01
SYSLGRNX
SYSUTLIX


DB2 Utilities

Introduction to the DB2 utilities

DB2 on line utilities like
CHECK DATA
CHECK INDEX
COPY
COPYTOCOPY
LOAD
UNLOAD
RECOVER
REORG
REPAIR
MODIFY
MERGECOPY
REPAIR , REPORT etc .... All the Utilities ....

DB2 stand-alone utilities like
DSN1CHKR
DSN1COMP
DSN1COPY etc ....


Performance Tuning

Planning your performance strategy
Designing your system for performance
Programming DB2 applications for performance
Tuning your queries
Programming for concurrency
Working with PLAN_TABLE using EXPLAIN statement

SQL statements