DB2 UDB/390 Version 9 Transition

Course:  DB2M9
Duration:  2 Days
Level:  II
Course Summary

The course is designed to instruct those delegates who are fairly confident in designing, writing and testing DB2 applications and now need to know the facilities, functions and changes that are available to them with DB2 9. Practical exercises can be provided.

« Hide The Details
Topics Covered In This Course

INTRODUCTION

SQL

  • SELECT FROM UPDATE or SELECT FROM DELETE function
  • INSTEAD OF triggers
  • File reference variables
  • INTERSECT keyword in a fullselect
  • EXCEPT keyword in subselect
  • OLAP specifications for RANK, DENSE_RANK, and ROW_NUMBER
    • RANK and DENSE_RANK
    • ROW_NUMBER
    • COLLATION_KEY function
  • TRUNCATE TABLE statement
  • DECFLOAT built-in data type
  • VARBINARY data type
  • MERGE and SELECT FROM MERGE statements
  • FETCH FIRST n ROWS ONLY and ORDER BY in subselects and fullselects

PERFORMANCE

  • Creating an index on an expression
  • Reduction in CPU processing time for utilities
  • SQL optimization improvements
  • Index changes
    • Index compression
    • Index on expression
    • Larger index page sizes
    • Index key randomization
  • Varying-length rows
  • Sequential key insert
  • Data insert

ENVIRONMENT/SYSTEM CHANGES

  • XML
  • BIGINT data type and function
  • BINARY data type and function
  • Non logged table spaces
  • New language support
  • Large object changes
  • Cloning Tables
  • Universal Tablespaces
  • Reordered Row Format
  • Log changes

OTHER

  • SQL procedures
  • Nested compound statements in SQL procedures
  • Automatic object creation
  • IBM Spatial Support
  • Locking Changes
  • Changes to DB2 Tools
  • Utilities management tools
  • DB2 Automation Tool for z/OS
  • Performance management tools
  • Recovery management tools
  • Application management tools
  • Business analysis tools
  • Information integration tools
  • IBM Optimization Service Center
  • IBM DB2 Optimization Expert
  • Trusted context support
  • Trigger Changes
Who Should Take This Course

IT personnel who need to know DB2 9 facilities and how it might affect them. The course is design so that the first day will cover those changes that will affect both the applications programmers and administrators. The second day will concentrate on those aspects that affect the administrators.

Recommended Prerequisites

Those attending the course should be familiar with DB2.

« Hide The Details
Related Courses
Code Course Title Duration Level
DB2AU
DB2 Administration for Linux, Unix and Windows
5 Days
I
Details
DB2M
Advanced DB2 Application Programming
3 Days
II
Details
DB2ST
DB2 System Performance Tuning
5 Days
II
Details
DB2M10
DB2 10 z/OS Transition
1 Day
II
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]