This course is not scheduled. Inquire about Onsite training at your facility.
Overview
| Course code | 3V302 | Skill level | Intermediate |
|---|---|---|---|
| Duration | 4.0 days | Delivery type | Instructor Led - Online Training
(Hands-on labs) |
| Course type | Public or Private on-site | ||
| Public price | USD $2,600.00 plus tax | ||
This is an online course. Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access audio, video and remote labs.
Learn about the new features and enhancements of DB2 9 for z/OS, including the technical detail of the functional enhancements of this significant new version of DB2 for z/OS. Practice several of the new functions by performing hands-on machine exercises. This is the Instructor Led On Line course of Classroom course CV302.
View this course in other countries
Training Paths that reference this course are:
Audience
This is an intermediate course for system and database administrators, application developers, and other individuals who need a technical introduction to selected new features of DB2 9.
Prerequisites
You should have practical experience with DB2 for z/OS and have basic knowledge of the functions and usage of DB2 z/OS Version 8.
Skills taught
- Describe selected new features and enhancements of DB2 9 for z/OS
- Evaluate the usefulness of the new features and enhancements of DB2 9 for z/OS
Course outline
Availability
- Explain how WLM is exploited to resolve latch contention
- Use RENAME COLUMN statement
- Explain what Universal table spaces are
- Make use of Clone Table support
- Initiate the new REFRESH command for the EARLY code
- Decide if Log Truncation by Timestamp is the right option for you
- Cancel DB2 commands if needed
- Use the ALTER TABLE ... LONG VARCHAR to VARCHAR
- Explain which objects are now automatically created
- Use SMS constructs
Stored Procedures
- Make use of the new Native SQL Stored Procedures
- Explore the new possibilities of Nested Compound Statements within your SQL Stored Procedures
- Describe the characteristics and differences for external SQL stored procedures and native SQL stored procedures
SQL Enhancements
- Describe the support for new data types
- Explain INSTEAD OF trigger
- Describe the usage of MERGE statement
- Describe the usage of a SELECT statement in UPDATE, DELETE, and MERGE statements
- Describe the usage of ORDER BY and FETCH FIRST in subselect
- Describe the usage of TRUNCATE statement
- Explain the INTERSECT and EXCEPT statements
- Describe the support for new built-in functions
- Discuss the implications of CURRENT SCHEMA
- Explain when the cultural sort is useful
- Describe some post-GA SQL enhancements
Security
- Define and create a Trusted Context
- Define and create a Role
- Use Trusted Context and Role definitions to satisfy security requirements for several specified scenarios
- Describe the use of SSL with DB2
- Relate how DB2 supports EIM
- List the new auditability features
Application Enablement
- Describe optimistic concurrency control
- Describe skip locked data
- Explain use of file reference variables to retrieve LOB data
- Explain use of FETCH CONTINUE when dealing with LOB and XML data
- Discuss the facilities provided by IBM Data Server Driver for JDBC and SQLJ
- Discuss how to be prepared for the eventual removal of DB2 private protocol
- Provide an overview of DB2 spatial support
- Describe DB2 9 post-GA Access Path Stability (PK52523)
Utilities
Describe the new functions for utility operations, including:
- LOAD
- UNLOAD
- RUNSTATS
- REORG
- CHECK DATA
- CHECK LOB
- COPY
- RECOVER
- REPORT
- MODIFY RECOVERY
- REBUILD INDEX
- TEMPLATE
- BACKUP/RESTORE SYSTEM/CATMAINT
Relate the operational and performance improvements to utility usage
Describe post-GA utility enhancements in the maintenance stream
Performance and Scalability
discuss:
- zIIP
- Virtual storage management
- Index compression
- Performance expectations and best practices
- Enhanced sequential key insert
- REOPT AUTO
- RLF enhancements
- Histogram statistics
- Optimization of complex query
- Global query optimization
- WLM-assisted buffer pool management
- LOB performance improvements
- Performance scalability enhancements
- Other performance improvements
- Post-GA performance enhancements
XML
- Explain the importance of XML
- Describe why and when XML can be advantageous
- Describe the reasons for using XPath
- Define the components and constructs that make up the XPath language
- Identify abbreviated XPath expressions
- Write simple XPath expressions to navigate through XML documents
- Use the SQL/XML built-in functions
- Describe how XML data is stored in DB2
- Create indexes on XML columns
- List the utilities supported with XML data
... And More
- Describe the enhancements for each of the new features/functions included in this unit
Data Sharing
- Describe what is new for Data Sharing within DB2 9
- Make use of the new -ACCESS DATABASE command
Installation and Migration
- Plan for DB2 9
- Discuss the migration process and implications
- Describe the changes to the catalog
Agenda
Day 1
- Welcome
- Unit 1 - Availability
- Exercise 1 - Availability
- Unit 2 - Stored Procedures
Day 2
- Exercise 2 - Stored Procedures
- Unit 3 - SQL Enhancements
- Unit 4 - Security
Day 3
- Unit 5 - Application Enablement
- Unit 6 - Utilities
- Unit 7 - Performance and Scalability
Day 4
- Unit 7 - Performance and Scalability (cont)
- Unit 8 - XML
- Exercise 5 - XML
- Unit 9 - ... And More!
- Unit 10 - Data Sharing
- Unit 11 - Installation and Migration
My IBM
We're here to help
Easy ways to get the answers you need.
or call us at
Call 1-800-426-8322
Open M-F 9AM-7PM ET.
