SAP DB2CATINX table - Info on Indexes from DB2 Catalog Table SYSIBM.SYSINDEXES details in SAP

SAP DB2CATINX table summary

Object Name: DB2CATINX
Dictionary Type: Structure
Description: Info on Indexes from DB2 Catalog Table SYSIBM.SYSINDEXES

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

Details

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

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

DB2CATINX-TBNAME table field - DB2 table name ▼

Description: DB2 table name
Field Name: TBNAME
Data Element: DB2TABNAME
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

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

DB2CATINX-INDEXSPACE table field - DB2 indexspace name ▼

Description: DB2 indexspace name
Field Name: INDEXSPACE
Data Element: DB2ISNAME
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

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

DB2CATINX-NLEAF table field - Number of active leaf pages in the index ▼

Description: Number of active leaf pages in the index
Field Name: NLEAF
Data Element: DB2NLEAF
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NLEAF

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

View list of all SAP tables(S4H/ECC)

Select data from SAP table