Show TOC

IQ_LOG_MAX_SIZE OptionLocate this document in the navigation structure

Sets the maximum size of the point-in-time recovery archive in megabytes.

Default
0
Scope

  • Option can be set at the database (PUBLIC) level only.

  • Requires the SET ANY SYSTEM OPTION system privilege to set this option.

Remarks
The point-in-time recovery archive increases in size with each update sequence. The default setting of 0 allows the archive to increase without limit. Setting IQ_LOG_MAX_SIZE to a specific value limits the size of the archive: 
SET OPTION PUBLIC.IQ_LOG_MAX_SIZE = '1000'    //sets the max size of the archive to 1000 MB
If the archive exceeds the size limit, the server creates a new archive in the point-in-time recovery archive directory. Size limits are expressed in megabytes.
Related Information