SAP ABAP Table DB4ST4RFC (iSeries: Performance Overview (RFC Destinations))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
     ⤷ STU4 (Package) CCMS / AS/400

Basic Data

Table Category	INTTAB	Structure
Structure	DB4ST4RFC	Table Relationship Diagram
Short Description	iSeries: Performance Overview (RFC Destinations)

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Internal Table for SAP Systems with DBA Scheduling
2	SYSID	☐	SDBA_SYSID	CHAR8	CHAR	8	0	Database System ID
3	DBSYS	☐	DBADBSYS	DBADBSYS	CHAR	10	0	Database System for DBA
4	SAPREL	☐	SYSAPRL	SYCHAR04	CHAR	4	0	Release of SAP System
5	DBREL	☐	SDBA_DBREL	SDBA_DBREL	CHAR	10	0	Database release
6	RFCDEST	☐	RFCDEST	RFCDEST	CHAR	32	0	Logical Destination (Specified in Function Call)	*
7	DBHOST	☐	SDBA_HOST	TEXT30	CHAR	30	0	Name of the server where the DBA action is to be executed
8	DBCNAME	☐	DBCON_NAME	DBCON_NAME	CHAR	30	0	Logical name for a database connection	*
9	.INCLUDE	☐				0	0	iSeries: History Table for Database Performance Overview
10	QQDMPTIME	☐	QQDMPTIME	QQTIME	CHAR	26	0	iSeries: Timestamp of Database Monitor Dump
11	QQSUMCNT	☐	QQSUMCNT	QQDEC150	DEC	15	0	iSeries: Number of Executed SQL Statements
12	QQCOMCNT	☐	QQCOMCNT	QQDEC150	DEC	15	0	iSeries: No. of Executed COMMITs (Database Monitor)
13	QQRBKCNT	☐	QQRBKCNT	QQDEC150	DEC	15	0	iSeries: Number of Executed ROLLBACKs (Database Monitor)
14	QQSELCNT	☐	QQSELCNT	QQDEC150	DEC	15	0	iSeries: Number of Executed SELECTs (Database Monitor)
15	QQINSCNT	☐	QQINSCNT	QQDEC150	DEC	15	0	iSeries: Number of Executed INSERTs (Database Monitor)
16	QQUPDCNT	☐	QQUPDCNT	QQDEC150	DEC	15	0	iSeries: Number of Executed UPDATEs (Database Monitor)
17	QQDELCNT	☐	QQDELCNT	QQDEC150	DEC	15	0	iSeries: Number of Executed DELETEs (Database Monitor)
18	QQDDLCNT	☐	QQDDLCNT	QQDEC150	DEC	15	0	iSeries: Number of Executed DDL Statements
19	QQOTHCNT	☐	QQOTHCNT	QQDEC150	DEC	15	0	iSeries: Number of Miscellaneous Statements
20	QQTSCCNT	☐	QQTSCCNT	QQDEC150	DEC	15	0	iSeries: Number of Table Scans
21	QQTSCTOTR	☐	QQTSCTOTR	QQDEC150	DEC	15	0	iSeries: Total Rows Read by Table Scans
22	QQTSCTTIME	☐	QQTSCTTIME		DEC	31	6	iSeries: Total Time Used by Table Scans
23	QQSRTCNT	☐	QQSRTCNT	QQDEC150	DEC	15	0	iSeries: Number of Sorts (Database Monitor)
24	QQSRTTOTR	☐	QQSRTTOTR	QQDEC150	DEC	15	0	iSeries: Total Rows Sorted (Database Monitor)
25	QQSRTTTIME	☐	QQSRTTTIME		DEC	31	6	iSeries: Total Time Used by Sorts (Database Monitor)
26	QQIDCCNT	☐	QQIDCCNT	QQDEC150	DEC	15	0	iSeries: Number of Index Creates (Database Monitor)
27	QQIDCTTIME	☐	QQIDCTTIME		DEC	31	6	iSeries: Total Time Used by Index Creates (Database Monitor)
28	QQTMFCNT	☐	QQTMFCNT	QQDEC150	DEC	15	0	iSeries: Number of Temporary Files Created
29	QQTMFTTIME	☐	QQTMFTTIME		DEC	31	6	iSeries: Total Time Used by Temp. File Creates
30	QQIDACNT	☐	QQIDACNT	QQDEC150	DEC	15	0	iSeries: Index Advice (Database Monitor)
31	QQIDATBCNT	☐	QQIDATBCNT	QQDEC150	DEC	15	0	iSeries: Number of Tables over which Indexes are Advised
32	QQIDAQRYCT	☐	QQIDAQRYCT	QQDEC150	DEC	15	0	iSeries: Number of Index Advices (Database Monitor)
33	QQODFTIME	☐	QQODFTIME	QQTIME	CHAR	26	0	iSeries: Timestamp of Oldest Data (Database Monitor)
34	QQTOTAVGT	☐	QQTOTAVGT	QQDEC150	DEC	15	0	iSeries: Overall Average Execution Time (Database Monitor)
35	QQTOTTIME	☐	QQTDBTIME	QQDEC150	DEC	15	0	iSeries: Total Database Processing Time (Database Monitor)
36	PHYSREAD	☐	PHYSREAD	QQDEC150	DEC	15	0	iSeries: Number of Physical Reads
37	LOGICREAD	☐	LOGICREAD	QQDEC150	DEC	15	0	iSeries: Number of Logical Reads
38	QUALITY	☐	QUALITY	QQDEC152	DEC	15	2	iSeries: Hit Ratio
39	READPCALL	☐	READPCALL	QQDEC152	DEC	15	2	iSeries: Number of Logical Reads per User Call
40	TIMEPCALL	☐	TIMEPCALL	QQDEC152	DEC	15	2	iSeries: Database Processing Time per User Call

History

Last changed by/on	SAP	20130604
SAP Release Created in	610