DB2 Database Administration

DB2 Overview


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

    DB2 Address Spaces

  • System Services Address Space
  • Database Services Address Space
  • Distributed Datafacility Address Space
  • IRLM Address Space
  • Stored Procedure Address Space

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

Normalization to avoid redundancy


  • First normal form
  • Second normal form
  • Third normal form
  • Fourth normal form

Sytem Privileges and Database privileges


    DB2 administrative authorities

  • SYSADM
  • SYSCTRL
  • DB2 administrative authority
  • DBCTRL
  • DB2 privileges
  • Buffer pool privileges
  • Storage group privileges
  • Database privileges
  • Tablespace privileges
  • Table privileges
  • View privileges
  • Plan privileges
  • Package privileges
  • Stored procedure privileges

DB2 commands


    DB2 and related commands like

  • START DATABASE (DB2)
  • STOP DATABASE (DB2)
  • DISPLAY DATABASE (DB2)
  • ACCESS DATABASE (DB2)

Catalog and Directory Tables like


    Catlog 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 online utilities like

  • CHECK DATA
  • CHECK INDEX
  • COPY
  • COPYTOCOPY
  • LOAD
  • UNLOAD
  • RECOVER
  • REORG
  • REPAIR
  • MODIFY
  • MERGECOPY
  • REPARI , REPORT ect .... All the Utilities ....

    DB2 stand-alone utilities like

  • DSN1CHKR
  • DSN1COMP
  • DSN1COPY etc ....

Perofrmance 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


Tools


  • BMC Suite of products
  • Platinum suite of products
  • IBM suite of products
  • Omegamon for performance tuning
  • JOB schedulers - CA-7, CONTROL-M

Click here to enquire about our online courses

Contact Info

Indus Computer Services
# 87/ 2RT, Khaleel Manzil
SR Nagar, Hyderabad, India - 500 038
Phone (India) : +91-40-40071634, 040-64646341
Mobile: 09948034596
Email: vandukuri@gmail.com