XML schema repository (XSR) table spaces and indexes

Db2 XSR tables are contained in certain table spaces and have indexes.

The following tables list the table space and indexes for each XRS table and lists the index fields for each index. The indexes are in ascending order, except where noted.

Table 1. Table spaces and indexes for the DSNXSR database tables
Table space
DSNXSR. …
Table
SYSIBM. …
Index
SYSIBM. …
Index fields
SYSXSR XSROBJECTS XSROBJ01 XSROBJECTID
    XSROBJ02 XSROBJECTSCHEMA.XSROBJECTNAME
    XSROBJ03 TARGETNAMESPACE.SCHEMALOCATION
    XSROBJ04 SCHEMALOCATION
 
XSROBJECT-
COMPONENTS
XSRCOMP01 XSRCOMPONENTID
    XSRCOMP02 TARGETNAMESPACE.SCHEMALOCATION
 
XSROBJECT-
HIERARCHIES
XSRHIER01
XSROBJECTID.TARGETNAMESPACE.
SCHEMALOCATION
    XSRHIER02 XSROBJECTID.TARGETNAMESPACE
       
SYSXSRA1 XSROBJECTGRAMMAR XSRXOG01 GRAMMAR
       
SYSXSRA2 XSROBJECTPROPERTY XSRXOP01 PROPERTIES
       
SYSXSRA3 XSRCOMPONENT XSRXCC01 COMPONENT
       
SYSXSRA4 XSRPROPERTY XSRXCP01 PROPERTIES
Note: Index field is in descending order