DB2 UDB for z/OS from an Operations Perspective

 LENGTH OF COURSE:
2 Days

DESCRIPTION: The course will concentrate on the operations aspects of DB2 and DB2 Objects. In addition, students will learn commands and utilities that are critical to the DB2 production environment.

PREREQUISITES: Students should have a basic understanding of DB2 Terminology and Concepts.

INSTRUCTION TECHNIQUES: A combination of Lecture, Demonstration, and Labs (when/where available).

AUDIENCE

This course is designed for the Computer Operator, Analyst, or Administrator that needs to gain better understanding of the DB2 environment and architecture.
KEY HIGHLIGHTS:
  • DB2 Architecture and Objects
  • The DB2 Architecture
  • DB2 Attachments
  • DB2 Objects
  • Table Spaces Types and Performance
  • DB2 Storage Groups and Databases
  • DB2 Systems Object and Catalog
  • DB2 Internal Components
  • DB2 VSAM Dataset and Page Set
  • Space Map Page and Data Pages
  • DB2 Pointers, Index Structure and Concerns
  • Monitoring Clustering
  • Index Physical Structure and Subpages
  • SQL Processing and Performance
  • DB2 Address Spaces
  • Database Services and SQL
  • Response Time and Throughput
  • Improving your Response Time and Throughput
  • Reducing I/O with RUNSTATS and REBIND
  • RUNSTAT Catalog Updates
  • RUNSTATS and Access Strategies
  • Reducing I/O with CLOSE YES|NO
  • Reducing I/O with Proper Space Reservation


  • How DB2 uses FREE SPACE allocations
  • Reduce I/O with Indexes
  • Buffer Pool Considerations
  • Buffer Pool Thresholds - DWTH and SPTH
  • Buffer Pool Thresholds - DMTH and IWTH
  • Database Referential Integrity
  • DB2 Utilities and Commands
    • DSN Commands
    • DCLGENs
    • BINDs
    • REBINDs
    • FREE
    • RUN and END
    • SPUFI
    • ARCHIVE LOG
    • DISPLAY
    • RECOVER
    • CANCEL
    • START
    • TRACE
    • STOP
    • DSNC Commands
    • TSO CLISTS
    • OS/390 DB2 Commands




FROM OUR STUDENT EVALUATIONS...
"Instructor was outstanding! One of the very best I've seen."

Ernie Aubert
County of Santa Clara

Return to Home Page.
Return to Alphabetic Listing of Courses.
Return to Courses by Subject.
Request More Information or Contact Us.