Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see ALTER and BMC AMI Change Manager for Db2 13.1.

Db2 object types


The Specification component of ALTER and BMC AMI Change Manager for Db2 uses a mixed list to display Db2 object types and object names. A number sign (#) that precedes an object type indicates the object appears more than once on the mixed list.

The following table shows the abbreviations that Specification uses, and the data types for each part of the object names (in bytes):

Abbreviation

Description

Data type of object name (in bytes)

Data type (part 1)

Data type (part 2)

Data type (part 3)

AL

Alias

VARCHAR(128)

VARCHAR(128)

NA

CK

Check constraint (check)

VARCHAR(128)

VARCHAR(128)

VARCHAR(128)

DB

Database

VARCHAR(24) 1

NA

NA

FK

Foreign key

VARCHAR(128)

VARCHAR(128)

VARCHAR(128)

IX

Index

Auxiliary index

XML index

VARCHAR(128)

VARCHAR(128)

NA

IXA

Orphaned auxiliary index

VARCHAR(128)

VARCHAR(128)

NA

IXC

Clustering index

VARCHAR(128)

VARCHAR(128)

NA

IXCT

Clustering index

This partitioned index is created for a table that uses table-controlled partitioning.

VARCHAR(128)

VARCHAR(128)

NA

IXCT2

Clustering, partitioning index for a table in a partition-by-range table space with relative page numbering

This partitioned index is created for a range-partitioned (PBR) table space.

VARCHAR(128)

VARCHAR(128)

NA

IXG

Unique index that is defined as ROWID GENERATED BY DEFAULT

VARCHAR(128)

VARCHAR(128)

NA

IXGC

Unique and clustering index that is defined as ROWID GENERATED BY DEFAULT

VARCHAR(128)

VARCHAR(128)

NA

IXGCT

Unique and clustering index that is defined as ROWID GENERATED BY DEFAULT

This partitioned index is created for a table that uses table-controlled partitioning.

VARCHAR(128)

VARCHAR(128)

NA

IXGT

Unique index that is defined as ROWID GENERATED BY DEFAULT

This index is created for a table that uses table-controlled partitioning.

VARCHAR(128)

VARCHAR(128)

NA

IXN

Node ID index for an XML base table

VARCHAR(128)

VARCHAR(128)

NA

IXP

Primary index

VARCHAR(128)

VARCHAR(128)

NA

IXPC

Primary and clustering index

VARCHAR(128)

VARCHAR(128)

NA

IXPCT

Primary and clustering index

This partitioned index is created for a table that uses table-controlled partitioning.

VARCHAR(128)

VARCHAR(128)

NA

IXPT

Primary index

This partitioned index is created for a table that uses table-controlled partitioning.

VARCHAR(128)

VARCHAR(128)

NA

IXR

Unique index that enforces the uniqueness of a nonprimary parent key; referenced by a foreign key

VARCHAR(128)

VARCHAR(128)

NA

IXRC

Unique and clustering index that enforces the uniqueness of a nonprimary parent key

VARCHAR(128)

VARCHAR(128)

NA

IXRCT

Unique and clustering index that enforces the uniqueness of a nonprimary parent key

This partitioned index is created for a table that uses table-controlled partitioning.

VARCHAR(128)

VARCHAR(128)

NA

IXRT

Unique index that enforces the uniqueness of a nonprimary parent key

This partitioned index is created for a table that uses table-controlled partitioning.

VARCHAR(128)

VARCHAR(128)

NA

IXS

Index on an expression

VARCHAR(128)

VARCHAR(128)

NA

IXST

Partitioned index on an expression that is created for a table that uses table-controlled partitioning

VARCHAR(128)

VARCHAR(128)

NA

IXSU

Unique index on an expression

VARCHAR(128)

VARCHAR(128)

NA

IXT

Partitioned index that is created for a table that uses table-controlled partitioning

VARCHAR(128)

VARCHAR(128)

NA

Partitioned index for a table in a partition-by-range table space with relative page numbering

VARCHAR(128)

VARCHAR(128)

NA

IXU

Unique index

VARCHAR(128)

VARCHAR(128)

NA

IXUC

Unique and clustering index

VARCHAR(128)

VARCHAR(128)

NA

IXUCT

Unique and clustering index

This partitioned index is created for a table that uses table-controlled partitioning.

VARCHAR(128)

VARCHAR(128)

NA

IXUT

Unique index

This partitioned index is created for a table that uses table-controlled partitioning.

VARCHAR(128)

VARCHAR(128)

NA

IXV

Index that is defined on an XML column in a base table (TBB or TBBT)

This object code replaces the IXX object code.

VARCHAR(128)

VARCHAR(128)

NA

IXVD

DocID index that is defined on an XML column in a base table (TBB or TBBT)

Db2 implicitly creates this index.

This object code replaces the IXXD object code.

VARCHAR(128)

VARCHAR(128)

NA

IXVN

NodeID index that is defined on an XML column in a base table (TBB or TBBT)

VARCHAR(128)

VARCHAR(128)

NA

IXVU

Unique XML index

VARCHAR(128)

VARCHAR(128)

NA

IXW

Unique index that is defined as WHERE NOT NULL

VARCHAR(128)

VARCHAR(128)

NA

IXWC

Unique and clustering index that is defined as WHERE NOT NULL

VARCHAR(128)

VARCHAR(128)

NA

MK

Column mask

VARCHAR(128)

VARCHAR(128)

NA

RP

Row permission

VARCHAR(128)

VARCHAR(128)

NA

SG

Storage group (stogroup)

VARCHAR(128)

NA

NA

SP

Stored procedure

VARCHAR(128)

VARCHAR(128)

NA

SPE

External stored procedure

VARCHAR(128)

VARCHAR(128)

NA

SPN

Native SQL stored procedure

VARCHAR(128)

VARCHAR(128)

VARCHAR(64)

SPNA

Active version of native SQL stored procedure

VARCHAR(128)

VARCHAR(128)

VARCHAR(64)

SPS

External SQL stored procedure

VARCHAR(128)

VARCHAR(128)

NA

SQ

Sequence

VARCHAR(128)

VARCHAR(128)

NA

SY

Synonym

VARCHAR(128) 2

VARCHAR(128)

NA

TB

Table

Application-period temporal table

Auxiliary table

Bitemporal table

System-period temporal table

XML table

VARCHAR(128)

VARCHAR(128)

NA

TBH

Table that Db2 uses to store historical versions of rows from the associated system-period temporal table (history table)

VARCHAR(128)

VARCHAR(128)

NA

TBB

Table containing a large object (LOB) or an XML column (base table)

VARCHAR(128)

VARCHAR(128)

NA

TBBH

Base table that uses system-period data versioning

VARCHAR(128)

VARCHAR(128)

NA

TBBT

Base table that uses table-controlled partitioning

VARCHAR(128)

VARCHAR(128)

NA

TBC

Clone table

VARCHAR(128)

VARCHAR(128)

NA

TBGT

Global temporary table

VARCHAR(128)

VARCHAR(128)

NA

TBQ

Materialized query table (MQT)

VARCHAR(128)

VARCHAR(128)

NA

TBQT

Materialized query table (MQT) that uses table-controlled partitioning

VARCHAR(128)

VARCHAR(128)

NA

TBR

TBBR

Archive table

Archive table for table containing a large object (LOB) or an XML column (base table)

VARCHAR(128)

VARCHAR(128)

NA

TBT

Table that uses table-controlled partitioning

VARCHAR(128)

VARCHAR(128)

NA

TR

Trigger in which the trigger text references the table

VARCHAR(128)

VARCHAR(128)

NA

TRA

Active advanced trigger

VARCHAR(128)

VARCHAR(128)

VARCHAR(64)

TRAB

Active advanced trigger that references the table

VARCHAR(128)

VARCHAR(128)

VARCHAR(64)

TRB

Trigger that references the table

VARCHAR(128)

VARCHAR(128)

NA

TS

Table space

Auxiliary table space

XML table space

The TS might have any of the following characteristics:

  • Nonpartitioned
  • Created with the CTB command-line command or action code
  • Imported without a dependent table
  • Partitioned and incomplete

VARCHAR(24) 1

VARCHAR(24) 3

NA

TSA

Orphaned auxiliary table space

VARCHAR(24) 1

VARCHAR(24) 3

NA

TSG

Partition-by-growth table space

VARCHAR(24) 1

VARCHAR(24) 3

NA

TSI

Partitioned table space that contains a table that uses index-controlled partitioning

A TSI can be any TS that is LIKEd from a TSI or any TS that is converted to index-controlled partitioning.

VARCHAR(24) 1

VARCHAR(24) 3

NA

TST

Partitioned table space that contains a table that uses table-controlled partitioning

A TST can be any TS that is LIKEd from a TST or any TS that is converted to table-controlled partitioning.

VARCHAR(24) 1

VARCHAR(24) 3

NA

TSR

A range-partitioned table space

VARCHAR(24) 1

VARCHAR(24) 3

NA

TSR2

Partition-by-range table space with relative page numbering

VARCHAR((24) 1

VARCHAR(24) 1

NA

UC

Unique constraint

VARCHAR(128)

VARCHAR(128)

VARCHAR(128)

UCP

Primary key constraint

VARCHAR(128)

VARCHAR(128)

VARCHAR(128)

UCU

Unique (nonprimary) key constraint

VARCHAR(128)

VARCHAR(128)

VARCHAR(128)

VW

View

VARCHAR(128)

VARCHAR(128)

NA

1 In a Unicode subsystem, the database name can be defined as VARCHAR(24). However, in a non-Unicode subsystem, the name can be defined only as VARCHAR(8).

2 The synonym owner is limited to a maximum of 8 bytes.

3 In a Unicode subsystem, the table space name can be defined as VARCHAR(24). However, in a non-Unicode subsystem, the name can be defined only as VARCHAR(8).

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*