Dropping logical logs
Drop a logical log and increase the amount of disk space available within a dbspace.
Important: You cannot drop a log file that is
currently in use or contains the last checkpoint record.
The status of the log file determines when the database server
frees the disk space:
- If you drop a log file that has never been written to, the database server deletes the log and frees the space immediately.
- If you drop a log file that has been used, the database server marks it as deleted. After you take a full backup of the dbspaces that contain the log file and the root dbspace, the database server deletes the log file and frees the space.
To drop a logical log:
- On the OAT menu, click .
- Click the Admin tab.
- In the Drop Logical Log section, select the log from the list of logical log numbers.
- Click Drop.