Skip to Content
Author's profile photo Former Member

SAP IQ: Truncate the Transaction Log

Introduction

The transaction log file of a SAP IQ database can grow to undesirable size.  It is recommended to truncate it frequently. 

Here is a simple method to truncate the transaction log file when no backup is need.  No downtime is necessary. Please note that there are other methods to backup and control grow of the transaction log file.

Limitation

This procedure has been tested on SAP IQ 15 and IQ 16 on Solaris10.

Procedures

  1. Log into the Solaris server as user with access to SAP IQ tools
  2. Verify that you are using the right dbbackup utility.

          which dbbackup

          /IQ/Server/IQ-16SP8/IQ-16_0/bin64/dbbackup

  1. Execute dbbackup with the –xo option (truncate transaction log)

dbbackup -c ‘eng=SAPIQSrvr;dbn=SAPIQDb;uid=myUser;pwd=myPassword’ -xo

SQL Anywhere Backup Utility Version 16.0.0.807

Transaction log truncation completed

Done!

This post was first published on my personal blog at SAP IQ: Truncate the Transaction Log | ARBIME

Assigned tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi

      It's a very good way to truncate it.

      Thanks

      Gi-Sung Jang