logging

This section describes using the plog, addlog and droplog functions of the space service to manage the physical and logical logs.

This section describes using the plog, addlog and droplog functions of the space service to manage the physical and logical logs.

These logging spaces are used as part of the Informix database recovery mechanisms.

naming conventions

If the storage space name contains plog infx designates the storage space as for the physical log only.

If the storage space name contains log infx designates the storage space as for trsansaction logs only.

Logging spaces are automatically ignored by full space alerts

physical log

The physical log is part of Informix’s recovery mechanism that records before images of modified database pages. As part of instance management you may need to move or re-size this log.

For example, create a new storage space called plog of 100mb.

infx space func=new space=plog size=100

Relocate the physical log to it.

infx space func=plog space=plog size=95

logical logs

The logical logs record transaction information for recovery purposes.

Create a new storage space for logical logs.

infx space func=new space=log size=100

Repeat this command to add logical logs.

infx space func=addlog space=log size=10

Each logical log is assigned a number when it is created. Specify this number to delete the logical log. You can only delete logs that are not in use and have been backed up.

Drop logical log number 1.

infx space func=droplog number=1