Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    Arvada, Colorado
    Posts
    14

    Unhappy Unanswered: How to Move Log File...

    I'm a DBA in Oracle, SqlServer, etc, but have an Informix database I'm trying to manage.

    How do I move the bar_act.log file to a new volume? This contains the information from the onbar commands, but not sure if I can move it easily.

    Thank you,
    Last edited by kjtjarks; 05-11-04 at 13:10.

  2. #2
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177
    Not quite sure what you meant, so I'll give you two difference answers.

    If you are talking about creating a new, empty file, just delete (or rename) and then create (ie touch) a new file with write permissions to Informix and root.

    If you are talking about changing it's location (ie. directory) that's a function of the onconfig variable BAR_ACT_LOG. I'm not sure when this parameter is read (ie once at startup or whenever needed) so you may need to bounce Informix to get the new path to take effect.
    Fred Prose

  3. #3
    Join Date
    Feb 2004
    Posts
    32

    Log file

    To change the location of the log file ,change the location in the
    $INFORMIXDIR/etc/$ONCONFIG : BAR_ACT_LOG parameter. You don't have to bounce the server, this takes effect when the Onbar command is executed.
    -Abraham

  4. #4
    Join Date
    Mar 2004
    Location
    Arvada, Colorado
    Posts
    14

    Thank you!!

    I was looking for the onconfig answer, so thank you to you both. This is exactly what this poor Oracle DBA needs...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •