Articles & Content

Archives

10 Things Every DBA Should Know About DB2 pureXML (E06)

Topic: 2010 EMEA

Subtopic: DB2 for LUW



DATE: 2010-11-9 (14:15 - 15:15)
SPEAKERS: Matthias Nicola (IBM Silicon Valley Lab)

This session explains the top 10 most important features for the administration of DB2 databases that contain XML data. You will learn about DB2's XML storage objects, default system indexes for XML, user-defined XML indexes, and new tables in the DB2 catalog that describe all these objects. This session further provides guidelines for monitoring XML data growth, compression, and handling XML in utilities such as Load, Import, Export, Runstats, and Reorg. A discussion of DB2's XML Schema Repository and several critical XML performance tips complete this presentation, which can serve as an "XML cheat sheet" for DBAs.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Understand the XML-related database objects -incl. new storage objects, new system indexes, user-defined XML indexes, XML schemas- and how they relate to each other.

Take home useful catalog queries that provide a quick overview of XML storage, indexes, and schemas in your database.

Learn how to estimate and monitor XML space consumption correctly.

Understand how DB2's utilities handle XML data or a combination of XML and relational data.

Understand how the physical database and table space configuration affects XML performance.



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.