SAP DB2DB02TBSIZE table - Transaction DB02: List of tables and tablespace (Details) details in SAP


SAP DB2DB02TBSIZE table summary

Object Name: DB2DB02TBSIZE
Dictionary Type: Transparent table
Description: Transaction DB02: List of tables and tablespace (Details)


Field list for DB2DB02TBSIZE table on an S/4 SAP system

Details
DB2DB02TBSIZE-TBCREATOR table field - DB2 creator name

Description: DB2 creator name
Field Name: TBCREATOR
Data Element: DB2CREATOR
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR8
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TBCREATOR

DB2DB02TBSIZE-TBNAME table field - Name of the table on which the index is defined

Description: Name of the table on which the index is defined
Field Name: TBNAME
Data Element: DB2TBNAME
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: CHAR18
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TBNAME

DB2DB02TBSIZE-STORDATE table field - Date when the storage information has been collected

Description: Date when the storage information has been collected
Field Name: STORDATE
Data Element: DB2STODATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STORDATE

DB2DB02TBSIZE-STORTIME table field - Time when the storage information has been collected

Description: Time when the storage information has been collected
Field Name: STORTIME
Data Element: DB2STOTIME
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: TIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STORTIME

DB2DB02TBSIZE-TSNAME table field - Name of the tablespace

Description: Name of the tablespace
Field Name: TSNAME
Data Element: DB2TSNAME
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR8
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TSNAME

DB2DB02TBSIZE-DBNAME table field - Database name

Description: Database name
Field Name: DBNAME
Data Element: DB2DBNAME
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: D2DBNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

DB2DB02TBSIZE-PARTITIONS table field - Number of partitions of a tablespace or index

Description: Number of partitions of a tablespace or index
Field Name: PARTITIONS
Data Element: DB2NUMPART
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2SINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTITIONS

DB2DB02TBSIZE-TBSIZE table field - Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB

Description: Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB
Field Name: TBSIZE
Data Element: DB2RTSTBSIZE
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: FLTP
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TBSIZE

DB2DB02TBSIZE-SPACEF table field - Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table

Description: Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table
Field Name: SPACEF
Data Element: DB2TBSPACEF
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: FLTP
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SPACEF

DB2DB02TBSIZE-STATSTIME table field - Date and time of last RUNSTATS

Description: Date and time of last RUNSTATS
Field Name: STATSTIME
Data Element: DB2STATSTM
Data Type: CHAR
length (Dec): 26(0)
Check table:
Conversion Routine:
Domain Name: DB2TMSTMP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATSTIME

DB2DB02TBSIZE-TS_ALLOCSIZE table field - Total size of a tablespace (allocated storage in KB)

Description: Total size of a tablespace (allocated storage in KB)
Field Name: TS_ALLOCSIZE
Data Element: DB2TSSIZ
Data Type: DEC
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: DEC11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TS_ALLOCSIZE

DB2DB02TBSIZE-TS_FREESIZE table field - Free size of a tablespace in KB (allocated minus used stor.)

Description: Free size of a tablespace in KB (allocated minus used stor.)
Field Name: TS_FREESIZE
Data Element: DB2TSFREE
Data Type: DEC
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: DEC11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TS_FREESIZE

DB2DB02TBSIZE-PCTUSED table field - Percentage of used size to allocated size of a tablespace

Description: Percentage of used size to allocated size of a tablespace
Field Name: PCTUSED
Data Element: DB2TSPCTU
Data Type: DEC
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: DEC3
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCTUSED

DB2DB02TBSIZE-RTS_TOTALROWS table field - Real Time Statistics: Number of rows in Table

Description: Real Time Statistics: Number of rows in Table
Field Name: RTS_TOTALROWS
Data Element: DB2TBTOTALROWS
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: FLTP
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTS_TOTALROWS

DB2DB02TBSIZE-AVGROWLENGTH table field - Average row length of table

Description: Average row length of table
Field Name: AVGROWLENGTH
Data Element: DB2TBAVGROWLEN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVGROWLENGTH

DB2DB02TBSIZE-RTS_ST_CHANGES table field - RUN.:Changed rows (insert, delete or update) absolute number

Description: RUN.:Changed rows (insert, delete or update) absolute number
Field Name: RTS_ST_CHANGES
Data Element: DB2CCCHGA
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: FLTP
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTS_ST_CHANGES


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table