| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPDB2 for AS4 |
1 | SQ1000_DB4 | iSeries: SQL Information (Database Monitor) | 46 | QQI1 | iSeries: Reserved Field (Database Monitor) | int | 10 | 0 | | |
2 | SQ1000_RST | iSeries: SQL Information (Database Monitor ) | 46 | QQI1 | iSeries: Reserved Field (Database Monitor) | int | 10 | 0 | | |
3 | SQ3000_DB4 | iSeries: Table Scans (Database Monitor) | 34 | QQI1 | iSeries: Reserved Field (Database Monitor) | int | 10 | 0 | | |
4 | SQ3001_DB4 | iSeries: Used Indexes (Database Monitor) | 46 | QQI1 | iSeries: Reserved Field (Database Monitor) | int | 10 | 0 | | |
5 | SQ3002_DB4 | iSeries: Created Indexes (Database Monitor) | 53 | QQI1 | iSeries: Reserved Field (Database Monitor) | int | 10 | 0 | | |
6 | SQ3003_DB4 | iSeries: Sorts (Database Monitor) | 22 | QQI1 | iSeries: Reserved Field (Database Monitor) | int | 10 | 0 | | |
7 | SQ3004_DB4 | iSeries: Temporary Files (Database Monitor) | 22 | QQI1 | iSeries: Reserved Field (Database Monitor) | int | 10 | 0 | | |
8 | SQ3007_DB4 | iSeries: Optimizer Timed Out (Database Monitor) | 24 | QQI1 | iSeries: Reserved Field (Database Monitor) | int | 10 | 0 | | |
9 | SQ3008_DB4 | iSeries: Subqueries (Database Monitor) | 16 | QQI1 | iSeries: Reserved Field (Database Monitor) | int | 10 | 0 | | |
10 | SQHVAR_DB4 | iSeries: Host Variable Values for Most Exp. Exec. of a Stmt. | 9 | QQI1 | iSeries: Reserved Field (Database Monitor) | int | 10 | 0 | | |
11 | SQTEXT_DB4 | iSeries: SQL Statement Text (Database Monitor) | 9 | QQI1 | iSeries: Reserved Field (Database Monitor) | int | 10 | 0 | | |