A tabela SYSAUTORUNS_HIST contém uma linha para cada vez que um procedimento autônomo é executado.
O esquema é SYSIBM.
The SYSAUTORUNS_HIST table contains one row for each time an autonomic procedures has been run.
The schema is SYSIBM.
| Column name |
Data type |
Description |
Use |
| HISTORY_ENTRY_ID |
BIGINT
NOT NULL
GENERATED ALWAYS
AS IDENTITY |
The ID of the entry in the history table. |
G |
| PROC_NAME |
VARCHAR(128)
NOT NULL |
The name of the autonomic stored procedure that produced this entry. |
G |
| STARTTS |
TIMESTAMP |
The timestamp when the autonomic stored procedure started. |
G |
| ENDTS |
TIMESTAMP |
The timestamp when the autonomic stored procedure ended. |
G |
| OUTPUT |
CLOB(2M) |
The output of the autonomic stored procedure. |
G |
| ERROR_MESSAGE |
VARCHAR(1331) |
An error message that indicates why the autonomic stored procedure was not successful.
No ERROR_MESSAGE text is expected in case of a successful execution. |
G |
| RETURN_CODE |
INTEGER |
The return code written directly by the autonomic stored procedure.
This column contains NULL if the autonomic stored procedure execution 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 |
| ROWID |
ROWID
NOT NULL
GENERATED ALWAYS |
The ROWID value for the OUTPUT column of this table. |
G |
