Table/Structure Field list used by SAP ABAP Function Module DB4_ST04_OVERVIEW (AS/400: Get Database statistics for ST04 Main Screen)
SAP ABAP Function Module DB4_ST04_OVERVIEW (AS/400: Get Database statistics for ST04 Main Screen) is using
# Object Type Object Name Object Description Note
     
1 Table/Structure Field  DB4QQPAR - QRESET iSeries: Flag to indicate reset in ST04
2 Table/Structure Field  DB4QQPAR - QRESET iSeries: Flag to indicate reset in ST04 SOURCE VALUE(RESETFLAG) LIKE DB4QQPAR-QRESET DEFAULT SPACE
3 Table/Structure Field  DB4WAITSTS - WDB Cumulative number of process waits for database locks SOURCE VALUE(SUM_WAITS) LIKE DB4WTSTS_S-WDB
4 Table/Structure Field  DB4WAITSTS - WDBT Total cumulative time spent on DB lock waits (all processes)
5 Table/Structure Field  DB4WAITSTS - WDBT Total cumulative time spent on DB lock waits (all processes) SOURCE VALUE(SUM_WAIT_TIMES) LIKE DB4WTSTS_S-WDBT
6 Table/Structure Field  DB4WAITSTS - WDB Cumulative number of process waits for database locks
7 Table/Structure Field  DB4WTSTS_S - WDB Cumulative number of process waits for database locks
8 Table/Structure Field  DB4WTSTS_S - WDB Cumulative number of process waits for database locks SOURCE VALUE(SUM_WAITS) LIKE DB4WTSTS_S-WDB
9 Table/Structure Field  DB4WTSTS_S - WDBT Total cumulative time spent on DB lock waits (all processes)
10 Table/Structure Field  DB4WTSTS_S - WDBT Total cumulative time spent on DB lock waits (all processes) SOURCE VALUE(SUM_WAIT_TIMES) LIKE DB4WTSTS_S-WDBT
11 Table/Structure Field  DB6NAVSYST - DBHOST DBA Cockpit: Server Name SOURCE VALUE(DBHOST) TYPE DB6NAVSYST-DBHOST OPTIONAL
12 Table/Structure Field  DB6NAVSYST - SYSID Name of SAP System
13 Table/Structure Field  DB6NAVSYST - SYSID Name of SAP System SOURCE VALUE(SYSTEM_ID) TYPE DB6NAVSYST-SYSID OPTIONAL
14 Table/Structure Field  DB6NAVSYST - SCHEMANAME DB6: Schema Name
15 Table/Structure Field  DB6NAVSYST - SCHEMANAME DB6: Schema Name SOURCE VALUE(SCHEMANAME) TYPE DB6NAVSYST-SCHEMANAME OPTIONAL
16 Table/Structure Field  DB6NAVSYST - DBHOST DBA Cockpit: Server Name
17 Table/Structure Field  DB6NAVSYST - DBCNAME Logical name for a database connection
18 Table/Structure Field  SQ1000_DB4 - IPLTIME Text field length 14
19 Table/Structure Field  SQ1000_DB4 - SYSID Name of SAP System
20 Table/Structure Field  SQ1000_DB4 - QQTOTR iSeries: Total Rows in Table (Database Monitor)
21 Table/Structure Field  SQ1000_DB4 - QQSTOP iSeries: Statement Operation (Database Monitor)
22 Table/Structure Field  SQ1000_DB4 - QQSTF iSeries: Statement Function (Database Monitor)
23 Table/Structure Field  SQ1000_DB4 - QQCTS iSeries: Number of Table Scans (Database Monitor)
24 Table/Structure Field  SQ1000_DB4 - QQCTF iSeries: No. of Temporaray File Creates (Database Monitor)
25 Table/Structure Field  SQ1000_DB4 - QQCSO iSeries: No. of Sorts (Database Monitor)
26 Table/Structure Field  SQ1000_DB4 - QQCNT iSeries: No. of Executions of a Statement (Database Monitor)
27 Table/Structure Field  SQ1000_DB4 - QQCIC iSeries: Number of Index Creates (Database Monitor)
28 Table/Structure Field  SQ1000_DB4 - QQAVGT iSeries: Average Time (Database Monitor)
29 Table/Structure Field  SQ3000_DB4 - QQPTFN iSeries: System Name of Base Table (Database Monitor)
30 Table/Structure Field  SQ3000_DB4 - QQPTLN iSeries: System Name of Base Library (Database Monitor)
31 Table/Structure Field  SQ3002_DB4 - QQTTIM iSeries: Time for Index Create (Database Monitor)
32 Table/Structure Field  SQ3003_DB4 - QQRSS iSeries: Number of Rows Sorted (Database Monitor)
33 Table/Structure Field  SQ3004_DB4 - QQTTIM iSeries: Create Time of Temporary Table (Database Monitor)
34 Table/Structure Field  SQHIST_DB4 - LOGICREAD iSeries: Number of Logical Reads
35 Table/Structure Field  SQHIST_DB4 - TIMEPCALL iSeries: Database Processing Time per User Call
36 Table/Structure Field  SQHIST_DB4 - READPCALL iSeries: Number of Logical Reads per User Call
37 Table/Structure Field  SQHIST_DB4 - QUALITY iSeries: Hit Ratio
38 Table/Structure Field  SQHIST_DB4 - QQUPDCNT iSeries: Number of Executed UPDATEs (Database Monitor)
39 Table/Structure Field  SQHIST_DB4 - QQTSCTTIME iSeries: Total Time Used by Table Scans
40 Table/Structure Field  SQHIST_DB4 - QQTSCTOTR iSeries: Total Rows Read by Table Scans
41 Table/Structure Field  SQHIST_DB4 - QQTSCCNT iSeries: Number of Table Scans
42 Table/Structure Field  SQHIST_DB4 - QQTOTTIME iSeries: Total Database Processing Time (Database Monitor)
43 Table/Structure Field  SQHIST_DB4 - QQTMFTTIME iSeries: Total Time Used by Temp. File Creates
44 Table/Structure Field  SQHIST_DB4 - QQTMFCNT iSeries: Number of Temporary Files Created
45 Table/Structure Field  SQHIST_DB4 - QQSUMCNT iSeries: Number of Executed SQL Statements
46 Table/Structure Field  SQHIST_DB4 - QQSRTTTIME iSeries: Total Time Used by Sorts (Database Monitor)
47 Table/Structure Field  SQHIST_DB4 - QQSRTTOTR iSeries: Total Rows Sorted (Database Monitor)
48 Table/Structure Field  SQHIST_DB4 - QQSRTCNT iSeries: Number of Sorts (Database Monitor)
49 Table/Structure Field  SQHIST_DB4 - QQSELCNT iSeries: Number of Executed SELECTs (Database Monitor)
50 Table/Structure Field  SQHIST_DB4 - QQRBKCNT iSeries: Number of Executed ROLLBACKs (Database Monitor)
51 Table/Structure Field  SQHIST_DB4 - QQOTHCNT iSeries: Number of Miscellaneous Statements
52 Table/Structure Field  SQHIST_DB4 - QQINSCNT iSeries: Number of Executed INSERTs (Database Monitor)
53 Table/Structure Field  SQHIST_DB4 - QQIDCTTIME iSeries: Total Time Used by Index Creates (Database Monitor)
54 Table/Structure Field  SQHIST_DB4 - QQIDCCNT iSeries: Number of Index Creates (Database Monitor)
55 Table/Structure Field  SQHIST_DB4 - QQIDATBCNT iSeries: Number of Tables over which Indexes are Advised
56 Table/Structure Field  SQHIST_DB4 - QQIDACNT iSeries: Index Advice (Database Monitor)
57 Table/Structure Field  SQHIST_DB4 - QQDELCNT iSeries: Number of Executed DELETEs (Database Monitor)
58 Table/Structure Field  SQHIST_DB4 - QQDDLCNT iSeries: Number of Executed DDL Statements
59 Table/Structure Field  SQHIST_DB4 - QQCOMCNT iSeries: No. of Executed COMMITs (Database Monitor)
60 Table/Structure Field  SQHIST_DB4 - PHYSREAD iSeries: Number of Physical Reads
61 Table/Structure Field  SYST - DATUM ABAP System Field: Current Date of Application Server
62 Table/Structure Field  SYST - SYSID ABAP System Field: Name of SAP System
63 Table/Structure Field  SYST - UZEIT ABAP System Field: Current Time of Application Server