Mainframe Blog

XML Schema Repository Tables in Db2 12

3 minute read
Stephen Watts

SYSIBM.XSRCOMPONENT

Auxiliary table for BLOB column COMPONENT in SYSIBM.SYSXSROBJECTCOMPONENTS

Column name Data type Description
COMPONENT BLOB(30M) Contents of the XML schema document

SYSIBM.XSROBJECTS

Contains one row for each registered XML schema

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

SYSIBM.XSROBJECTCOMPONENTS

Contains one row for each component (document) in an 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

SYSIBM.XSROBJECTGRAMMER

An auxiliary table for the BLOB column GRAMMAR in SYSIBM.SYSXSROBJECTS

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

SYSIBM.XSROBJECTPROPERTY

An auxiliary table for the BLOB column PROPERTIES in SYSIBM.SYSXSROBJECTS

Column name Data type Description
PROPERTIES BLOB(5M) Contents of the additional property information of the entire XML schema

SYSIBM.XSRPROPERTY

Auxiliary table for BLOB column PROPERTIES in SYSIBM.SYSXSROBJECTCOMPONENTS

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.

Order Now! Get your free Db2 collateral from BMC!

Get your free Reference Guide and Catalog Tables Poster for z/OS from BMC. This collateral helps DB2 for z/OS users with daily activities in administering and programming for DB2 on z/OS.


These postings are my own and do not necessarily represent BMC's position, strategies, or opinion.

See an error or have a suggestion? Please let us know by emailing blogs@bmc.com.

BMC Bring the A-Game

From core to cloud to edge, BMC delivers the software and services that enable nearly 10,000 global customers, including 84% of the Forbes Global 100, to thrive in their ongoing evolution to an Autonomous Digital Enterprise.
Learn more about BMC ›

About the author

Stephen Watts

Stephen Watts (Birmingham, AL) has worked at the intersection of IT and marketing for BMC Software since 2012.

Stephen contributes to a variety of publications including CIO.com, Search Engine Journal, ITSM.Tools, IT Chronicles, DZone, and CompTIA.