Chapter 22. Exploring XML Information in the DB2 Catalog

In this chapter we summarize the DB2 catalog information related to managing XML data in DB2. This discussion is split into two sections:

• XML information in the catalog views in DB2 for Linux, UNIX, and Windows (section 22.1)

• XML information in the catalog tables in DB2 for z/OS (section 22.2)

22.1 XML-Related Catalog Information in DB2 for Linux, UNIX, and Windows

With the introduction of pureXML in DB2, several existing catalog tables have been augmented with XML-related information and several catalog tables have been added. All of these tables are discussed in the following sections.

22.1.1 Catalog Information for XML Columns

When a table with an XML column ...

Get DB2 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.