SAP ABAP Data Element DB2TBSIZE (Size of the table in KB)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-DB-DB2 (Application Component) DB2 for z/OS
     STU2 (Package) CCMS for DB2 for OS/390
Basic Data
Data Element DB2TBSIZE
Short Description Size of the table in KB  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type DEC13    
Data Type DEC   Counter or amount field with comma and sign 
Length 13    
Decimal Places 0    
Output Length 17    
Value Table      
Further Characteristics
Search Help: Name    
Search Help: Parameters    
Parameter ID   
Default Component name    
Change document    
No Input History    
Basic direction is set to LTR    
No BIDI Filtering    
Field Label
  Length  Field Label  
Short 10 Size (KB) 
Medium 15 Size (KB) 
Long 22 Size of the table (KB) 
Heading Size (KB) 
Documentation

Definition

The size of the table is calculated by npages * pgsize, where:

  • npages = number of pages on which rows of the table appear,
  • pgsize = size of pages in the tablespace in kilobytes.

Since R/3 tables are created either in segmented or in partitioned tablespaces, this approximation provides a sufficient accuracy.

The size is set to -1 if statistics have not been gathered or if the object is a view, an alias or a temporary table.

History
Last changed by/on SAP  20130604 
SAP Release Created in 700