Column names in WHERE clauses

The following sections describe the column names that you can use in WHERE clauses:

Global condition names
BMC AMI Utility Manager columns for table spaces
BMC AMI Utility Manager columns for indexes

Global condition names

Use the following global column names (G.columnName) with WHERE clauses. These global columns are available for use in EXCEPTION and CRITERIA table WHERE clauses.

Column name	Description
G.ACCOUNT	Job accounting data
G.DB2_VERSION	Db2 version
G.JOBNAME	Job name
G.NEEDS_COPY 'Y'	Whether the criterion specifies that Copy is required
G.NEEDS_REORG 'Y'	Whether the criterion specifies that Reorg is required
G.NEEDS_STATS 'Y'	Whether the criterion says that Stats is required
G.PLAN	Plan name
G.PROGRAMMER	Job programmer
G.SSID	Db2 subsystem ID
G.STEPNAME	Step name
G.UID	Utility ID

BMC AMI Utility Manager columns for table spaces

To create criteria when you use the WHERE clause, use the following column names (A.columnName) with table spaces. These columns are only available for use in the CRITERIA table WHERE clauses, not EXCEPTION table WHERE clauses.

Important

The Db2 RTS tables use these column names. For more information about Db2 RTS tables and columns, see the IBM documentation.

A.COPYCHANGES
A.COPYLASTTIME
A.COPYUPDATEDPAGES
A.COPYUPDATELRSN
A.COPYUPDATETIME
A.DATASIZE
A.DBID
A.DBNAME
A.DRIVETYPE
A.EXTENTS
A.GETPAGES
A.HASHLASTUSED
A.INSTANCE
A.LOADRLASTTIME
A.LPFACILITY
A.NACTIVE
A.NAME
A.NPAGES
A.PARTITION
A.PSID
A.REORGCLUSTERSENS
A.REORGDELETES
A.REORGDISORGLOB
A.REORGFARINDREF
A.REORGHASHACCESS
A.REORGINSERTS
A.REORGLASTTIME
A.REORGMASSDELETE
A.REORGNEARINDREF
A.REORGSCANACCESS
A.REORGUNCLUSTINS
A.REORGUPDATES
A.SPACE
A.STATS01
A.STATSDELETES
A.STATSINSERTS
A.STATSLASTTIME
A.STATSMASSDELETE
A.STATSUPDATES
A.SYS_START
A.SYS_END
A.TOTALROWS
A.TRANS_START
A.UNCOMPRESSEDDATASIZE
A.UPDATESIZE
A.UPDATESTATSTIME

BMC AMI Utility Manager columns for indexes

To create criteria when you use the WHERE clause, use the following column names (A.columnName) with indexes. These columns are only available for use in the CRITERIA table WHERE clauses, not EXCEPTION table WHERE clauses.