SAP ABAP Table SQ1000_RST (iSeries: SQL Information (Database Monitor ))
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
⤷ STU4 (Package) CCMS / AS/400
⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
⤷ STU4 (Package) CCMS / AS/400
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | SQ1000_RST | Table Relationship Diagram |
Short Description | iSeries: SQL Information (Database Monitor ) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | L | Table for storing temporary data, delivered empty |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | SYSID | SYSYSID | SYCHAR08 | CHAR | 8 | 0 | Name of SAP System | ||
2 | IPLTIME | CHAR14 | CHAR14 | CHAR | 14 | 0 | Text field length 14 | ||
3 | QQKEY | QQKEY | QQKEY | CHAR | 17 | 0 | iSeries: Key Field (Database Monitor) | ||
4 | QQTIME | QQTIME | QQTIME | CHAR | 26 | 0 | iSeries: Record Creation Timestamp (Database Monitor) | ||
5 | QQJOB | QQJOB | QQJOB | CHAR | 10 | 0 | iSeries: Job Name (Database Monitor) | ||
6 | QQUSER | QQUSER | QQUSER | CHAR | 10 | 0 | iSeries: Job User (Database Monitor) | ||
7 | QQJNUM | QQJNUM | QQJNUM | CHAR | 6 | 0 | iSeries: Job Number (Database Monitor) | ||
8 | QQUDEF | QUDEF | QQC18 | CHAR | 18 | 0 | iSeries: User-defined Field (Database Monitor) | ||
9 | QQPLIB | QQPLIB | QQC10 | CHAR | 10 | 0 | iSeries: Package/Program Library (Database Monitor) | ||
10 | QQPNAM | QQPNAM | QQC10 | CHAR | 10 | 0 | iSeries: Package/Program Name (Database Monitor) | ||
11 | QQCNAM | QQCNAM | QQC18 | CHAR | 18 | 0 | iSeries: Cursor Name (Database Monitor) | ||
12 | QQSNAM | QQSNAM | QQC18 | CHAR | 18 | 0 | iSeries: Statement Name (Database Monitor) | ||
13 | QQCNT | QQCNT | QQDEC150 | DEC | 15 | 0 | iSeries: No. of Executions of a Statement (Database Monitor) | ||
14 | QQAVGT | QQAVGT | QQDEC150 | DEC | 15 | 0 | iSeries: Average Time (Database Monitor) | ||
15 | QQMINT | QQMINT | QQDEC150 | DEC | 15 | 0 | iSeries: Minimum Time (Database Monitor) | ||
16 | QQMAXT | QQMAXT | QQDEC150 | DEC | 15 | 0 | iSeries: Maximum Time (Database Monitor) | ||
17 | QQOPNT | QQOPNT | QQDEC150 | DEC | 15 | 0 | iSeries: Open time (Database Monitor) | ||
18 | QQFETT | QQFETT | QQDEC150 | DEC | 15 | 0 | iSeries: FETCH time (Database Monitor) | ||
19 | QQCLST | QQCLST | QQDEC150 | DEC | 15 | 0 | iSeries: CLOSE time (Database Monitor) | ||
20 | QQOTHT | QQOTHT | QQDEC150 | DEC | 15 | 0 | iSeries: Any other time (Database Monitor) | ||
21 | QQLTU | QQLTU | QQTIME | CHAR | 26 | 0 | iSeries: Time Last Used (Database Monitor) | ||
22 | QQMETU | QQMETU | QQTIME | CHAR | 26 | 0 | iSeries: Timest. of Most Expensive Stmt. (Database Monitor) | ||
23 | QQAPRT | QQAPRT | QQTIME | CHAR | 26 | 0 | iSeries: Timestamp of Access Plan Rebuild (Database Monitor) | ||
24 | QQFULO | QQFULO | QQDEC150 | DEC | 15 | 0 | iSeries: Number of FULL OPENs (Database Monitor) | ||
25 | QQPSUO | QQPSUO | QQDEC150 | DEC | 15 | 0 | iSeries: Number of PSEUDO OPENs (Database Monitor) | ||
26 | QQTOTR | QTOTR | QQDEC150 | DEC | 15 | 0 | iSeries: Total Rows in Table (Database Monitor) | ||
27 | QQRROW | QQRROW | QQDEC150 | DEC | 15 | 0 | iSeries: Result Rows (Database Monitor) | ||
28 | QQSTF | QQSTF | QQSTF | CHAR | 1 | 0 | iSeries: Statement Function (Database Monitor) | ||
29 | QQSTOP | QQSTOP | QQC21 | CHAR | 2 | 0 | iSeries: Statement Operation (Database Monitor) | ||
30 | QQODPI | QQODPI | QQC11 | CHAR | 1 | 0 | iSeries: ODP Implementation (Database Monitor) | ||
31 | QQHVI | QQHVI | QQC11 | CHAR | 1 | 0 | iSeries: Host Variable Implementation (Database Monitor) | ||
32 | QQAPR | QQAPR | QQC41 | CHAR | 4 | 0 | iSeries: Reason Code for Access Plan Rebuild | ||
33 | QQDACV | QQDACV | QQC11 | CHAR | 1 | 0 | iSeries: Data Conversion (Database Monitor) | ||
34 | QQCTS | QQCTS | QQDEC150 | DEC | 15 | 0 | iSeries: Number of Table Scans (Database Monitor) | ||
35 | QQCIU | QQCIU | QQDEC150 | DEC | 15 | 0 | iSeries: Index Usage (Database Monitor) | ||
36 | QQCIC | QQCIC | QQDEC150 | DEC | 15 | 0 | iSeries: Number of Index Creates (Database Monitor) | ||
37 | QQCSO | QQCSO | QQDEC150 | DEC | 15 | 0 | iSeries: No. of Sorts (Database Monitor) | ||
38 | QQCTF | QQCTF | QQDEC150 | DEC | 15 | 0 | iSeries: No. of Temporaray File Creates (Database Monitor) | ||
39 | QQCIA | QQCIA | QQDEC150 | DEC | 15 | 0 | iSeries: Index Advice (Database Monitor) | ||
40 | QQCAPR | QQCAPR | QQDEC150 | DEC | 15 | 0 | iSeries: No of Access Plan Rebuilds (Database Monitor) | ||
41 | QQARSS | QQARSS | QQDEC150 | DEC | 15 | 0 | iSeries: Average Result Set Size (Database Monitor) | ||
42 | QQC11 | QQC11 | QQC11 | CHAR | 1 | 0 | iSeries: Reserved Field (Database Monitor) | ||
43 | QQC12 | QQC12 | QQC12 | CHAR | 1 | 0 | iSeries: Reserved Field (Database Monitor) | ||
44 | QQC21 | QQC21 | QQC21 | CHAR | 2 | 0 | iSeries: Reserved Field (Database Monitor) | ||
45 | QQC22 | QQC22 | QQC22 | CHAR | 2 | 0 | iSeries: Reserved Field (Database Monitor) | ||
46 | QQI1 | QQI1 | QQI1 | INT4 | 10 | 0 | iSeries: Reserved Field (Database Monitor) | ||
47 | QQI2 | QQI2 | QQI2 | INT4 | 10 | 0 | iSeries: Reserved Field (Database Monitor) | ||
48 | QQC301 | QQC301 | QQC301 | CHAR | 30 | 0 | iSeries: Reserved Field (Database Monitor) | ||
49 | QQC302 | QQC302 | CHAR | 30 | 0 | iSeries: Reserved Field (Database Monitor) | |||
50 | QQ1000 | QQ1000 | CHAR | 255 | 0 | iSeries: Reserved Field (Database Monitor) | |||
51 | TOTTIME | TOTTIME | QQDEC150 | DEC | 15 | 0 | iSeries: Total Time (Database Monitor) |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 46D |