Defining a schema rule

Related topics

Schema rules define the acceptance criteria for the schema by the validation process.

You can also specify when the validation process should apply the schema rules to the schema. The following figure shows a sample schema rule:

BMC AMI Command Center cannot resolve user-defined variables that you use in rule definitions. The program identifies them as unresolvable host variables. After you verify that the user-defined variable is the only error, you can save the rule by using the Accept the rule with errors option. When you run the process, the Schema Standards process resolves the user-defined variables based on the definition in the XML file.

This topic contains the following sections:

To define a schema rule

Open the rule editor. For more information, see Managing schema rule sets.

On the Definition tab, enter the following information:

Field or section	Description
Rule name	Identifier for the rule. This field is read-only when you are editing a rule.
Explanation	Short description that explains the rule. The explanation is included in the validation logs to help developers correct violations.
Object type	Object type to which the rule applies. This field is read-only when you are editing a rule. Select one of the following object types: Auxiliary Index Auxiliary Index Partition Auxiliary Table Database Impact Report (BMC.DB2.SPE2510) Impact Utility (BMC.DB2.SPE2510) Index Index Partition LOB Table Space LOB Table Space Partition Storage group Table Table Column Table Space Table Space Partition View View Column Volume The selected object type determines which attributes are available for defining the rule expression and the when condition.
Rule	Expression that defines how an object type attribute should be specified in a schema. For more information, see Rule expression.
When	Expression that determines under what circumstances the rule applies to the object type. If you do not enter an expression, the rule applies to all objects of the specified type. For more information, see When condition.

On the Options tab, enter the following information:

Field

Description

Log mode

Select one of the following values to determine the severity of violations of the schema rule:

Value	Description
Log a warning for violations	The validation process logs violations as warnings, and the operation can end successfully.
Log a failure for violations	(Default) The validation process logs violations as errors, and the operation fails. The log mode is overridden if either of the following log modes is set to warn: The log mode of the rule set to which this rule belongs The log mode of an ancestor rule set

Comment

Describe the purpose of the rule.

Click OK.
If BMC AMI Command Center detects an error, it displays the Verify Rule Failed dialog box. Otherwise, the rule editor closes.

In the Verify Rule Failed dialog box, select one of the following options:

Option	Description
Return to the rule editor	BMC AMI Command Center displays the Error tab that lists the errors found. If you entered a user-defined variable, BMC AMI Command Center displays the following error message: Encountered a host variable userVariable that could not be resolved Use this option to verify whether the user-defined variable is the only error.
Disable the rule	BMC AMI Command Center disables the rule and saves it.
Accept the rule with errors	BMC AMI Command Center saves the rule with the error. If you entered a user-defined variable, verify whether the variable is the only error and use this option to save the rule.

Rule expression

This section describes the fields used to define the rule expression.

Number	Description
1	Enter the target of the rule that identifies the attribute that you want to verify. You can enter any valid SQL that is available for use in an SQL WHERE clause.
2	Opens the Select Attribute dialog box in which you can select an attribute for the field to the left (1).
3	Select an operator that identifies the relationship between the target (1) and value (4).
4	Enter the value against which to verify the target (1). You can enter any valid SQL that is available for use in an SQL WHERE clause. You can also use user-defined variables defined in an XML document. Enter a user-defined variable preceded by a single quotation mark and colon, then followed by another single quotation mark. For example, you would enter the user-defined variable DBNM as ‘:DBNM’. For more information, see Using Schema Standards rules with user-defined variables in Jenkins or Using Schema Standards rules with user-defined variables for Universal Connector.
5	If you selected IN or NOT IN as the operator, this option opens the Enter List Values dialog box. Otherwise, it opens the Select Attribute dialog box, in which you can select an attribute for the field to the left (4).
6	Opens the free-form rule editor. This icon is disabled after you select a target (1). For more information, see Free-form editor.

When condition

This section describes the fields used to define the when condition. If the when condition evaluates to true, the rule expression is applied to the object.

Image identifying the parts of a when condition dialog

Number

Description

You can enter one or more left parenthesis to control the logical evaluation of the conditions.

Enter the target attribute of the condition that determines to which objects the rule applies. You can enter any valid SQL that is available for use in an SQL WHERE clause.

Opens the Select Attribute dialog box in which you can select an attribute for the field to the left (2).

Select an operator that identifies the relationship between the target (2) and value (5).

Enter a value to compare with the target that determines to which objects the rule applies. You can enter any valid SQL that is available for use in an SQL WHERE clause.

You can also use user-defined variables defined in an XML document. Enter the user-defined variable preceded by a single quotation mark and colon, then followed by another single quotation mark. For example, you would enter the user-defined variable DBNM as ‘:DBNM’. For more information, see Using Schema Standards rules with user-defined variables in Jenkins or Using Schema Standards rules with user-defined variables for Universal Connector.

If you selected IN or NOT IN as the operator, this option opens the Enter List Values dialog box. Otherwise, it opens the Select Attribute dialog box, in which you can select an attribute for the field to the left (5).

You can enter one or more right parentheses to control the logical evaluation of the conditions.

Select a logical operator to connect the conditions. Logical operators are enabled when you add more than one condition.

The following table describes the available actions:

Icon	Action
	Opens the free-form editor This icon is disabled after you select a target (2). For more information, see Free-form editor.
	Inserts a copy of the current condition as the last row in the when condition
	Removes the current condition from the When condition
	Moves the current condition up one row
	Moves the current condition down one row

Click to add another condition to the when condition.

Free-form editor

You can use the free-form editor to define rule expressions and when conditions as shown in the following figure. The free-form editor accepts any valid SQL that is available for use in an SQL WHERE clause.

Number	Description
1	Opens the Insert Attribute dialog box. The selected attribute is inserted at the cursor location.
2	Opens the Insert Operator dialog box. The selected operator is inserted at the cursor location.

Rule attribute clarifications

The Select Attribute dialog box displays a description of the selected attribute, as shown in the following figure:

The following table displays more information about the attributes:

Attribute	Object types	Host variable	Description
ALTERS (BMC.DB2.SPE2510)	Impact Report	IRALTERS	Specifies the total number of alters to be performed
ALTERS_IX (BMC.DB2.SPE2510)	Impact Report	IRALTERS_IX	Specifies the number of alters to be performed against indexes
ALTERS_TB (BMC.DB2.SPE2510)	Impact Report	IRALTERS_TB	Specifies the number of alters to be performed against tables
ALTERS_TS (BMC.DB2.SPE2510)	Impact Report	IRALTERS_TS	Specifies the number of alters to be performed against table spaces
ALTERS_VW (BMC.DB2.SPE2510)	Impact Report	IRALTERS_VW	Specifies the number of alters to be performed against views
APPEND	Table	TBAPPEND	Indicates whether to specify the Append option for the table. Valid values are YES and NO.
ARCHIVE TB CREATOR	Table	TBARCHIVE_TB_CREATOR	Contains a schema name as follows: If the table is archive-enabled, contains the Schema name of the archive table If the table is an archive table, contains the Schema name of the archive-enabled table If the table is not archive-enabled, the table or archive table is blank
ARCHIVE TB NAME	Table	TBARCHIVE_TB_NAME	Contains a table name as follows: If the table is archive-enabled, contains the Schema name of the archive table If the table is an archive table, contains the Schema name of the archive-enabled table If the table is not archive-enabled, the table or archive table is blank
AUDIT	Table	TBAUDIT	Identifies the types of access to this table that causes auditing: ANY—Audit All CHANGED—Audit Change NONE—Audit None
BASECOLNAME	Auxiliary Table	AUXTBBASECOLNAME	Name of the LOB column that the auxiliary object supports
BASECOLNAME	LOB Table Space	LOBTSBASECOLNAME	Name of the LOB column that the auxiliary object supports
BASETBCREATOR	Auxiliary Table	AUXTBBASETBCREATOR	The Schema of the base table that it supports
BASETBCREATOR	LOB Table Space	LOBTSBASETBCREATOR	The Schema of the base table that it supports
BASETBNAME	Auxiliary Table	AUXTBBASETBNAME	The Name of the base table that it supports
BASETBNAME	LOB Table Space	LOBTSBASETBNAME	The Name of the base table that it supports
BINDS (BMC.DB2.SPE2510)	Impact Report	IRBINDS	Specifies the total number of binds to be performed
BMCSTATE	Auxiliary Index	AUXIXBMCSTATE	References the state of the object referenced in the schema source input The valid values are CREATE, MODIFIED, and EXISTS. The BMCSTATE attribute is available for all parent objects. The child object (sub-object) can access the parent object's BMCSTATE attribute.
	Auxiliary Index Partition	AUXIXBMCSTATE
	Auxiliary Table	AUXTBBMCSTATE
	Database	DBBMCSTATE
	Index	IXBMCSTATE
	Index Partition	IXBMCSTATE
	LOB Table Space	LOBTSBMCSTATE
	LOB Table Space Partition	LOBTSBMCSTATE
	Storage Group	SGBMCSTATE
	Table	TBBMCSTATE
	Table Column	TBBMCSTATE
	Table Space	TSBMCSTATE
	Table Space Partition	TBBMCSTATE, TSBMCSTATE
	View	VWBMCSTATE
	View Column	VWBMCSTATE
	Volume	SGBMCSTATE
BUFFERPOOL	Auxiliary Index	AUXIXBUFFERPOOL	Indicates the buffer pool used for this object. For databases, it is the default buffer pool for table spaces.
	Database	DBBUFFERPOOL
	Index	IXBUFFERPOOL
	LOB Table Space	LOBTSBUFFERPOOL
	Table Space	TSBUFFERPOOL
CARDF (BMC.DB2.SPE2510)	Impact Utility	IUCARDF	Specifies the cardinality of the object
CCSID	Database	DBCCSID	Default encoding scheme for the object. ASCII EBCDIC UNICODE NONE—For table columns, if the column has a data type that does not have an encoding scheme or the encoding scheme of the column is the same as the table
	Table	TBCCSID
	Table Column	COCCSID
	Table Space	TSCCSID
CHECK_OPTION	View	VWCHECKOPTION	Whether the WITH CHECK OPTION clause was specified in the CREATE VIEW statement. NO—No CASCADED—Yes with cascaded semantic YES—Yes with local semantic
CLOSE	Auxiliary Index	AUXIXCLOSE	Whether the data sets can be closed when the maximum number of open data sets is reached. Valid values are YES and NO.
	Index	IXCLOSE
	LOB Table Space	LOBTSCLOSE
	Table Space	TSCLOSE
CLUSTERING	Index	IXCLUSTERING	Indicates whether the keyword CLUSTER was specified when the index was created. Valid values are YES and NO.
COLCOUNT	Index	IXCOLCOUNT	Specifies the number of columns in the object.
	Table	TBCOLCOUNT
	View	VWCOLCOUNT
COLS IN PRIMARY KEY	Table	TBCOLS_IN_PRIMARY_KEY	The number of columns in the table's primary key.
COLTYPE	Table Column	COCOLTYPE	Column type Valid values are: INTEGER—Large Integer SMALLINT—Small Integer FLOAT—Floating point CHAR—Fixed length character string VARCHAR—Varying length character string LONGVAR—Varying length character string DECIMAL—Decimal GRAPHIC—Fixed length graphic string VARG—Varying length graphic string LONGVARG—Varying length graphic string DATE—Date TIME—Time TIMESTMP—Timestamp TIMESTZ—Timestamp with time zone BLOB—Binary large object CLOB—Character large object DBCLOB—Double-byte character large object ROWID—Row ID data type DISTINCT—Distinct type XML—XML data type BIGINT—Big integer BINARY—Fixed length binary string VARBIN—Varying length binary string DECFLOAT—Decimal floating point
COMMENT	Auxiliary Index	AUXIXCOMMENT	The information from the COMMENT ON statement. Valid values for field are BMCEXIST and BMCNOTEXIST. You can also use the operators: is empty is not empty
	Auxiliary Table	AUXTBCOMMENT
	Index	IXCOMMENT
	Table	TBCOMMENT
	Table Column	COCOMMENT
	View	VWCOMMENT
	View Column	VWCOCOMMENT
COMPRESS	Auxiliary Index	AUXIXCOMPRESS	Indicates if compression is active. Valid values are YES and NO. NULL for objects that were created before Db2 V12
	Index	IXCOMPRESS
	LOB Table Space Partition	LOBTPCOMPRESS
	Table Space Partition	TPCOMPRESS
COPY	Auxiliary Index	AUXIXCOPY	Determines if the index can be copied. Valid values are YES and NO.
COPY	Index	IXCOPY
CREATES (BMC.DB2.SPE2510)	Impact Report	IRCREATES	Specifies the total number of objects to create
CREATES_IX (BMC.DB2.SPE2510)	Impact Report	IRCREATES_IX	Specifies the number of indexes to create
CREATES_TB (BMC.DB2.SPE2510)	Impact Report	IRCREATES_TB	Specifies the number of tables to create
CREATES_TS (BMC.DB2.SPE2510)	Impact Report	IRCREATES_TS	Specifies the number of table spaces to create
CREATES_VW (BMC.DB2.SPE2510)	Impact Report	IRCREATES_VW	Specifies the number of views to create
CREATOR	Auxiliary Index	AUXIXCREATOR	The schema of the object
	Auxiliary Table	AUXTBCREATOR
	Database	DBCREATOR
	Index	IXCREATOR
	LOB Table Space	LOBTSCREATOR
	Storage Group	SGCREATOR
	Table	TBCREATOR
	Table Space	TSCREATOR
	View	VWCREATOR
CREATORTYPE	Database	DBCREATORTYPE	Type of creator. Valid values are Authid or Role. Available when BMCSTATE equals EXISTS or MODIFIED
	Storage Group	SGCREATORTYPE
	Table Space	TSCREATORTYPE
DATA CAPTURE	Table	TBDATA_CAPTURE	Indicates whether additional information is logged on SQL INSERT, UPDATE, and DELETE statements. Valid values are as follows: (Default) NONE—No additional logging CHANGES—Additional logging should be performed
DATACLAS	Storage Group	SGDATACLAS	SMS Data class name, blank if not used.
DB2_VERSION (BMC.DB2.SPE2510)	Impact Report	IRDB2_VERSION	Specifies the IBM Db2 version
DBNAME	Auxiliary Table	AUXTBDBNAME	Database that contains the table space. For auxiliary tables, the database that the table resides in. For tables, the database that contains the table space in the TSNAME field.
	LOB Table Space	LOBTSDBNAME
	LOB Table Space Partition	LOBTPDBNAME
	Table	TBDBNAME
	Table Space	TSDBNAME
	Table Space Partition	TPDBNAME
DEFAULT	Table Column	CODEFAULT	This information is pertinent if the TYPE field in SYSTABLES is T or G. A—ROWID Generated Always B—Default value depends on the data type D—ROWID Generated by Default E—Defined as FOR EACH ROW ON UPDATE and Generated Always F—Defined as FOR EACH ROW ON UPDATE and Generated By Default I—As Identity Generated Always J—As Identity Generated by Default K—Implicit DOCID column for a base table that contains XML data L—Defined with AS SECURITY LABEL attribute N—No default value Q—AS ROW BEGIN attribute R—AS ROW END attribute S—Value of the SQL AUTHID at the time a default value is used U—Value of the USER special register at the time a default value is used X—AS TRANSACTION START ID attribute Y —If NULLS is Y, the default value is null. If NULLS is N, the default value depends on the data type. 1—String constant found in the DEFAULTVALUE column 2—Floating point constant found in the DEFAULTVALUE column 3—Decimal constant found in the DEFAULTVALUE column 4—Integer
DEFAULTVALUE	Table Column	CODEFAULTVALUE	This information is pertinent if the TYPE field in SYSTABLES is T or G. For more information, see DEFAULT.
DEFER	Index	IXDEFER	For indexes being created, determines whether DEFER was requested. Valid values are YES and NO. Only valid for Indexes with a BMCSTATE of CREATE.
DEFINE	LOB Table Space	LOBTSDEFINE	Table space data sets are allocated at table space creation. Valid values are YES and NO.
DEFINE	Table Space	TSDEFINE
DROP RESTRICT	Table	TBDROP_RESTRICT	Determines whether RESTRICT ON DROP applies. NO—No restriction on DROP exists YES—Neither the table, table space, nor database that contains the table can be dropped
DROPCREATES (BMC.DB2.SPE2510)	Impact Report	IRDROPCREATES	Specifies the total number of objects to be dropped and re-created in the worklist. Some objects might be implicitly dropped because of the drop of a higher level object.
DROPCREATES_IX (BMC.DB2.SPE2510)	Impact Report	IRDROPCREATES_iX	Specifies the number of indexes to be dropped and re-created in the worklist. Some objects might be implicitly dropped because of the drop of a higher level object.
DROPCREATES_TB (BMC.DB2.SPE2510)	Impact Report	IRDROPCREATES_TB	Specifies the number of tables to be dropped and re-created in the worklist. Some objects might be implicitly dropped because of the drop of a higher level object.
DROPCREATES_TS (BMC.DB2.SPE2510)	Impact Report	IRDROPCREATES_TS	Specifies the number of table spaces to be dropped and re-created in the worklist. Some objects might be implicitly dropped because of the drop of a higher level object.
DROPCREATES_VW (BMC.DB2.SPE2510)	Impact Report	IRDROPCREATES_VW	Specifies the number of views to be dropped and re-created in the worklist. Some objects might be implicitly dropped because of the drop of a higher level object.
DROPS (BMC.DB2.SPE2510)	Impact Report	IRDROPS	Specifies the total number of objects to be dropped. Some objects might be implicitly dropped because of the drop of a higher level object.
DROPS_IX (BMC.DB2.SPE2510)	Impact Report	IRDROPS_IX	Specifies the number of indexes to be dropped, either explicitly or implicitly, because of the drop of a higher level object.
DROPS_TB (BMC.DB2.SPE2510)	Impact Report	IRDROPS_TB	Specifies the number of tables to be dropped, either explicitly or implicitly, because of the drop of a higher level object.
DROPS_TS (BMC.DB2.SPE2510)	Impact Report	IRDROPS_TS	Specifies the number of table spaces to be dropped, either explicitly or implicitly, because of the drop of a higher level object.
DROPS_VW (BMC.DB2.SPE2510)	Impact Report	IRDROPS_VW	Specifies the number of views to be dropped, either explicitly or implicitly, because of the drop of a higher level object.
DSSIZE	Index	IXDSSIZE	Maximum size on a partitioned object data set in gigabytes. 0–for a nonpartitioned index. 1G–1048575 4G–4194300 ... 1024G–1073740800 NULL for objects that were created before Db2 V12.
	Index Partition	IPDSSIZE
	LOB Table Space Partition	LOBTPDSSIZE
	Table Space	TSDSSIZE
	Table Space Partition	TPDSSIZE
EDITPROC	Table	TBEDITPROC	Specifies the program name of the edit procedure for the table
ERASE	Auxiliary Index	AUXIXERASE	Determines whether the data sets are erased when the object is dropped. Valid values are YES and NO.
	Index	IXERASE
	LOB Table Space	LOBTSERASE
	Table Space	TSERASE
EXPLICIT_COL_LIST	View	VWCOLLISTSPECIFIED	Determines whether the View has an explicit column list before the View Text. NO—No column list YES—Column List Blank—View read from Catalog via profile, col list data not available
FIELD PROC	Table Column	COFIELD_PROC	Determines whether this column has a field procedure. Valid values are NO and YES.
FREEPAGE	Auxiliary Index Partition	AUXIPFREEPAGE	Number of pages loaded before a page is left as free space NULL for objects that were created before Db2 V12.
	Index Partition	IPFREEPAGE
	Table Space Partition	TPFREEPAGE
GBPCACHE	Auxiliary Index Partition	AUXIPGBPCACHE	Group buffer pool cache option specified for this object. Valid values are as follows: ALL—Changed and unchanged pages are cached in the group buffer pool CHANGED—Only changed pages are cached in the group buffer pool NONE—No data is cached in the group buffer pool SYSTEM—Only changed system pages, such as space map pages, are cached (LOB Table Space Partition and Table Space Partition only) NULL for objects that were created before Db2 V12
	Index Partition	IPGBPCACHE
	LOB Table Space Partition	LOBTPGBPCACHE
	Table Space Partition	TPGBPCACHE
HIDDEN	Table Column	COHIDDEN	Indicates whether the column is hidden from SQL statements. Valid values are as follows: NO—Not hidden - visible to all SQL statements YES—Hidden from SELECT * statements
HISTORY TB CREATOR	Table	TBHISTORY_TB_CREATOR	Specifies the schema name of the history table
HISTORY TB NAME	Table	TBHISTORY_TB_NAME	Specifies the table name of the history table
IMAGECOPIES (BMC.DB2.SPE2510)	Impact Report	IRIMAGECOPIES	Specifies the number of image copies to take
IMAGECOPY_VENDOR (BMC.DB2.SPE2510)	Impact Report	IRIMAGECOPY_VENDOR	Specifies the vendor utility to use IBM—IBM utilities AMI—BMC AMI utilities
IMPACTED_PARTS (BMC.DB2.SPE2510)	Impact Utility	IUIMPACTED_PARTS	Specifies the number of partitions that the utility should process
IMPLICIT	Database	DBIMPLICIT	Indicates whether this is an implicit object. NO—The object was created explicitly YES—The object was created implicitly Available when BMCSTATE equals EXISTS or MODIFIED
	LOB Table Space	LOBTSIMPLICIT
	Table Space	TSIMPLICIT
INDEX TYPE	Index	IXINDEX_TYPE	Valid values are as follows: 2—Type 2 index, or hash overflow index on non-partitioned tables D—Data partitioned secondary index P—Partitioning index on a table that uses table-controlled partitioning blank—Type 1 index
INDEXBP	Database	DBINDEXBP	Default buffer pool for indexes
INSERT_ALGORITHM	Table Space	TSINSERT_ALGORITHM
IX_EXTENSION_TYPE	Index	IXIX_EXTENSION_TYPE	Type of extended index. Valid values are as follows: blank—SIMPLE index N—NODEID index S—SCALAR Index on expression V—XML index T—SPATIAL index
IXCREATOR	Auxiliary Index Partition	AUXIPIXCREATOR	Auxiliary Index creator
IXCREATOR	Index Partition	IPIXCREATOR	Index creator
IXNAME	Auxiliary Index Partition	AUXIPIXNAME	Auxiliary Index name
IXNAME	Index Partition	IPIXNAME	Index name
KEYLABEL	Storage Group	SGKEYLABEL	The key label specified for Transparent Data set Encryption
KEYLABEL	Table	TBKEYLABEL	The key label specified for Transparent Data set Encryption
LABEL	Auxiliary Table	AUXTBLABEL	The information from the LABEL ON statement. Valid values for field are as follows: BMCEXIST BMCNOTEXIST You can also use the operators: is empty is not empty
	Table	TBLABEL
	Table Column	COLABEL
	View	VWLABEL
	View Column	VWCOLABEL
LENGTH	Table Column	COLENGTH	Length or precision of the column INTEGER—4 SMALLINT—2 FLOAT—4 or 8 CHAR—Length of the string VARCHAR—Length of the character string LONGVAR—Length of the character string DECIMAL—Precision of the decimal value GRAPHIC—Number of DBCS characters VARG—Maximum number of DBCS characters LONGVARG—Maximum number of DBCS characters DATE—4 TIME—3 TIMESTMP—0 LOB—4 - Length of the field in the base table. The maximum length of LOB is found in LENGTH2. INLINE—LOB 4 plus the inline length (in byte) is stored in the base table. The maximum length of the LOB column is found in LENGTH2. CLOB—4 - Length of the field in the base table. The maximum length of CLOB is found in LENGTH2 DBCLOB—4 - Length of the field in the base table. The maximum length of DBLOB is found in LENGTH2. ROWID—7 The maximum length of identifier VARBINARY—The maximum length of string DECFLOAT—8 or 16 TIMESTAMP WITHOUT TIME ZONE—Integral part of ((v+1)/2) + 7 where V is the precision of the time stamp TIMESTAMP WITH TIME ZONE—Integral part of ((v+1)/2) + 9 where V is the precision of the time stamp
LENGTH2	Table Column	COLENGTH2	Length or precision of the column INTEGER—4 SMALLINT—2 FLOAT—4 or 8 CHAR—Length of the string VARCHAR—Length of the character string LONGVAR—Length of the character string DECIMAL—Precision of the decimal value GRAPHIC—Number of DBCS characters VARG—Max number of DBCS characters LONGVARG—Max number of DBCS characters DATE—4 TIME—3 TIMESTMP—10 BLOB—4 - Length of the field in the base table. The maximum length of LOB is found in LENGTH2. CLOB—4 - Length of the field in the base table. The maximum length of LOB is found in LENGTH2. DBCLOB—4 - Length of the field in the base table. The maximum length of LOB is found in LENGTH2. ROWID—17 DISTINCT—Length of the source data type XML—6 BIGINT—8 BINARY—Length of string VARBINARY—Maximum length of string DECFLOAT—8 or 16
LOAD_VENDOR (BMC.DB2.SPE2510)	Impact Report	IRLOAD_VENDOR	Specifies the vendor utility to use: IBM—IBM Load BMC—BMC LOADPLUS AMI—BMC AMI Load
LOADS (BMC.DB2.SPE2510)	Impact Report	IRLOADS	Specifies the number of Load utilities to run.
LOCKMAX	LOB Table Space	LOBTSLOCKMAX	The maximum number of locks per user for this table space before escalation to the next locking level. 0—No lock escalation n—The maximum number of locks before escalation occurs. n is an integer value > 0 -1—SYSTEM - The value on panel, DSNTIPJ, determines the lock escalation
LOCKMAX	Table Space	TSLOCKMAX
LOCKSIZE	LOB Table Space	LOBTSLOCKSIZE	The lock size of the table space. ANY LOB TABLESPACE
LOCKSIZE	Table Space	TSLOCKSIZE	The lock size of the table space. ANY LOB TABLESPACE
LOGGED	LOB Table Space	LOBTSLOGGED	Determines whether changes to a table space are logged. NO—NOT LOGGED; undo and redo logging for the table space and all indexes is suppressed. YES—LOGGED; normal logging is associated with changes to this table space and its indexes.
LOGGED	Table Space	TSLOGGED
MAXPARTITIONS	Table Space	TSMAXPARTITIONS	Indicates whether the tables pace is partitioned-by-growth or the maximum number of partitions allowed for the table space.
MAXROWS	Table Space	TSMAXROWS	Indicates the maximum number of rows on a data page. The default value is 255.
MEMBER_CLUSTER	Table Space	TSMEMBER_CLUSTER	Indicates whether or not MEMBER CLUSTER is specified for the table space. NULL for table spaces that were created before Db2 V12. YES—MEMBER CLUSTER is specified for the table space. NO—MEMBER CLUSTER is not specified for the table space.
MEMBER_CLUSTER	Table Space Partition	TPMEMBER_CLUSTER
MGMTCLAS	Storage Group	SGMGMTCLAS	SMS Management class name, blank if not used.
NAME	Auxiliary Index	AUXIXNAME	Specifies the name of the object
	Auxiliary Table	AUXTBNAME
	Database	DBNAME
	Index	IXNAME
	LOB Table Space	LOBTSNAME
	Storage Group	SGNAME
	Table	TBNAME
	Table Column	CONAME
	Table Space	TSNAME
	View	VWNAME
	View Column	VWCONAME
NTABLES	Table Space	TSNTABLES	Indicates the number of tables in the table space
NULLS	Table Column	CONULLS
OBJNAME_PART1 (BMC.DB2.SPE2510)	Impact Utility	IUOBJNAME_PART1	Part one of the object name: creator for tables and indexes, and database name for table spaces
OBJNAME_PART2 (BMC.DB2.SPE2510)	Impact Utility	IUOBJNAME_PART2	Part two of the object name: the name of the table space, table, or index
OBJTYPE (BMC.DB2.SPE2510)	Impact Utility	IUOBJTYPE	Object type: IX—Index TB—Table TS—Table space
OWNER	Auxiliary Index	AUXIXOWNER	Authorization ID (AUTHID) of the object owner For an Auxiliary Index or Index the value is an empty string for indexes that were created before Db2 V9.
	Auxiliary Table	AUXTBOWNER
	Index	IXOWNER
	Table	TBOWNER
OWNERTYPE	Index	IXOWNERTYPE	Available when BMCSTATE equals EXISTS or MODIFIED Valid values are AuthID and Role.
OWNERTYPE	Table	TBOWNERTYPE
PADDED	Index	IXPADDED	Specifies whether keys in the index will be padded for varying- length indexes. Valid values are as follows: NO—Index is not padded and index only access to all column data is possible. YES—Index is padded and varying-length columns are padded to the maximum length.
PAGENUM	Table Space	TSPAGENUM	Indicates absolute or relative page numbering for the format of pages for the table space and indexes created on tables in the table space ABSOLUTE—Indicates absolute addressing so that PAGENUM contains the embedded partition number. RELATIVE—Indicates relative addressing so that PAGENUM contains only the relative page number. NULL for objects that were created before Db2 V12
PART KEY COL NUMBER	Table	TBPART_KEY_COL_NUMBER	The number of columns in the partitioning key. The attribute displays zero for non-partitioned table spaces or those that use index-based partitioning.
PARTITION	Auxiliary Table	AUXTBPARTNUM	Partition number that the object supports
	Index Partition	IPPARTITION
	Table Space Partition	TPPARTITION
PARTITIONS	Table Space	TSPARTITIONS	Indicates the number of partitions in the tablespace. This value is 0 if the table space is not partitioned.
PCTFREE	Index Partition	IPPCTFREE	Percentage of each leaf or non-leaf page to be left as free space
PCTFREE	Table Space Partition	TPPCTFREE
PCTFREE_UPD	Table Space Partition	TPPCTFREE_FOR_UPDATE	Percentage of free space reserved for updates to variable length records, as defined when the object is created or altered
PERCENT FREE	Auxiliary Index Partition	AUXIPPCTFREE	Percentage of each page left as free space NULL for objects that were created before Db2 V12.
PIECESIZE	Auxiliary Index	AUXIXPIECESIZE	Maximum size of a data set in kilobytes for secondary indexes 0 for a Partitioning index or before Db2 V5
PIECESIZE	Index	IXPIECESIZE
PRIQTY	Auxiliary Index Partition	AUXIPPRIQTY	Primary space allocation in units of 4-KB storage blocks or -1.
	Index Partition	IPPRIQTY
	LOB Table Space Partition	LOBTPPRIQTY
	Table Space Partition	TPPRIQTY
REORG_VENDOR (BMC.DB2.SPE2510)	Impact Report	IRREORG_VENDOR	Specifies the vendor utility to use: IBM—IBM Reorg BMC—BMC REORG PLUS AMI—BMC AMI Reorg
REORGS (BMC.DB2.SPE2510)	Impact Report	IRREORGS	Specifies the number of Reorg utilities to run
RUNSTATS (BMC.DB2.SPE2510)	Impact Report	IRRUNSTATS	Specifies the number of Stats utilities to run
RUNSTATS_VENDOR (BMC.DB2.SPE2510)	Impact Report	IRRUNSTATS_VENDOR	Specifies the vendor utility to use: IBM—IBM RUNSTATS BMC—BMCSTATS AMI—BMC AMI Stats
SCALE	Table Column	COSCALE	Scale of the field if the type is DECIMAL. If the type is time stamp or time stamp with time zone, the value represents the number of fractional second digits. Otherwise, the value is 0.
SECQTY	Auxiliary Index Partition	AUXIPSECQTY	Secondary space allocation in units of 4-KB storage or -1.
	Index Partition	IPSECQTY
	LOB Table Space Partition	LOBTPSECQTY
	Table Space Partition	TPSECQTY
SEGSIZE	Table Space	TSSEGSIZE	Indicates how many pages will be assigned to each segment of a segmented table space The values is an integer value from 4 through 64 that is a multiple of 4.
SGNAME	Volume	VLSGNAME	Storage group name
SIZE (BMC.DB2.SPE2510)	Impact Utility	IUSIZE	Estimated size of the object in KB
SSID (BMC.DB2.SPE2510)	Impact Report	IRSSID	Db2 subsystem ID where the Work ID was analyzed
STORCLAS	Storage Group	SGSTORCLAS	SMS Storage class name, blank if not used
STOGROUP	Auxiliary Index Partition	AUXIPSTOGROUP	Name of storage group Blank if storage group is not used, for the catalog table spaces, or for a system database. NULL for objects that were created before Db2 V12.
	Database	DBSTOGROUP
	Index Partition	IPSTOGROUP
	LOB Table Space Partition	LOBTPSTOGROUP
	Table Space Partition	TPSTOGROUP
STORTYPE	Auxiliary Index Partition	AUXIPSTORTYPE	Type of storage allocation. Valid values are as follows: E—Explicit (storage group not used) I—Implicit (storage group used) NULL for objects that were created before Db2 V12
	Index Partition	IPSTORTYPE
	LOB Table Space Partition	LOBTPSTORTYPE
	Table Space Partition	TPSTORTYPE
TBCREATOR	Auxiliary Index	AUIXTBCREATOR	Auxiliary Table Creator on which the index is built
	Index	IXTBCREATOR	Schema of the table that contains the column
	Table	TBTBCREATOR	For a base table involved in a clone relationship, it is the name of the creator for the clone table. For a clone table involved in a clone relationship, it is the name of the creator for the base table.
	Table Column	COTBCREATOR	Schema of the table that contains the column
TBNAME	Auxiliary Index	AUXIXTBNAME	Auxiliary Table name
	Index	IXTBNAME	Table on which the index is built
	Table	TBTBNAME	For a base table involved in a clone relationship, it is the name of the clone table. For a clone table involved in a clone relationship, it is the name of the base table.
	Table Column	COTBNAME	Table that contains the column.
TOTAL_PARTS (BMC.DB2.SPE2510)	Impact Utility	IUTOTAL_PARTS	Total number of partitions in the object.
TRACKMOD	Table Space Partition	TPTRACKMOD	Indicates whether page changes in the space map pages are tracked. Valid values are NO or YES.
TSNAME	Auxiliary Table	AUXTBTSNAME	Specifies the table space name that contains the object it supports
	LOB Table Space Partition	LOBTPTSNAME
	Table	TBTSNAME
	Table Space Partition	TPTSNAME
TYPE	Table	TBTYPE	Specifies the type of object. Valid values are as follows: C—Clone table G—Created Global temporary table H—History table R—Archive Table T—Table
TYPE	Table Space	TSTYPE
TYPENAME	Table Column	COTYPENAME	If COLTYPE is DISTINCT, the name of the distinct type. Otherwise, the value is the same as COLTYPE.
TYPESCHEMA	Table Column	COTYPESCHEMA	If COLTYPE is DISTINCT, the schema of the distinct type. Otherwise, the value is SYSIBM.
UNIQUE RULE	Index	IXUNIQUE_RULE	Specifies if this index is unique. Valid values are as follows: C—Yes and it is used to enforce the uniqueness of hash key columns D—No - duplicates are allowed G—Yes and the index is used to enforce uniqueness in a ROWID GENERATED BY DEFAULT column N—Yes and the index is defined as UNIQUE NOT NULL P—Yes and it is a primary index R—Yes and the index is used to enforce uniqueness of a non-primary parent key U—Yes X—Yes and it is used to enforce the uniqueness in a column that contains XML values
UNLOAD_VENDOR (BMC.DB2.SPE2510)	Impact Report	IRUNLOAD_VENDOR	Specifies the vendor utility to use. IBM - IBM Unload BMC - BMC UNLOAD PLUS AMI - BMC AMI Unload
UNLOADS (BMC.DB2.SPE2510)	Impact Report	IRUNLOADS	Specifies the number of Unload utilities to run.
UTILITY (BMC.DB2.SPE2510)	Impact Utility	IUUTILITY	Name of the utility. UNLOAD LOAD REORG
VALIDPROC	Table	TBVALIDPROC	Program name of the validation procedure for the table
VCAT	Auxiliary Index Partition	AUXIPVCAT	Name of Integrated catalog facility catalog used for space allocation NULL for objects that were created before Db2 V12.
	Index Partition	IPVCAT
	LOB Table Space Partition	LOBTPVCAT
	Table Space Partition	TPVCAT
VCATNAME	Storage Group	SGVCATNAME	Name of the ICF catalog
VOLATILE	Table	TBVOLATILE	Indicates if the table is VOLATILE. Valid values are YES and NO. Tells Db2 to use index access on this table whenever possible.
VOLUME	Volume	VLVOLUME	Volume name or * if SMS managed
VWCREATOR	View Column	VWCOVWCREATOR	Schema of the view that contains the column
VWNAME	View Column	VWCOVWNAME	Name of the view that contains the column
WITH ROW ATTRIBUTE	Table	TBWITH_ROW_ATTRIBUTE	Edit procedure on table defined WITH/WITHOUT row attribute sensitivity. YES—Defined WITH row attribute sensitivity NO—Defined WITHOUT row attribute sensitivity
WKNAME (BMC.DB2.SPE2510)	Impact Report	IRWKNAME	Name of the Work ID saved in the WorkID Impact table.
WKNAME (BMC.DB2.SPE2510)	Impact Utility	IUWKNAME	Name of the Work ID saved in the WorkID Impact table.
WKOWNER (BMC.DB2.SPE2510)	Impact Report	IRWKOWNER	Owner of the Work ID saved in the WorkID Impact table.
WKOWNER (BMC.DB2.SPE2510)	Impact Utility	IUWKOWNER	Owner of the Work ID saved in the WorkID Impact table.