Skip to content

SAP IQ: Truncate the Transaction Log

July 18, 2014

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.
  3. Execute dbbackup with the –xo option (truncate transaction log)

Done!

Advertisements

From → SAP IQ, UNIX

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: