SAP ABAP Data Element QIFNM (iSeries: System Name of Index (Database Monitor))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
     ⤷ STU4 (Package) CCMS / AS/400

Basic Data

Data Element	QIFNM
Short Description	iSeries: System Name of Index (Database Monitor)

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	DBINDEX
Data Type	CHAR	Character String
Length	18
Decimal Places	0
Output Length	18
Value Table

Further Characteristics

Search Help: Name
Search Help: Parameters
Parameter ID
Default Component name
Change document	☐
No Input History	☐
Basic direction is set to LTR	☐
No BIDI Filtering	☐

Field Label

	Length	Field Label
Short	10	Index
Medium	20	Index
Long	40	Index
Heading	50	Index

Documentation

Definition

QIFNM is the SQL name of the index used to implement a statement at the time of the most expensive execution of the statement.
iSeries: A file is uniquely identified by library name/file name.)

QIFNM is only available in the detail information tables SQ3001_DB4 and SQ3002_DB4.

Note

In SQ3001_DB4: QIFNM = *TEMP indicates that an existing temporary index was used to implement the statement.

In SQ3002_DB4: QIFNM <> '' indicates that a temporary index was built from a keyed file (SQL index) of the physical file (QQPTLN/QPTFN) accessed in the statement.

History

Last changed by/on	SAP	20070813
SAP Release Created in