What is NOFUZZYCKPT environment variable.

Problem

How to disable Fuzzy Checkpoints.

Solution

What is NOFUZZYCKPT?

The environment variable NOFUZZYCKPT disables Fuzzy Checkpoints, the default checkpoint behavior. With Fuzzy Checkpoints disabled, full checkpoints will be performed.

Tip: Fuzzy Checkpoints are a database server feature introduced in 9.2 IBM Informix® Dynamic Server™. See the Related information section for an article about Fuzzy Checkpoints.

Where to set it

Set NOFUZZYCKPT in your environment.

Note: Stop and restart the database server for NOFUZZYCKPT to take effect.

What to set it to

This environment variable can be set to this value.

Value of NOFUZZYCKPT	Effect
1	Disables Fuzzy Checkpoints

What uses NOFUZZYCKPT?

The database server.