DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.INDEXEXTENSIONDEP catalog view

Each row represents a dependency of an index extension on some other object. The index extension depends on the object of type BTYPE of name BNAME, so a change to the object affects the index extension.

Table 1. SYSCAT.INDEXEXTENSIONDEP Catalog View
Column Name Data Type Nullable Description
IESCHEMA VARCHAR (128)   Schema name of the index extension.
IENAME VARCHAR (128)   Unqualified name of the index extension.
BTYPE CHAR (1)   Type of object on which there is a dependency. Possible values are:
  • A = Table alias
  • B = Trigger
  • F = Routine
  • G = Global temporary table
  • H = Hierachy table
  • K = Package
  • L = Detached table
  • N = Nickname
  • O = Privilege dependency on all subtables or subviews in a table or view hierarchy
  • Q = Sequence
  • R = User-defined data type
  • S = Materialized query table
  • T = Table (not typed)
  • U = Typed table
  • V = View (not typed)
  • W = Typed view
  • X = Index extension
  • Z = XSR object
  • m = Module
  • q = Sequence alias
  • u = Module alias
  • v = Global variable
  • * = Anchored to the row of a base table
BSCHEMA VARCHAR (128)   Schema name of the object on which there is a dependency.
BMODULENAME VARCHAR(128) Y Unqualified name of the module to which the object on which a dependency belongs. The null value if not a module object.
BNAME VARCHAR (128)   Unqualified name of the object on which there is a dependency. For routines (BTYPE = 'F'), this is the specific name.
BMODULEID INTEGER Y Identifier for the module of the object on which there is a dependency.
TABAUTH SMALLINT Y If BTYPE = 'O', 'S', 'T', 'U', 'V', 'W', or 'v', encodes the privileges on the table or view that are required by the dependent index extension; the null value otherwise.