Long Checkpoints during an archive that occurs during blob ( text and byte ) processing

Technote (troubleshooting)


Problem(Abstract)


You see long checkpoints during an archive / backup that occurs during blobspace blob ( text and byte ) processing.
Checkpoint duration is longer during archives / backups that occurs during blobspace blob ( text and byte ) processing.

Cause

The archive process blocks blobspace alteration until a blobspace is backed up. Examples of blobspace alteration would be dropping a blob or inserting a blob. Checkpoint duration is drawn out longer because sessions trying to alter the blobspace are blocked until the blobspace is backed up.

Although blobspace blobs are not logged, the blob chunk free-list page is logged and this is why the blobspace must be locked during an archive.

Note: There could be other causes.


Diagnosing the problem

onstat -X will show a buffer with a pgflags of 80d. 80d refers to the blob chunk free-list page

Resolving the problem

Try to minimize the amount of planned blobspace blob activity occurring during an archive.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Servers

Software version:

7.3, 9.4, 10.0, 11.1, 11.5, 11.7, 11.70

Operating system(s):

AIX, HP-UX, Linux, Mac OS X, Solaris, Windows

Reference #:

1631859

Modified date:

2013-04-02

Translate my page

Machine Translation

Content navigation