Hierarchy
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-INF (Application Component) Informix⤷
STUI (Package) Informix Database Monitor
Basic Data
| Data Element | CORR_2 |
| Short Description | Physical log sizing by checkpoint |
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
This correlation coefficient is given as a guide to the sizing the physical log. A value of 100 percent indicates that the physical log on disk is filling, by average, to full capacity before releasing its contents via the next checkpoint. To put it in other words, the physical log is causing the next checkpoint to be issued.
This value should never reach 100 percent if the physical log is sized properly. The proper sizing guldline can be found under the "physical log file size" help screen.
If you desire to decrease checkpoint frequency, you may want to increase the value of the PHYSFILE parameter located in the ONCONFIG* parameter file located in the $INFORMIXDIR/etc directory.
The "RESET"/"SINCE RESET" buttons can be used to monitor activity for any predetermined window of time.
History
| Last changed by/on | SAP | 20010130 |
| SAP Release Created in |
