DB2 for Sybase Administrators, Programmers and Managers "Making the Transitions"

 LENGTH OF COURSE:
3 Days

DESCRIPTION: This course is designed to give students a detailed description of the differences between Sybase and DB2. The course will concentrate on the difference in Architecture, Objects, Internals, and Performance. In addition, students will review the DB2 Program Preparation Steps and how to monotor application operations and performance. During the course students will explore the feature of DB2 that are not in Sybase and vice versa. Students will have an opportunity to discuss conversion techniques and tools that can assist in the migration to DB2.

PREREQUISITES: Working knowledge of Relational Database Technology, Sybase Fundamentals, terminology and facilities.

INSTRUCTION TECHNIQUES: A combination of Lecture, Exercises and Labs.

AUDIENCE

Sybase Database Administrators, Programmers, Analyst, and Managers that need a comprehensive overview of DB2 Architecture, Internals, Features, and Performance.
KEY HIGHLIGHTS:
  • Understand the Relational Database and the DB2 Environment and how this environment is different when compared to Sybase
  • DB2 Architecture Overview
    • Architecture Overview
    • Address Spaces
    • DB2 Catalog & Directory
    • Plans & Package
    • Attachments & Treads
    • Buffer Pools & EDM Pools
    • DB2/390 & DB2 Connect
  • DB2 Relational Implemention
    • Comparison of Sybase
    • Defining Table to DB2
    • Temporary Tables & Usage
    • Data Formats & Types compared to Sybase
    • DB2 Functions: User Defined Functions
    • Nulls & Defaults
    • Table Check Constraints
    • Stored Procedures
    • Edit Procs & Validation Procs
    • RI Establishment and Rules
    • Trigger: Definition and Sybase Differences
  • DB2 Internals & Physical Structure
    • DB2 Objects & Databases
    • Tablespace & 5 Types
    • Storage Group
    • Indexes & Index Spaces
    • Object Heirarchary, Names & Restrictions
    • DB2 Catalog Tables
    • Buffer Pools & Object Internals
    • Page Sets & Page Layouts
    • Pointers, Overflow Rows, Holes
    • Monitor Object Health & Utilities
    • RUNSTATs, REORG, REBIND
    • Index Creation, Types, Monitoring
    • Index Internals


  • Storage Estimates and Utilization
    • DB2 DASD Utilization vs. Sybase
  • DB2 Optimizer & Performance
    • Overview
    • Access Path Selection
    • Relationship between Program and Plan/Package
    • BINDs / REBIND
    • BIND Parameter & Locks
    • Catalog Statistics
    • Utility Implications
    • Predicate Types
    • Index Selection & Utilization
    • DB2 Execution Components
    • SQL Processing: Stage 1 & 2
    • EXPLAIN Overview
    • PLAN_TABLE Specifics
  • DB2 Locking and Difference from Sybase
    • Bind Implications
    • Lock Manager
    • Types, Duration, Scope, Mode
    • Locking Strategies compared to Sybase
  • DB2 Logging
    • Recovery Components
    • Logging Records and Recovery
    • Recovery Types & Scenarios
  • Understand the DB2 Security Environment and use the Grant/Revoke Commands
  • DB2 Auditing
  • DB2 Migration Toolkit



  • Understand Database Administration including:
    • DB2 Utilities & Service Aids
    • Conversion Tools
    • Load and Copy Utilities
    • Recovery Utilities and Parameters
    • DSN1COPY
  • DB2 Reporting Tools
    • User & System


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