Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Administrator's GuideThe HCL OneDB™ Administrator's Guide provides the information required to administer HCL OneDB™.
Logging and log administration
Manage logical-log files
Free a logical-log file
Delete a log file with status D

Delete a log file with status D

When you drop a used log file, it is marked as deleted (status D) and cannot be used again, and onparams prints this message:

Log file log_file_number has been pre-dropped. It will be 
deleted from the log list and its space can be reused 
once you take level 0 archives of all BLOBspaces, 
Smart BLOBspaces and non-temporary DBspaces.

The level 0 archive is necessary to make sure that the log file itself and all of the associated information in the different dbspaces has been archived. The log file is deleted at the end of the level 0 archive; however, because the removal of the log file is itself a change in the root reserved pages structure on the disk, the next archive to be taken also must be a level 0 archive. The level 0 archive must occur before a level 1 or level 2 archive can be performed.