A tabela SYSAUTOALERTS contém uma linha para cada recomendação de procedimentos autônomos.
O esquema é SYSIBM.
The SYSAUTOALERTS table contains one row for each recommendation from autonomic procedures.
The schema is SYSIBM.
| Column name |
Data type |
Description |
Use |
| ALERT_ID |
BIGINT
NOT NULL
GENERATED ALWAYS
AS IDENTITY |
The ID of the alert described in this row. |
G |
| HISTORY_ENTRY_ID |
BIGINT
NOT NULL |
The ID of the entry in the ADMIN_UTLPROCEDURES_HIST procedure that produced this alert. |
G |
| ACTION |
VARCHAR(32)
NOT NULL |
The type of action requested by this alert. |
G |
| TARGET_QUALIFIER |
VARCHAR(128)
NOT NULL |
The qualifier name of the Db2 object (the database name) to which this alert applies. |
G |
| TARGET_OBJECT |
VARCHAR(128)
NOT NULL |
The name of the Db2 object (the table space name) to which this alert applies. |
G |
| TARGET_PARTITION |
SMALLINT
NOT NULL |
The partition number of the Db2 object to which this alert applies.
Zero, if this alert applies to all partitions or if the object is not partitioned. |
G |
| OPTIONS |
VARCHAR(4000) |
The options that should be specified when the corresponding action is run:
- USE PROFILE
- Use the options specified in the profile
- TABLE
- Options only apply for this table
- COLUMNS
- Options only apply for these columns
- SAMPLE
- The table space is too big and sampling is allowed
|
G |
| CREATEDTS |
TIMESTAMP
NOT NULL
WITH DEFAULT |
The timestamp when the alert was issued. |
G |
| DURATION |
INTEGER |
An estimate of the time, in seconds, that would be needed to run the corresponding action. class="dlentry"
If this column contains NULL, the execution plan might overwrite the time window. |
G |
| STATUS |
VARCHAR(32) |
The status of the actual planned task. Valid values are:
- OPEN
- The alert is not yet resolved
- INPROGRESS
- The alert execution is in progress
- COMPLETED
- The alert execution is complete
|
G |
| STARTTS |
TIMESTAMP |
The timestamp for when the alert execution started.
This column contains NULL if the task execution has not yet started. |
G |
| ENDTS |
TIMESTAMP |
The timestamp for when the alert execution ended.
This column contains NULL if the task execution has not yet ended. |
G |
| RETURN_CODE |
INTEGER |
The return code that is written directly by the autonomic stored procedure that resolved the alert.
This column contains NULL if the alert is not yet resolved, if the autonomic stored procedure failed, or if the autonomic stored procedure does not write any
return code. A RETURN_CODE of 0 is expected in case of a successful execution. |
G |
| ERROR_MESSAGE |
VARCHAR(1331) |
An error message that indicates why the alert was not resolved successfully.
This column contains NULL if the alert is not yet resolved, or if the autonomic stored procedure that executes the alert does not write any error message.
No ERROR_MESSAGE text is expected in case of a successful execution. |
G |
| OUTPUT |
CLOB(2M) |
The output that is written directly by the autonomic stored procedure that executes the planned task.
This column contains NULL if the task is not yet executed, if the execution failed, or if the autonomic stored procedure does not write any output. |
G |
| ROWID |
ROWID
NOT NULL
GENERATED ALWAYS |
The ROWID value for the CLOB column of this table. |
G |
