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

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. 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!






原文地址:https://www.cnblogs.com/iathena/p/0b13a1572abcda46f3d668ce50903149.html