DB2 TRAINING

Introduction to DB2

• Db2 Address
• System Services Address Spaces(DSMNSTR)
• Database Services Address Spaces(DBNDBM1)
• Internal Resources Lock Manager(IRLMPROC)
• Distributed Database Facility(DSNDIST)
• Storage Procedure Address Space(DSNSPAS)

Db2 Physical Objects

• DB2 catalog
• DB2 Directory
• Active & Archive Logs
• BSDS
• Buffer Pools
• Locks

Database Design

• Physical Design process
• Object Design
• Storage Groups
• Databases
• Tables aces
• Tables
• Data types
• Indexes
• View
• Constraints
• Primary key & foreign key
• Program preparation
• Pre compilation
• Bind package & plan

Locking and Concurrency

Security & Control

DB2 Online Utilities

Performance Management

• Performance Management definition
• Monitoring Tools
• Explain Function
• Overview of db2 Governor(RLST)

Tools

• File aid, File
• Pan valet
• XPEditor
• Endeavour, Changeman,RIMS
• CA7
• Strobe
• TERADATA
• INFOX,PROJCL(IBM),$AVRS,SAR
• COOLGEN
• COBTEST,DITTO
• Abendaid
• Easytrieve