SAP ABAP Table DB4IDU0100 (iSeries Database Performance: Used Indexes (Main screen))
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 DB4IDU0100   Table Relationship Diagram
Short Description iSeries Database Performance: Used Indexes (Main screen)    
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 QQKEY QQKEY QQKEY CHAR 17   0   iSeries: Key Field (Database Monitor)  
2 QQILNM QQILNM QQTLN CHAR 10   0   iSeries: System Name of Index Library (Database Monitor)  
3 QQIFNM QIFNM DBINDEX CHAR 18   0   iSeries: System Name of Index (Database Monitor)  
4 QQPTLN QQPTLN QQTLN CHAR 10   0   iSeries: System Name of Base Library (Database Monitor)  
5 QQPTFN QPTFN AS4TAB CHAR 30   0   iSeries: System Name of Base Table (Database Monitor) *
6 QQLILN QQLILN   CHAR 128   0   iSeries: Index Library (Database Monitor)  
7 QQLIFN QQLIFN   CHAR 128   0   iSeries: Index Name (Database Monitor)  
8 QQLPTL QQLPTL   CHAR 128   0   iSeries: Base Library (Database Monitor)  
9 QQLPTF QQLPTF   CHAR 128   0   iSeries: Base Table (Database Monitor)  
10 QQCIU QQCIU QQDEC150 DEC 15   0   iSeries: Index Usage (Database Monitor)  
11 QQQRYCNT QQQRYCNT QQDEC150 DEC 15   0   iSeries: Number of Different Statements (Database Monitor)  
12 QQTOTR QTOTR QQDEC150 DEC 15   0   iSeries: Total Rows in Table (Database Monitor)  
13 QQRROW QQRROW QQDEC150 DEC 15   0   iSeries: Result Rows (Database Monitor)  
14 QQAVGT QQAVGT QQDEC150 DEC 15   0   iSeries: Average Time (Database Monitor)  
15 QQCST QQCST QQC11 CHAR 1   0   iSeries: Constraint Used (Y/N) (Database Monitor)  
16 TOTTIME TOTTIME QQDEC150 DEC 15   0   iSeries: Total Time (Database Monitor)  
17 QQUSER QQUSER QQUSER CHAR 10   0   iSeries: Job User (Database Monitor)  
History
Last changed by/on SAP  20070813 
SAP Release Created in