• Velg land/region: Norge
  • IBM®
  • Stedsoversikt

  • Utdanning
  • Kurskatalog

Kurs informasjon: DB2 9 for z/OS Transition Workshop

Dette kurset har ingen planlagt dato. Ring 815 48 231 for informasjon om bedriftsinternt kurs.

  • Legg til i min personlige kurskatalog
  • Legg til i min kurs ønskeliste

Oversikt

  • Målgruppe
  • Forkunnskaper
  • Mål
  • Nøkkelemner
List of course details in a data table
Kurskode CV302NO Leveringsform Classroom
(Hands-on labs)
Varighet 4.0 dager Kurstype
Listepris  Set by Partner    

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.

View this course in other countries

Til top

Målgruppe

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.

Til top

Forkunnskaper

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.

Til top

Mål

  • 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

Til top

Nøkkelemner

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