SAP ABAP Table DB4_VIEW_SQLPLC_DMP (DB4: View data for SQL Plan Cache Records)

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	DB4_VIEW_SQLPLC_DMP	Table Relationship Diagram
Short Description	DB4: View data for SQL Plan Cache Records

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	HOST_ID	☐			INT4	10	0
2	IPL_NUMBER	☐			INT4	10	0
3	QQTIME	☐	QQTIME	QQTIME	CHAR	26	0	iSeries: Record Creation Timestamp (Database Monitor)
4	QQJOB	☐	QQJOB	QQJOB	CHAR	10	0	iSeries: Job Name (Database Monitor)
5	QQUSER	☐	QQUSER	QQUSER	CHAR	10	0	iSeries: Job User (Database Monitor)
6	QQJNUM	☐	QQJNUM	QQJNUM	CHAR	6	0	iSeries: Job Number (Database Monitor)
7	QQUCNT	☐			INT4	10	0
8	QQRDBN	☐	QQRDBN	QQRDBN	CHAR	18	0	Relational database name
9	QQSYS	☐	QQSYS	QQSYS	CHAR	8	0	System name
10	RECORD_KEY	☐			STRG	0	0
11	RECORDS_TAB	☐	DBAKEYVAL_TAB		TTYP	0	0
12	TAB_RID_01	☐			STRG	0	0
13	TAB_RID_02	☐			STRG	0	0
14	TAB_RID_03	☐			STRG	0	0
15	TAB_RID_04	☐			STRG	0	0
16	TAB_RID_05	☐			STRG	0	0
17	TAB_RID_06	☐			STRG	0	0
18	TAB_RID_07	☐			STRG	0	0
19	RID_01_DATA	☐	DATA		REF	0	0
20	RID_02_DATA	☐	DATA		REF	0	0
21	RID_03_DATA	☐	DATA		REF	0	0
22	RID_04_DATA	☐	DATA		REF	0	0
23	RID_05_DATA	☐	DATA		REF	0	0
24	RID_06_DATA	☐	DATA		REF	0	0
25	RID_07_DATA	☐	DATA		REF	0	0

History

Last changed by/on	SAP	20141013
SAP Release Created in	740