DB2 UDB for z/OS for Systems Programming Staff

 LENGTH OF COURSE:
5 Days

DESCRIPTION: This course is designed to be a comprehensive overview and evaluation of DB2. The course will view the product from a systems perspective. Students will review the DB2 Architecture, Components, Facilities, Catalog and Attachments. In addition, the instructor will concentrate on the installation and setup of a DB2 subsystem and material relevant to problem determination for DB2 subsystem components.

PREREQUISITES: No prior knowledge of DB2 required.

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

AUDIENCE

This course is designed for Systems Programmers that have little or no experience with DB2. The course will begin with the fundamentals and conclude with advanced issues related to the processing of SQL request via DB2.
KEY HIGHLIGHTS:
  • The DB2 Architecture Review
  • DB2 Address Spaces, Purpose and Processing
    • DSNMSTR - Master
    • DSNDBMI - Database
    • DSNIRLM - Lock Manager
    • DSNDDF - Distributed
    • DSNSPAS - Stored Procedures
  • DB2 Attachments & EXITS
  • DB2 OS/390 TCB usage
  • DB2 Objects
    • System Databases, Catalog, Directory
    • Plans, Packages, Binds, Rebinds
    • Table Spaces Types and Performance
    • DB2 Storage Groups and Databases
    • Proper Definition and use of Indexes
  • DB2 Internal Components
  • DB2 VSAM Dataset and Page Set
  • DB2 Pointers, Index Structure and Concerns


  • Index Physical Structure and Subpages
  • Overview of SQL and how can it be helpful
  • SQL Processing and Performance
  • Database Services and SQL
  • Tablespace Scans and Sequential Prefetch
  • Using SPUFI, QMF and Explain
  • DB2 Space and Calculating Space Requirements
  • Improving your Response Time and Throughput
  • Buffer Pool Considerations
  • DB2 Thresholds
  • Buffer Pools & Hyperpools
  • Parallel I/O Considerations
  • DB2 Data Compression and Facilities
  • Distributed Processing
  • DB2 in the Parallel Sysplex
  • Capacity Planning
  • System Maintenance


  • DB2 Install Process and Panels
  • Operator Commands
  • Logging & Recovery
  • Security
  • Start & Termination
  • Utilities - What they do and how they do it!
  • Diagnostic Analysis
  • Overview of Omegamon DB2
  • IPCS and DB2 System Dumps
FROM OUR STUDENT EVALUATIONS...
"Good instructor, clearly has practicing knowledge of material."

Tony Cooke
Zurich Commercial

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