back to Course Categories | back | print
DB2 (UDB) 8.2 New Features          

Duration: 2 days

Description 
This course is designed to get experienced DB2 professionals up to speed quickly on the new features in DB2 UDB v8.2. New features in management, security, storage and performance are covered.

Topics

  • v8.2 management features
  • SQL language enhancements
  • ALTER TABLE changes
  • Isolation and timeout features
  • Optimize static and dynamic SQL
  • Enhancements to stored procedures and UDFs
  • Performance enhancements
  • Changes with database shared memory
  • Implement self-tuning utilities
  • New functions for visual explain
  • Security enhancements
  • New features in partitioning
  • Implement automatic prefetching
  • Alternate page cleaning
  • Tablespace file system caching options
  • Rebalancing partitioning
  • Volatile tables
  • DMS auto-resize tablespaces
  • FILE containers
  • Monitoring with table functions
  • Multiple storage paths
  • New uniform page sizes
  • Working with containers
  • New db2diag command line tool
  • Snapshot monitor views
  • The ADMIN_CMD stored procedure
  • Enhancements to global temporary tables
  • Utility enhancements
  • Load and unload
  • Changes to REORG, COPY, REPAIR and DSN1COPY
  • Data sharing enhancements
  • db2tapemgr command
  • Database recovery
  • DB2 automatic log management
  • Setting up and managing HADR
  • Linux enhancements

Prerequisites

  • Attendees must have previous experience in DB2/UDB database administration.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design