Kursbeskrivning: DB2 9 for z/OS Transition Workshop

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.

Visa den här kursen i andra länder

Tillbaka till toppen

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.

Tillbaka till toppen

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.

Tillbaka till toppen

• 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

Tillbaka till toppen

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

Tillbaka till toppen