AUDIENCE:   This course is designed for IT personnel who need to know DB2 9 z/OS facilities and how it might affect them. The course is arranged 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. PREREQUISITES:   Those attending the course should be familiar with DB2 at a previous release level. DURATION:   2 days. Hands on. OBJECTIVES:   The course is designed to instruct those delegates who are fairly confident in designing, writing and testing DB2 and now need to know the facilities, functions and changes that are available to them with DB2 9 for z/OS. COURSE CONTENT:   INTRODUCTION History Prerequisites Storage Modes SQL SELECT FROM UPDATE or SELECT FROM DELETE function INSTEAD OF triggers LOB Changes EXCEPT/INTERSECT keyword TRUNCATE TABLE statement MERGE and SELECT FROM MERGE statements FETCH FIRST n ROWS ONLY and ORDER BY in subselects and fullselects INSERT/UPDATE/DELETE changes Stored Procedure Changes BIND changes New Built in Functions Aggregate Functions OLAP specifications Optimization Service Center/Expert Skip Lock Data PERFORMANCE Reduction in CPU processing time for utilities SQL Optimization Improvements Index Changes   Larger Index Page Sizes   Last Used Index Flag   Index Key Randomization   Index Compression   Index On Expression   Index Page Split   Index Lookaside Varying-Length Rows Sequential Key Insert REOPT(AUTO) Encryption Prefetch Changes Global Query Optimization Optimistic Concurrency Control Small Sorts Isolation Level Explain All Stmtcache Sort Avoidance Distinct Group By Collapsing ENVIRONMENT/SYSTEM CHANGES XML BIGINT data type and function BINARY data type and function DECFLOAT data type and function Non logged table spaces Cloning Tables Universal Tablespaces Simple Tablespaces Reordered Row Format Log changes Automatic Object Creation Implicitly Hidden Columns OTHER SQL procedures Spatial Support Changes to DB2 Tools Utilities Changes  Reorg  Runstats  Load  Rebuild Index  Copy Role Based Security Trusted Context Support Data Encryption Trigger Changes Column and Index Renaming Modify EARLY SMS storage classes QMF Static JDBC IC08/01