CL14: Manage XML Data with DB2 9

Code: CL14
Duration: 2 days


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

The students store native XML data in DB2 and create XML indexes. They analyse, plan information for queries and take steps for improving query execution. The course also teaches students how to manage the XML schemas and the techniques available for decomposing the XML documents.


Upon successful completion of this course, the students will be able to:

  • Establish the environment to store native XML data in DB2
  • 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 schemas using commands
  • Annotate XML schemas and decompose XML documents using commands
  • Use Developer Workbench to annotate XML schemas for decomposition, and register XML schemas for validation, decomposition, or both


Users, database administrators or anyone interested in learning how to retrieve native XML data in DB2.


You should have attended CL13, Query XML Data with DB2 9, or have equivalent experience.


Classroom and hands on lab exercises.

This course is also offered as web-based training. Please contact us for more information.

Course available by request – please contact us for further details.