G122: DB2 Version 5 to Version 7 Transition for DBAs

TTFlogo2.gif (2585 bytes)

DB2 Version 5 to Version 7 Transitions for DBAs - Topical Outline

Introduction - The Big picture

Schemas
Distinct types
User-defined functions
DSN_FUNCTION_TABLE
Computer Exercise: Distinct Types and User-Defined Functions

Data Base Administration Enhancements - Part 1
    16-terabyte table spaces
    Partition rebalancing
    VARCHAR column length changing
    8K & 16K page sizes
    Space map copy maintenance
    ROWID data type
    Identity columns
LOBs
Triggers
    Computer Exercise: Data Base Administration - 1

Data Base Administration Enhancements - Part 2
    DBADM authority increase
    View definitions
    Table definitions
PLAN_TABLE changes
    DSN_STATEMENT_TABLE
    Optimization hints
Changes in mananging constraints
Unicode
    UTF-8 and UTF-16
    CCSIDs
    SQL statements
    DECLARE VARIABLE special register
    Computer Exercise: Data Base Administration Changes - 2

Utility enhancements - Part 1
    Inline statistics
    REUSE option
   Utility parallelism
New utilities: CHECK LOB, REBUILD INDEX
Enhanced utilities: CHECK DATA, COPY, LOAD, QUIESCE,
        RECOVER, REORG INDEX, REORG TABLESPACE,
        REPORT, RUNSTATS
Standalone utility changes: DSN1COMP, DSN1COPY, DSN1PRNT
    Computer Exercise: Utilities - 1

Utility Enhancements - Part 2
    Utility packaging
New utility control statements: EXEC SQL, LISTDEF, OPTIONS, TEMPLATE
New utilities: COPYTOCOPY, MODIFY STATISTICS, UNLOAD
Enhanced utilities: CHECK DATA, CHECK INDEX, CHECK LOB, COPY, LOAD,
        MERGECOPY, MODIFY RECOVER, MODIFY STATISTICS, QUIESCE,
        REBUILD INDEX, RECOVER, REPORT, REORG INDEX, REORG
        TABLESPACE, RUNSTATS
    Computer Exercise: Utilities - 2

New BIND options
Command enhancements
    New commands
    Enhanced commands
Catalog table changes
    Computer Exercise: Command and Catalog Changes

Stored procedures enhancements
    CREATE / ALTER / DROP PROCEDURE
    Security
    Invocation changes
    SYSROUTINES, SYSROUTINEAUTH, SYSPARMS catalog tables
    Computer Exercise: Stored Procedures

Declared global temporary tables
Cursors
    Scrollable cursors
    SENSITIVE / INSENSITIVE cursors
    FETCH FIRST n ROWS ONLY
    Fast implicit close
    FOR UPDATE improvements
    Computer Exercise: Cursor Features

Miscellaneous SQL Changes
    Column and Scalar Functions
    Limits
    Savepoints
Odds and Ends
    DB2 extenders: Image, Video, Audio, Text, XML
    Cross-enterprise enhancements

Course Objectives
Course description
Home page