DB2TFUL variables
This section describes the DB2TFUL variables.
Table 1. DB2TFUL variables in hilevel.UBBPROC
Variable name | Description | Default | Data Set member |
|---|---|---|---|
MAX_UTIL | default maximum database/tablespace (DB/TS) utilization for all DB/TSs associated with this subsystem; zero means no default threshold This value can be overridden for specific DB/TSs within each DB2 subsystem. | 0 | DSU101C |
MAX_EXTS | default maximum number of extents for all DB/TSs associated with this DB2 subsystem This value can be overridden for specific DB/TSs within each DB2 subsystem. | 0 | DSU101C |
NUM | total number of overrides for this DB2 subsystem | 4 | DSU101C |
NAME n | n th DBTS name to be overridden for percent space utilization and extent monitoring for this DB2 subsystem Generic DBTS names may be used. | NA | DSU101C |
NAME1 | first DBTS name | DSN* | DSU101C |
NAME2 | second DBTS name | DSNDB06_ DSNAPH01 | DSU101C |
NAME3 | third DBTS name | DSNDB07_ DSN4K01 | DSU101C |
NAME4 | fourth DBTS name | DSNDB06_ SYS* | DSU101C |
MAX_ UTILn | utilization threshold for all DB/TSs that satisfy the NAMEn qualification Zero means ignore percent utilization. | NA | DSU101C |
MAX_UTIL1 | utilization threshold for NAME1 | 0 | DSU101C |
MAX_UTIL2 | utilization threshold for NAME2 | 90 | DSU101C |
MAX_UTIL3 | utilization threshold for NAME3 | 50 | DSU101C |
MAX_UTIL4 | utilization threshold for NAME4 | 50 | DSU101C |
MAX_EXTSn | extent threshold for all DB/TS's that satisfy the NAMEn qualification Zero means ignore percent utilization. | NA | DSU101C |
MAX_EXTS1 | extent override for NAME1 | 0 | DSU101C |
MAX_EXTS2 | extent override for NAME2 | 1 | DSU101C |
MAX_EXTS3 | extent override for NAME3 | 20 | DSU101C |
MAX_EXTS4 | extent override for NAME4 | 1 | DSU101C |