SAP iq:relocate the Message Trace File to a Different? Location

SAP iq:relocate the Message Trace File to a Different locationjuly 11, 2014

When a new SAP IQ database was created we can use the message PATH clause to specify the path where the MESSAGE trace file would be stored; If you omit the message PATH clause, the message trace file was 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's a simple procedure to reallocate the message trace file.

2. Identify The actual location

   Select file_name from sysfile
   where dbspace_name = ' iq_system_msg '
   

   file_name
   —————————-
   devdwiqdb.iqmsg
   

4. Alter the iq_system_msg dbspace

   ALTER DBSPACE iq_system_msg RENAME '/log_vol/dev/devdwiqdb.iqmsg'
   

5. Verify the new location

   Select file_name from sysfile
   where dbspace_name = ' iq_system_msg '
   

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

7. Restart SAP IQ

done!

Source: https://arbime.wordpress.com/2014/07/11/sap-iq-relocate-the-message-trace-file-to-a-different-location/

From for notes (Wiz)

SAP iq:relocate the Message Trace File to a Different? Location