SAP ABAP Data Element QQAPRT (iSeries: Timestamp of Access Plan Rebuild (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	QQAPRT
Short Description	iSeries: Timestamp of Access Plan Rebuild (Database Monitor)

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	QQTIME
Data Type	CHAR	Character String
Length	26
Decimal Places	0
Output Length	26
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	11	Acc. Reb.
Medium	21	Acc. Reb. Timestamp
Long	41	Acc. Plan Rebuild Time
Heading	55	Acc. Plan Rebuild Time

Documentation

Definition

QQAPRT is the timestamp of the last time the access plan for a statement was rebuilt by the database optimizer.

Note

The current access plan of a statement is saved in the SQL package.
The database optimizer rebuilds an existing access plan if, for example:

• A previously used access path (index) was deleted
• A new index was created that improves the statement execution
• If the number of records in the table has changed too much since the last time the access plan was built
  The reason for the access plan rebuild is described in QQAPRT.

History

Last changed by/on	SAP	20070813
SAP Release Created in