• Select a country/region: United States
  • IBM®
  • Site map

  • Training - worldwide
  • Training
  • Course catalog

Course description: Manage XML Data with DB2 9 for z/OS

This course is not scheduled. Inquire about Onsite training at your facility.

  • Add course to my custom catalog
  • Add to my training plan

Overview

  • Special note
  • Audience
  • Prerequisites
  • Skills taught
  • Course outline
List of course details in a data table
Course code CV260 Skill level Basic
Duration 3.0 days Delivery type Classroom
(Hands-on labs)
Course type Public or Private on-site    
Public price USD $2,010.00 plus tax    

This course is designed to introduce you to non-traditional ways of using DB2 for z/OS to work with native XML data. It is also designed to enable database administrators to manage the DB2 native XML environment.

You store native XML data in DB2 and create XML indexes. You analyze plan information for queries and take steps for improving query execution. The course also teaches how to managethe XML schema and the techniques available for decomposing the XML documents.

View this course in other countries


Training Paths that reference this course are:

  • XML

Back to top

Special note

IBM Education Advantage Program Eligibility:

  • Yes - IBM Education Pack - online account

Back to top

Audience

This is a basic course for:

  • Database administrators
  • Anyone interested in learning how to manage native XML data in DB2

Back to top

Prerequisites

You should have attended:

  • Query XML Data with DB2 9 for z/OS (CV120) or have equivalent experience
  • DB2 9 for z/OS Database Administration Workshop Part 1 (CV830) or having equivalent experience is desirable.

If not, you should at least have basic knowledge of DB2 physical organization (table spaces, indexes, etc.) and use of utilities.

Back to top

Skills taught

  • Establish the environment to store native XML data in DB2 for z/OS
  • Create XML indexes for efficient retrieval of XML data
  • Analyze query executions and what you can do to improve the query performance
  • Validate and register XML schema using commands
  • Decompose XML documents using XMLTABLE function
  • Use IBM Data Studio for decomposition using XMLTABLE function, and register XML schema for validation

Back to top

Course outline

Introduction to XML storage and lab

  • XML data type
  • XML storage
  • How XML data is stored
  • How to get it in
  • How to get it back out
  • Basic IUD (Insert/Update/Delete)

XML indexing and lab

  • XML indexing overview
    • Storing the XML document
    • DOCID index
    • NODEID index
    • Index on an XML column
  • Externals for index on an XML column
  • Extended CREATE INDEX syntax
  • Casting to the index data type
  • Catalog changes

Utility co