Monitoring the Data Area 

The data area is dimensioned when the database instance is created. A full data area can cause liveCache to hang.

Procedure

Monitor the data area. Use the following displays:

●     liveCache Assistant, Data Area

●     liveCache Alert Monitor, Data Area

Monitor the database logs. To do this, use the Current Messages display in the liveCache Assistant, for example.

Monitor the tasks. To do this, use the Task Manager display in the liveCache Assistant, for example.

Critical Situations

●     A red alert is generated in the liveCache Alert Monitor if the amount of free space in the data area falls below 10%.

●     Messages warning that the database is about to fill up are written in the log file knldiag even before the database is actually full (from a filling level of about 80%):
2005-08-14 09:26:04      0x7EC WRN 53025 DATA     PERM  USED 99(1 PAGES LEFT)

●     If the database is actually full, one task has the task state DB_FULL and the other tasks have the state vsuspend, until more space becomes available. The task states are logged in the file knldiag.

The filling level may reduce itself automatically if the garbage collectors delete history data (links to Undo Log Entries).

If the database is at risk of filling up, you must add a new data volume. To do this you should use the user menu Configure Data Area in the liveCache Assistant or the Database Manager (for example, Database Manager GUI, Create, Display and Delete Volumes, Switch Automatic Extension of the Data Area on/off).

Monitor the log area regularly. Proceed as described in Monitoring the Log Area.

See also:

Concepts of the Database System, History Management