SAP DB2DB02IX_SUM table - Tx DB02: Summary of Index info. Partitions are summed up details in SAP

SAP DB2DB02IX_SUM table summary

Object Name: DB2DB02IX_SUM
Dictionary Type: Transparent table
Description: Tx DB02: Summary of Index info. Partitions are summed up

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

Details

DB2DB02IX_SUM-IXCREATOR table field - DB2 creator name ▼

Description: DB2 creator name
Field Name: IXCREATOR
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 IXCREATOR

DB2DB02IX_SUM-IXNAME table field - Name of a DB2 for OS/390 index ▼

Description: Name of a DB2 for OS/390 index
Field Name: IXNAME
Data Element: DB2IDXNAME
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 IXNAME

DB2DB02IX_SUM-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

DB2DB02IX_SUM-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

DB2DB02IX_SUM-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

DB2DB02IX_SUM-IXSPACE table field - Name of the indexspace that contains the index ▼

Description: Name of the indexspace that contains the index
Field Name: IXSPACE
Data Element: DB2IXSPACE
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 IXSPACE

DB2DB02IX_SUM-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

DB2DB02IX_SUM-MAX_EXTENTS table field - Maximum number of extents of a partition of the TS or IX ▼

Description: Maximum number of extents of a partition of the TS or IX
Field Name: MAX_EXTENTS
Data Element: DB2MAXEXTS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAX_EXTENTS

DB2DB02IX_SUM-SUM_EXTENTS table field - Total number of extents of a TS or index (parts summed up) ▼

Description: Total number of extents of a TS or index (parts summed up)
Field Name: SUM_EXTENTS
Data Element: DB2SUMEXTS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SUM_EXTENTS

DB2DB02IX_SUM-SUM_DASD_USAGE table field - Actual DASD usage (in KB) of TS (sum of partitions) ▼

Description: Actual DASD usage (in KB) of TS (sum of partitions)
Field Name: SUM_DASD_USAGE
Data Element: DB2DASD_USE_SUM
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 SUM_DASD_USAGE

DB2DB02IX_SUM-SUM_ALLOCSIZE table field - Total size of an index (allocated storage in KB) ▼

Description: Total size of an index (allocated storage in KB)
Field Name: SUM_ALLOCSIZE
Data Element: DB2IXSIZ
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 SUM_ALLOCSIZE

DB2DB02IX_SUM-SUM_FREESIZE table field - Free size of an index in KB (allocated minus used storage) ▼

Description: Free size of an index in KB (allocated minus used storage)
Field Name: SUM_FREESIZE
Data Element: DB2IXFREE
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 SUM_FREESIZE

DB2DB02IX_SUM-PCTUSED table field - Percentage of used size to allocated size of an index ▼

Description: Percentage of used size to allocated size of an index
Field Name: PCTUSED
Data Element: DB2IXPCTUS
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

DB2DB02IX_SUM-RTS_LAST_REORG table field - Timestamp of last REORG ▼

Description: Timestamp of last REORG
Field Name: RTS_LAST_REORG
Data Element: DB2CCOTIME
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 RTS_LAST_REORG

DB2DB02IX_SUM-RTS_TOTALENTRIES table field - DB2/zOS: Real-Time Statistics index TOTALENTRIES ▼

Description: DB2/zOS: Real-Time Statistics index TOTALENTRIES
Field Name: RTS_TOTALENTRIES
Data Element: DB2RTSTOTALENTRY
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_TOTALENTRIES

DB2DB02IX_SUM-RTS_CHANGES table field - REO.:Changed rows (insert, delete or update) absolute number ▼

Description: REO.:Changed rows (insert, delete or update) absolute number
Field Name: RTS_CHANGES
Data Element: DB2CCRCHGA
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTS_CHANGES

DB2DB02IX_SUM-RTS_REORG_RECS table field - DB2/zOS: Number of REORG recommendations by DSNACCOR ▼

Description: DB2/zOS: Number of REORG recommendations by DSNACCOR
Field Name: RTS_REORG_RECS
Data Element: DB2CCREORGRECS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RTS_REORG_RECS

DB2DB02IX_SUM-TBCREATOR table field - Authorization ID of the owner of the table ▼

Description: Authorization ID of the owner of the table
Field Name: TBCREATOR
Data Element: DB2TBCREA
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

DB2DB02IX_SUM-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

DB2DB02IX_SUM-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

View list of all SAP tables(S4H/ECC)

Select data from SAP table