TL;DR Summary: XML Schema Repository Tables in Db2 12 detail essential tables for managing XML schemas. Key tables include SYSIBM.XSROBJECTS, which lists registered XML schemas, and SYSIBM.XSROBJECTCOMPONENTS, containing individual schema document components.
- SYSIBM.XSROBJECTS contains registered XML schemas.
- SYSIBM.XSROBJECTCOMPONENTS holds individual schema document components.
| Column name | Data type | Description |
| COMPONENT | BLOB(30M) | Contents of the XML schema document |
| Column name | Data type | Description |
| XSROBJECTID | INTEGER | Internal identifier of the XML schema. XSROBJECTID is generated as an identity column |
| XSROBJECT SCHEMA | VARCHAR(128) | Qualifier of XML schema name. Always set to ‘SYSSXR’ |
| XSROBJECT NAME | VARCHAR(128) | Name of the XML schema |
| TARGET NAMESPACE | INTEGER | Value of STRINGID column inSYSXMLSTRINGS when target namespace URL of primary XML schema document is stored in SYSXMLSTRINGS |
| SCHEMA LOCATION | INTEGER | Value of STRINGID column in SYSXMLSTRINGS when schema location URI of primary XML schema document is stored in SYSXMLSTRINGS |
| ROWID | ROWID | ID that is used to support BLOB data type values |
| GRAMMAR | BLOB(250M) | The internal binary representation of the XML schema |
| PROPERTIES | BLOB(5M) | Additional property information of the entire XML schema |
| CREATEDBY | VARCHAR(128) | Authorization ID under which the XML schema was created |
| CREATEDTS | TIMESTAMP | Time that DB2-supplied stored procedure XSR_REGISTER was executed for XML schema |
| STATUS | CHAR(1) | Registration status of the XML schema: C Complete I Incomplete T Temporary |
| RELCREATED | CHAR(1) | The release of DB2 that is used to create the object |
| CHAR(1) | Not used | |
| VARHCAR(128) | Not used | |
| REMARKS | VARCHAR(762) | Character string that contains comments about XML schema |
| Column name | Data type | Description |
| XSRCOMPONENTID | INTEGER | Identifier of XML schema document. XSRCOMPONENTID is generated as an identity column |
| TARGETNAMESPACE | INTEGER | Value of STRINGID column in SYSXMLSTRINGS when target namespace URI of primary XML schema document is stored in SYSXMLSTRINGS |
| SCHEMALOCATION | INTEGER | Value of STRINGID column in SYSXMLSTRINGS when schema location URI of the primary XML schema document is stored in SYSXMLSTRINGS |
| ROWID | ROWID | ID that is used to support BLOB data type values |
| COMPONENT | BLOB(30M) | Contents of the XML schema document |
| PROPERTIES | BLOB(5M) | Additional property information of the XML schema document |
| CREATEDTS | TIMESTAMP | Time XML schema document was registered |
| STATUS | CHAR(1) | Registration status of the XML schema: C Complete I Incomplete |
| RELCREATED | CHAR(1) | The release of DB2 that is used to create the object |
| Column name | Data type | Description |
| GRAMMAR | BLOB(250M) | Internal binary representation of the XML schema |
SYSIBM.XSROBJECTHIERARCHIES
SYSIBM.XSROBJECTHIERARCHIES contains one rule for each component (document) in an XML schema to record the XML schema document hierarchy relationships
| Column name | Data type | Description |
| XSROBJECTID | INTEGER | Internal identifier of the XML schema |
| XSRCOMPONENTID | INTEGER | Internal identifier of the XML schema document |
| HTYPE | CHAR(1) | Hierarchy type: D Document P Primary document |
| TARGETNAMESPACE | INTEGER | Value of STRINGID column in SYSXMLSTRINGS when target namespace URI of primary XML schema document is stored in SYSXMLSTRINGS |
| SCHEMALOCATION | INTEGER | Value of STRINGID column in SYSXMLSTRINGS when schema location URI of primary XML schema document is stored in SYSXMLSTRINGS |
| RELCREATED | CHAR(1) | The release of DB2 that is used to create the object |
| Column name | Data type | Description |
| PROPERTIES | BLOB(5M) | Contents of the additional property information of the entire XML schema |
| Column name | Data type | Description |
| PROPERTIES | BLOB(5M) | Contents of additional property information of the XML schema document |
Disclaimer: This Db2® 12 for z/OS Reference Guide was developed to help users in their daily activities in administrating and programming in Db2 for z/OS. There are no guarantees expressed or implied with the contents in this guide. We want to provide a quality and useful reference for users. Please notify us of any mistakes or errors in this reference guide at blogs@bmc.com. Db2 is a registered trademark of the IBM Corporation.
Db2 Guide
- Db2 12 for z/OS: An Introduction
- Scalar Functions in Db2 12
- How to Read IBM<sup>®</sup> Syntax Diagrams for Db2 12
- Language Elements in Db2 12
- Aggregate Functions in Db2 12
- Table & Row Functions in Db2 12
- Queries in Db2 12
- Commands in Db2 12
- SQL Control Statements in Db2 12
- Explain Tables in Db2 12
- DSNZPARMs in Db2 12
- Bind Parameters in Db2 12
- Db2 Limits in Db2 12
- SQL Communication Area (SQLCA) in Db2 12
- REXX SQLCA in Db2 12
- Get Diagnostics in Db2 12
- IFCIDS in Db2 12
- Catalog Tables in Db2 12
- Exceptions in Db2 12
- XML Schema Repository Tables in Db2 12
- Updatable Catalog Statistics in Db2 12
- IBM Utilities in Db2 12
- SQL Positive Return Codes in Db2 12
- SQL Error Return Codes in Db2 12
These postings are my own and do not necessarily represent BMC's position, strategies, or opinion.