DB2 Version 6 Update

LENGTH OF COURSE:
2 Days

DESCRIPTION: The course is designed to be a comprehensive evaluation of the DB2 Version 6 product and facilities. The course will concentrate on the differences between V5 and V6. Planning and performance are also discussed.

PREREQUISITES: Prior DB2 Experience or Education. Students should have a good knowledge of DB2 and some experience with Version 4 and 5.

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

AUDIENCE

This course is designed for the Programmer, Analyst, or Administrator that needs to gain better understanding of the DB2 Version 6 product. It is intended for DBAs, analysts, programmers, and systems programmers.
KEY HIGHLIGHTS:
  • DB2 Overview & Summary of Enhancements
  • Overview of Programming Enhancements
  • SQL Differences
  • Performance and availability
    • Data partitions rebalancing
    • Checkpoint frequency
    • Max number of open data sets
    • Variable-length column lengths
    • Better performance for SQL
    • Global temporary tables
  • Capacity enhancements
    • 16-terabyte tables
    • Virtual storage constraint relief
    • Performance and availability
  • Data sharing
    • Group buffer pool duplexing LI>More caching options LI>Space map copy maintenance
  • Data Administration and Management
    • Predictive governing
    • Statement cost estimation
    • DB2 Monitoring
    • Integration of DB2 and Workload Manager delay reporting
    • Default buffer pool for user data and indexes
    • Recovery management
    • DB2 commands enhancements
    • Batch dynamic SQL


  • Network computing Enhancements
    • Better performance for Java applications with SQLJ
    • DRDA support for three-part names
    • Support for encrypted passwords for DRDA clients
    • Improved management of stored procedures
    • More portable applications with extensions to DB2 ODBC support
    • ODBC access to DB2 for OS/390 catalog data
    • Improved support for ODBC applications
    • Multithreading and multiple-context support
    • Improvements for dynamically prepared SQL statements
    • DDF connection pooling
    • Improved monitoring and accounting of DDF
  • WEB Enhancements
    • Web-ready
    • Universal accessibility
    • Business intelligence


  • Object-relational extensions and active data
    • Object-relational extensions for new data types
    • User-defined data types for better business modeling
    • Support for user-defined functions
    • More built-in functions
    • More automation and control of business processes with triggers
    • More flexibility with SQL
    • Powerful business applications
    • Multimedia object support with DB2 Extenders
    • Enhanced business partnerships with independent software developers


FROM OUR STUDENT EVALUATIONS...
"If Robert is representative of Jeff Markiewicz & Associates we at EDS should make sure to use their excellent services often in the future."

Aaron Alanen
VIPS

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