A tabela SYSAUTOTIMEWINDOWS contém uma linha para cada período de tempo durante o qual os procedimentos autônomos podem ser executados.
O esquema é SYSIBM.
The SYSAUTOTIMEWINDOWS table contains one row for each time period during which autonomic procedures can be run.
The schema is SYSIBM.
| Column name |
Data type |
Description |
Use |
| WINDOW_ID |
BIGINT
NOT NULL
GENERATED ALWAYS
AS IDENTITY |
The ID of the time window described in this row. |
G |
| DB2_SSID |
CHAR(4) |
The Db2 member name on which the planned tasks have to be run.
If this column contains NULL, the tasks in this time window can be run on any Db2 member. |
G |
| MONTH_WEEK |
CHAR(1)
NOT NULL |
Indicates how the value of the DAY column is interpreted:
- M
- The value of the DAY column is interpreted as a day of the month
- W
- The value of the DAY column is interpreted as a day of the week
|
G |
| MONTH |
INTEGER |
Month in which the time window applies.
The value will be from 1 (January) to 12 (December).
If this column contains NULL, the time window applies to all months.
If MONTH_WEEK is 'W', this column must be NULL. |
G |
| DAY |
INTEGER |
Day of the month or day of the week for which the time window applies.
If this column contains NULL, the time window applies to every day of the month or to every day of the week (depending on the value of the MONTH_WEEK column). |
G |
| FROM_TIME |
TIME |
The time of day at which the time window begins. If this column contains NULL, no limitation on the time exists.
This column will contain NULL if the TO_TIME column contains NULL. |
G |
| TO_TIME |
TIME |
The time of day at which the time window ends.
If this column contains NULL, no limitation on the time exists.
This column will contain NULL if the FROM_TIME column contains NULL. |
G |
| ACTION |
VARCHAR(256) |
The comma-separated list of actions that are allowed during this time window.
If this column contains NULL, all actions are allowed. |
G |
| MAX_TASKS |
INTEGER |
The number of concurrent actions that are allowed during this time window.
If this column contains NULL, any number of actions are allowed concurrently. |
G |
