|
|
DB2 UDB for z/OS Version 8
Differences and Transition
| Duration: 3 days |
| Participants: Application developers, system and database administrators, and others who need a technical introduction to the new features of DB2 for z/OS Version 8. |
|
Objectives:
Upon successful completion of this course you will be able to:
- Describe and use new features and enhancements in DB2 UDB for z/OS Version 8. |
|
Overview:
- This course presents the new features and enhancements of DB2 UDB for z/OS Version 8. This new version of DB2 has some significant enhancements and technical requirements. For a class of just programmers, this class can be shortened to two days. |
| Prerequisites: Practical experience using DB2 UDB for z/OS and OS/390 Version 7, including usage of SQL and writing applications accessing DB2 databases. |
| Format: Lecture, discussion, and class exercises. |
|
Topic Outline:
- New SQL Dynamic scrollable cursors Multi-row FETCH and INSERT/ROWSETS Positioned UPDATE/DELETE with ROWSETS GET DIAGNOSTICS Common Table Expressions Recursive SQL Identity column enhancement Sequence objects (contrasted with other techniques for generating unique values) GENERATE_UNIQUE( ) Scalar fullselect SELECT inside an INSERT SAVEPOINT with cursor containing an INSERT Aggregate function enhancements Expanded use of expressions Comparing NULLs Miscellaneous additional improvements - Scalability and Availability Index improvements Dynamic schema modification Increased support for partitions/partitioned tables/tablespaces/indexes Increased join statement complexity zArchitecture support for 64-bit virtual storage Impact on pools, locks, threads, sorts, etc. Support for delimited files System backup/point-in-time system recovery Information RI Materialized Query Table enhancements Star Schema Puffing and BINDs - New Web and Network Support Unicode in DB2 for z/OS, CCSIDs, encoding Schemas New Network Support, including: Member routing DRDA (Distributed Relational Database Architecture) Data stream encryption Roll-up of accounting data for threads New capabilities of ODBC (Open Database Connectivity) for USS (UNIX System Services) DB2 Universal Driver for SQLJ (SQL for Java) and JDBC (Java Database Connectivity) New integrated XML (Extensible Markup Language) publishing functions/generating HTML Security enhancements Stored procedure improvements Session variables New special registers - DB2 Utilities New features of LOAD and UNLOAD Rebalancing partitions Changes to almost every utility, especially: REORG COPY REPAIR LOAD UNLOAD DSN1COPY Support for DPSI (Data Partitioned Secondary Indexes) Support for delimited files - Performance New index support Distribution statistics Volatile tables Star joins Visual Explain overview - Data Sharing Reducing CF (Coupling Facility) lock propagation CF request batching Improved LPL (Logical Page List) recovery Restart Light enhancements IMMEDWRITE DISPLAY GROUPBUFFER - Installation and Migration Three migration phases Migration process and implications DB2 system catalog changes Impact on existing programs - Highlights of DB2 UDB for z/OS Version 9.1 |
|
|