Skip to content

SAP IQ: Relocate the Message Trace File to a Different Location

July 11, 2014

When a new SAP IQ database is created we can use the MESSAGE PATH clause to specify the path where the message trace file will be stored; if you omit the MESSAGE PATH clause, the message trace file is created in the same directory of the .db file.

Sometimes it is necessary to later relocate the message trace file to a different location.

Here is a simple procedure to reallocate the message trace file.

  1. Identify the actual location

    select file_name from sysfile
    where dbspace_name = ‘IQ_SYSTEM_MSG’

    file_name
    —————————-
    devDwIqDb.iqmsg

  2.  

  3. Alter the IQ_SYSTEM_MSG dbspace

    ALTER DBSPACE IQ_SYSTEM_MSG RENAME ‘/log_vol/dev/devDwIqDb.iqmsg’

  4.  

  5. Verify the new location

    select file_name from sysfile
    where dbspace_name = ‘IQ_SYSTEM_MSG’

    file_name
    —————————-
    /log_vol/dev/devDwIqDb.iqmsg

  6.  

  7. Restart SAP IQ

 

Done!

Advertisements

From → SAP IQ

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: