Cours: DB2 pour z/OS Delta Version 9

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.

Course Materials

The course materials address DB2 9 for z/OS.

Hands-On Labs

Five labs are included to address DB2 9 for z/OS.

Training Path

This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education.

Voir ce cours dans d'autres pays

Schémas de filière:

• DB2 pour z/OS

Début

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.

Début

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.

Début

• 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

Début

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

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
• Exercise 3: SQL
• Unit 4: Security

Day 3

• Unit 5: Application enablement
• Unit 6: Utilities
• Exercise 4: Utilities
• Unit 7: Performance and scalability

Day 4

• Unit 7: Performance and scalability (cont)
• Unit 8: XML
• Exercise 5: XML
• Unit 9: Data sharing
• Unit 10: Installation and migration

Début