DB2 TRAINING

  • Home -
  • Course Details

DB2 DBA Training Syllabus

  • 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 catalog
  • DB2 Directory
  • Active & Archive Logs
  • BSDS
  • Buffer Pools
  • Locks

  • 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

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

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