Log file archive directory (-lgArchiveDir)

Use Log file archive directory (-lgArchiveDir) to specify a directory for the archived log file.

Operating system and syntax	UNIX / Windows	-lgArchiveDir dir-spec
Use with	Maximum value	Minimum value	Default
Database Server	255 chars	—	—

dir-spec

A fully-qualified directory specification, indicating where archived log files are stored. The maximum size of dir-spec is 255 characters.

Log files are archived when two conditions are satisfied: log file archiving is enabled (-lgArchiveEnable) and either a size limit (-lgTruncateSize) or elapsed time (-lgTruncateTime and -lgTruncateFrequency) threshold is met.

If archiving is enabled and a directory is not specified, the archived log file is stored in the directory where the database .db file is located.

The archive directory must exist and be writable prior to creating the log file archive, however its existence is not checked at startup. If the directory does not exist, the archive file is written to the database directory, similar to not specifying this parameter at all.

If there are any failures associated with writing the archive, such as access security or insufficient space, the archive fails. If archiving the log file fails, an error message is written to the log file, and the log file is NOT truncated.

Notes

The value for the -lgArchiveDir can be changed while your database is online with PROMON or the _DbParams VST.

You can archive log files from multiple databases to the same archive directory.

Archive files use the following naming convention: dbname.lg.date-time.n

In this filename:

dbname — The name of the database.

date-time — The date and time when the archive file is created, using the format YYYY-MM-DD.HH-MM.

n — An identifier, only incremented when the combination of dbname and date-time does not create a unique file name.