SAP ABAP Table DB4SRT0100 (iSeries Database Performance: Sorts)
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 DB4SRT0100   Table Relationship Diagram
Short Description iSeries Database Performance: Sorts    
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 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 QQPLIB QQPLIB QQC10 CHAR 10   0   iSeries: Package/Program Library (Database Monitor)  
5 QQPNAM QQPNAM QQC10 CHAR 10   0   iSeries: Package/Program Name (Database Monitor)  
6 QQSNAM QQSNAM QQC18 CHAR 18   0   iSeries: Statement Name (Database Monitor)  
7 QQCNT QQCNT QQDEC150 DEC 15   0   iSeries: No. of Executions of a Statement (Database Monitor)  
8 QQCSO QQCSO QQDEC150 DEC 15   0   iSeries: No. of Sorts (Database Monitor)  
9 QQTTIM QQTTIM_SRT QQDEC150 DEC 15   0   iSeries: Sort Time (Database Monitor)  
10 QQRSS QQRSS QQROWS INT4 10   0   iSeries: No. of Rows Selected or Sorted (Database Monitor)  
11 QQAVGT QQAVGT QQDEC150 DEC 15   0   iSeries: Average Time (Database Monitor)  
12 TOTTIME TOTTIME QQDEC150 DEC 15   0   iSeries: Total Time (Database Monitor)  
13 QQMINT QQMINT QQDEC150 DEC 15   0   iSeries: Minimum Time (Database Monitor)  
14 QQMAXT QQMAXT QQDEC150 DEC 15   0   iSeries: Maximum Time (Database Monitor)  
15 QQMETU QQMETU QQTIME CHAR 26   0   iSeries: Timest. of Most Expensive Stmt. (Database Monitor)  
16 QQSSIZ QQSSIZ QQDEC150 DEC 15   0   iSeries: Sort Size (Database Monitor)  
17 QQPSIZ QQPSIZ QQDEC150 DEC 15   0   iSeries: Pool Size (Database Monitor)  
18 QQPID QQPID QQDEC150 DEC 15   0   iSeries: Pool ID (Database Monitor)  
19 QQRCOD QQRCODSRT QQRCOD CHAR 2   0   iSeries: Reason Code (Database Monitor)  
20 QQSTTX_LEN INT2 INT2 INT2 5   0   2 byte integer (signed)  
21 QQSTTX QQSTTX QQLCHR LCHR 8000   0   iSeries: Statement Text (Database Monitor)  
22 QQUSER QQUSER QQUSER CHAR 10   0   iSeries: Job User (Database Monitor)  
History
Last changed by/on SAP  20130604 
SAP Release Created in