SAP DB2IXBACK table - List of indexes that need a backup details in SAP


SAP DB2IXBACK table summary

Object Name: DB2IXBACK
Dictionary Type: Transparent table
Description: List of indexes that need a backup


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

Details
DB2IXBACK-DATE_ANA table field - Date of the last check

Description: Date of the last check
Field Name: DATE_ANA
Data Element: DB2BCKDATE
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 DATE_ANA

DB2IXBACK-TIME_ANA table field - Time of the last check

Description: Time of the last check
Field Name: TIME_ANA
Data Element: DB2BCKTIME
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 TIME_ANA

DB2IXBACK-IXCREA table field - DB2 creator name

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

DB2IXBACK-IXNAM table field - Name of a DB2 for OS/390 index

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

DB2IXBACK-IXPART table field - Partition number

Description: Partition number
Field Name: IXPART
Data Element: DB2PARTNRS
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 IXPART

DB2IXBACK-CREATOR table field - DB2 creator name

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

DB2IXBACK-NAME table field - Index name

Description: Index name
Field Name: NAME
Data Element: DB2INXNAME
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 NAME

DB2IXBACK-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: DB2TBCREAT
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2TBCREAT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TBCREATOR

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

DB2IXBACK-UNIQUERULE table field - Whether the index is unique

Description: Whether the index is unique
Field Name: UNIQUERULE
Data Element: DB2UNIQUE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2UNIQUE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UNIQUERULE

DB2IXBACK-INDEXTYPE table field - Index type

Description: Index type
Field Name: INDEXTYPE
Data Element: DB2IXTYPE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2IXTYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDEXTYPE

DB2IXBACK-INDEXSPACE table field - Name of the indexspace that contains the index

Description: Name of the indexspace that contains the index
Field Name: INDEXSPACE
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 INDEXSPACE

DB2IXBACK-CLUSTERING table field - Whether CLUSTER was specified when the index was created

Description: Whether CLUSTER was specified when the index was created
Field Name: CLUSTERING
Data Element: DB2CLUSTER
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2YNFLAG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLUSTERING

DB2IXBACK-ERASERULE table field - Datasets are to be erased when dropped

Description: Datasets are to be erased when dropped
Field Name: ERASERULE
Data Element: DB2ERULE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2ERULE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ERASERULE

DB2IXBACK-CLOSERULE table field - Data sets for closure when limit of open data sets reached

Description: Data sets for closure when limit of open data sets reached
Field Name: CLOSERULE
Data Element: DB2CRULE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2CRULE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLOSERULE

DB2IXBACK-COLCOUNT table field - Number of columns in the table or view

Description: Number of columns in the table or view
Field Name: COLCOUNT
Data Element: DB2COLCNT
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 COLCOUNT

DB2IXBACK-DBID table field - DBID

Description: DBID
Field Name: DBID
Data Element: DB2DBID
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBID

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

DB2IXBACK-BPOOL table field - DB2/390: Buffer pool

Description: DB2/390: Buffer pool
Field Name: BPOOL
Data Element: DB2BUFPOOL
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2BUFPOOL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BPOOL

DB2IXBACK-PGSIZE table field - DB2 for OS/390 page size in KBytes

Description: DB2 for OS/390 page size in KBytes
Field Name: PGSIZE
Data Element: DB2PGSIZE
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2PGSIZE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PGSIZE

DB2IXBACK-DSETPASS table field - The password for the datasets of the tablespace

Description: The password for the datasets of the tablespace
Field Name: DSETPASS
Data Element: DB2DPASS
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2DPASS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSETPASS

DB2IXBACK-PIECEIZE table field - Maximum size of a data set storage piece in KBytes

Description: Maximum size of a data set storage piece in KBytes
Field Name: PIECEIZE
Data Element: DB2PIECEI4
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PIECEIZE

DB2IXBACK-COPY table field - Index can be copied

Description: Index can be copied
Field Name: COPY
Data Element: DB2COPY
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COPY

DB2IXBACK-PARTITIONS table field - Number of partitions of the tablespace or indexspace

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

See all SAP tables containing field PARTITIONS

DB2IXBACK-PARTNR table field - Partition number

Description: Partition number
Field Name: PARTNR
Data Element: DB2PARTNRS
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 PARTNR

DB2IXBACK-OPERATION table field - Date and time of last RUNSTATS

Description: Date and time of last RUNSTATS
Field Name: OPERATION
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 OPERATION

DB2IXBACK-NDAYS table field - Number of days since last invocation

Description: Number of days since last invocation
Field Name: NDAYS
Data Element: DB2DAYS
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB2DAYS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NDAYS

DB2IXBACK-LEAFDIST table field - 100 * avg number of leaf pages between successive leaf pages

Description: 100 * avg number of leaf pages between successive leaf pages
Field Name: LEAFDIST
Data Element: DB2LEAFDIS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LEAFDIST

DB2IXBACK-EXTENTS table field - Number of extents of a tablespace

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

See all SAP tables containing field EXTENTS

DB2IXBACK-REASON table field - Reason running utility is recommended

Description: Reason running utility is recommended
Field Name: REASON
Data Element: DB2REASON
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: DB2REASON
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REASON


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table