Go to Top

Home

DB2 Training

DB2 DBA Training Syllabus

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

 

Our Clients