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

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. Alter the IQ_SYSTEM_MSG dbspace

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

3. Verify the new location

select file_name from sysfile

where dbspace_name = ‘IQ_SYSTEM_MSG’

file_name

—————————-

/log_vol/dev/devDwIqDb.iqmsg

4. Restart SAP IQ

Done!

This post was first published on my personal blog at SAP IQ: Relocate the Message Trace File to a Different Location | ARBIME