SYSTABLES_PROFILES catalog table

The SYSTABLES_PROFILES table contains one row for each profile that is associated with a table in SYSIBM.SYSTABLES. The schema is SYSIBM.

Start of changeRows in this table can be inserted, updated, and deleted.End of change

Table 1. SYSIBM.SYSTABLES_PROFILES table column descriptions
Column name Data type Description Use
SCHEMA
VARCHAR(128)
NOT NULL
 The schema (qualifier) for the table. G
TBNAME
VARCHAR(128)
NOT NULL
 The table name. G
PROFILE_TYPE
VARCHAR(32)
NOT NULL
 The type of profile. Allowed values are 'RUNSTATS'. G
—
VARCHAR(32)
 Internal use only. I
PROFILE_TEXT
CLOB(1M)
 The text of the profile. G
ROWID
ROWID
NOT NULL
GENERATED ALWAYS
 The ROWID value for the LOB column of this table. G
PROFILE_UPDATE
TIMESTAMP
NOT NULL
 The last time the profile was updated, or the timestamp for when the profile was inserted into the table. G
—
TIMESTAMP
 Internal use only. I