SAP ABAP Data Element CKPTINTVL (Database checkpoint interval (s))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-INF (Application Component) Informix
     ⤷ STUI (Package) Informix Database Monitor

Basic Data

Data Element	CKPTINTVL
Short Description	Database checkpoint interval (s)

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	SINT4_NOS
Data Type	INT4	4-byte integer, integer number with sign
Length	10
Decimal Places	0
Output Length	10
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	0
Medium	0
Long	0
Heading	0

Documentation

Definition

The database checkpoint interval specifies the maximum interval that can elapse before Online checks to determine if a checkpoint is needed. When a checkpoint occurs, pages in the shared-memory buffer pool are synchronized with the corresponding pages on disk.

If the checkpoint interval is too short, the system spends too much time performing checkpoints and the performance of other work suffers. If the checkpoint interval is set too long, fast recovery may be too slow.

This interval may be adjusted from within the ONCONFIG* file located in the $INFORMIXDIR/etc directory. The default value is 300 seconds.

History

Last changed by/on	SAP	20010130
SAP Release Created in