SAP DB2DB02IXDYN table - Tx DB02: Dynamics of the size of indexes details in SAP

SAP DB2DB02IXDYN table summary

Object Name: DB2DB02IXDYN
Dictionary Type: Transparent table
Description: Tx DB02: Dynamics of the size of indexes

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

Details

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

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

DB2DB02IXDYN-PART_EXTENSION table field - Extension or Partition (non-partitioned TS) number ▼

Description: Extension or Partition (non-partitioned TS) number
Field Name: PART_EXTENSION
Data Element: DB2PARTEXT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PART_EXTENSION

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

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

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

DB2DB02IXDYN-EXTENTS table field - Number of extents ▼

Description: Number of extents
Field Name: EXTENTS
Data Element: DB2NUMEXTI
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXTENTS

DB2DB02IXDYN-EXTENTS_LAST table field - Tx DB02: Absolute difference in comparison to previous run ▼

Description: Tx DB02: Absolute difference in comparison to previous run
Field Name: EXTENTS_LAST
Data Element: DB2CHGTBSL
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 EXTENTS_LAST

DB2DB02IXDYN-EXTENTS_PERC table field - Tx DB02: Difference (percent) in comparison to previous run ▼

Description: Tx DB02: Difference (percent) in comparison to previous run
Field Name: EXTENTS_PERC
Data Element: DB2CHGTBSP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXTENTS_PERC

DB2DB02IXDYN-EXTENTS_FIRST table field - Tx DB02: Absolute difference in comparison to first run ▼

Description: Tx DB02: Absolute difference in comparison to first run
Field Name: EXTENTS_FIRST
Data Element: DB2CHGTBSF
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 EXTENTS_FIRST

DB2DB02IXDYN-D_EXTENTS table field - Number of extents: change per day ▼

Description: Number of extents: change per day
Field Name: D_EXTENTS
Data Element: DB2CHGEXDI
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field D_EXTENTS

DB2DB02IXDYN-W_EXTENTS table field - Number of extents: change per week ▼

Description: Number of extents: change per week
Field Name: W_EXTENTS
Data Element: DB2CHGEXWI
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field W_EXTENTS

DB2DB02IXDYN-M_EXTENTS table field - Number of extents: change per month ▼

Description: Number of extents: change per month
Field Name: M_EXTENTS
Data Element: DB2CHGEXMI
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field M_EXTENTS

DB2DB02IXDYN-ALLOCSIZE table field - Total size of an index (allocated storage in KB) ▼

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

DB2DB02IXDYN-ALLOCSIZ_LAST table field - Tx DB02: Absolute difference in comparison to previous run ▼

Description: Tx DB02: Absolute difference in comparison to previous run
Field Name: ALLOCSIZ_LAST
Data Element: DB2CHGTBSL
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 ALLOCSIZ_LAST

DB2DB02IXDYN-ALLOCSIZ_PERC table field - Tx DB02: Difference (percent) in comparison to previous run ▼

Description: Tx DB02: Difference (percent) in comparison to previous run
Field Name: ALLOCSIZ_PERC
Data Element: DB2CHGTBSP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ALLOCSIZ_PERC

DB2DB02IXDYN-ALLOCSIZ_FIRST table field - Tx DB02: Absolute difference in comparison to first run ▼

Description: Tx DB02: Absolute difference in comparison to first run
Field Name: ALLOCSIZ_FIRST
Data Element: DB2CHGTBSF
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 ALLOCSIZ_FIRST

DB2DB02IXDYN-D_ALLOCSIZ table field - Allocated storage in KB: change per day ▼

Description: Allocated storage in KB: change per day
Field Name: D_ALLOCSIZ
Data Element: DB2CHGSIZD
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 D_ALLOCSIZ

DB2DB02IXDYN-W_ALLOCSIZ table field - Allocated storage in KB: change per week ▼

Description: Allocated storage in KB: change per week
Field Name: W_ALLOCSIZ
Data Element: DB2CHGSIZW
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 W_ALLOCSIZ

DB2DB02IXDYN-M_ALLOCSIZ table field - Allocated storage in KB: change per month ▼

Description: Allocated storage in KB: change per month
Field Name: M_ALLOCSIZ
Data Element: DB2CHGSIZM
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 M_ALLOCSIZ

DB2DB02IXDYN-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: 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 FREESIZE

DB2DB02IXDYN-FREESIZE_LAST table field - Tx DB02: Absolute difference in comparison to previous run ▼

Description: Tx DB02: Absolute difference in comparison to previous run
Field Name: FREESIZE_LAST
Data Element: DB2CHGTBSL
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 FREESIZE_LAST

DB2DB02IXDYN-FREESIZE_PERC table field - Tx DB02: Difference (percent) in comparison to previous run ▼

Description: Tx DB02: Difference (percent) in comparison to previous run
Field Name: FREESIZE_PERC
Data Element: DB2CHGTBSP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FREESIZE_PERC

DB2DB02IXDYN-FREESIZE_FIRST table field - Tx DB02: Absolute difference in comparison to first run ▼

Description: Tx DB02: Absolute difference in comparison to first run
Field Name: FREESIZE_FIRST
Data Element: DB2CHGTBSF
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 FREESIZE_FIRST

DB2DB02IXDYN-D_FREESIZ table field - Free storage (allocated minus used) in KB: change per day ▼

Description: Free storage (allocated minus used) in KB: change per day
Field Name: D_FREESIZ
Data Element: DB2CHGFRED
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 D_FREESIZ

DB2DB02IXDYN-W_FREESIZ table field - Free storage (allocated minus used) in KB: change per week ▼

Description: Free storage (allocated minus used) in KB: change per week
Field Name: W_FREESIZ
Data Element: DB2CHGFREW
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 W_FREESIZ

DB2DB02IXDYN-M_FREESIZ table field - Free storage (allocated minus used) in KB: change per month ▼

Description: Free storage (allocated minus used) in KB: change per month
Field Name: M_FREESIZ
Data Element: DB2CHGFREM
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 M_FREESIZ

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

DB2DB02IXDYN-TOTALENTRIES_LAS table field - Tx DB02: Absolute difference in comparison to previous run ▼

Description: Tx DB02: Absolute difference in comparison to previous run
Field Name: TOTALENTRIES_LAS
Data Element: DB2CHGTBSL
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 TOTALENTRIES_LAS

DB2DB02IXDYN-TOTALENTRIES_PER table field - Tx DB02: Difference (percent) in comparison to previous run ▼

Description: Tx DB02: Difference (percent) in comparison to previous run
Field Name: TOTALENTRIES_PER
Data Element: DB2CHGTBSP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTALENTRIES_PER

DB2DB02IXDYN-TOTALENTRIES_FIR table field - Tx DB02: Absolute difference in comparison to first run ▼

Description: Tx DB02: Absolute difference in comparison to first run
Field Name: TOTALENTRIES_FIR
Data Element: DB2CHGTBSF
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 TOTALENTRIES_FIR

DB2DB02IXDYN-D_TOTALENTRIES table field - Number of Rows: changes per day ▼

Description: Number of Rows: changes per day
Field Name: D_TOTALENTRIES
Data Element: DB2CHGROWD
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 D_TOTALENTRIES

DB2DB02IXDYN-W_TOTALENTRIES table field - Number of Rows: changes per week ▼

Description: Number of Rows: changes per week
Field Name: W_TOTALENTRIES
Data Element: DB2CHGROWW
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 W_TOTALENTRIES

DB2DB02IXDYN-M_TOTALENTRIES table field - Number of Rows: changes per month ▼

Description: Number of Rows: changes per month
Field Name: M_TOTALENTRIES
Data Element: DB2CHGROWM
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 M_TOTALENTRIES

View list of all SAP tables(S4H/ECC)

Select data from SAP table