Archive log consumption

During processing of the SYSPROC.SYSTS_UPDATE stored procedure, write operations on the event and log table for a full-text index consume log space.

Plan for the size of archive logs according to the following space considerations:

• When inserting, updating, and deleting documents from a table with an associated full-text index, a trigger inserts a row to the log table for the full-text index.
• In the SYSPROC.SYSTS_UPDATE stored procedure, there is one SQL insert operation for every document that is not parsed correctly by the text search engine.
• In the SYSPROC.SYSTS_UPDATE stored procedure, there is one delete operation for every row in the log table for the full-text index.
• In the SYSPROC.SYSTS_UPDATE stored procedure, there is an additional update operation for every row in the log table, if the update is an incremental update.