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 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