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

Source: Internet
Author: User

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.

  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!


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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.