Db2 for z/OS 12.0.0
A tabela SYSTABLES_PROFILES contém uma linha para cada perfil associado a uma tabela em SYSIBM.SYSTABLES.
O esquema é SYSIBM.
As linhas nesta tabela podem ser inseridas, atualizadas e excluídas.
The SYSTABLES_PROFILES table contains one row for each profile that is associated with a table in SYSIBM.SYSTABLES.
The schema is SYSIBM.
Rows in this table can be inserted, updated, and deleted.
| 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 |
© Copyright IBM Corp.
|
