DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.XDBMAPSHREDTREES catalog view

Each row represents one shred tree for a given schema graph identifier.

Table 1. SYSCAT.XDBMAPSHREDTREES Catalog View
Column Name Data Type Nullable Description
OBJECTID BIGINT   Unique generated identifier for an XSR object.
OBJECTSCHEMA VARCHAR (128)   Schema name of the XSR object.
OBJECTNAME VARCHAR (128)   Unqualified name of the XSR object.
SCHEMAGRAPHID INTEGER   Schema graph identifier, which is unique within an XDB map identifier.
SHREDTREEID INTEGER   Shred tree identifier, which is unique within an XDB map identifier.
MAPPINGDESCRIPTION CLOB (1M) Y Diagnostic mapping information.