Informix

 View Only

  • 1.  MSGPATH_Server Message File: How to Recycle

    Posted Fri February 14, 2020 10:46 AM

    Hi,
    Does IDS 11.10 or 11.50 provide any command to recycle the MSGPATH Server Message File?

    What I mean is this: As the Message File grows,
    Is there a way, to rename the existing file with some timestamp, and newer messages continue to be written?

    [I see a possibility to update MSGPATH parameter while the server is online, but need to provide a newer destination file name.]

    Regards, Saradhi.



    ------------------------------
    Saradhi Motamarri
    Researcher/ Independent Consultant
    Sydney
    (6143) 002-2130
    ------------------------------

    #Informix


  • 2.  RE: MSGPATH_Server Message File: How to Recycle

    IBM Champion
    Posted Fri February 14, 2020 10:49 AM

    Assuming linux then just add the file to logrotate

     

    Cheers

    Paul

     




    Original Message


  • 3.  RE: MSGPATH_Server Message File: How to Recycle

    Posted Fri February 14, 2020 03:46 PM
    Hi Paul,
    Thank you.
    This is HP-UX.
    Regards, Saradhi.

    ------------------------------
    Saradhi Motamarri
    Researcher/ Independent Consultant
    Sydney
    (6143) 002-2130
    ------------------------------

    Original Message


  • 4.  RE: MSGPATH_Server Message File: How to Recycle

    IBM Champion
    Posted Fri February 14, 2020 03:51 PM

    Log rotate exists in HP-UX.  Really depends if you want it to be a DBA or Sysadmin task

     




    Original Message


  • 5.  RE: MSGPATH_Server Message File: How to Recycle

    Posted Fri February 14, 2020 07:45 PM

    Hi Paul,
    Your point on logrotate opens an interesting question, how does the OS handle MSGPATH file when it is open by Informix engine?

    It makes me wonder when the Informix is ONLINE:
    if the message file is renamed,
    does the engine recreate a new message file as per the MSGPATH parameter?

    What I have seen is that it is possible to reset the MSGPATH parameter while Informix is ONLINE, but what happens this leads to multiple filenames for the message files :(



    ------------------------------
    Saradhi Motamarri
    Researcher/ Independent Consultant
    Sydney
    (6143) 002-2130
    ------------------------------

    Original Message


  • 6.  RE: MSGPATH_Server Message File: How to Recycle

    IBM Champion
    Posted Fri February 14, 2020 08:00 PM
    AFAIK the engine opens and closes the file each time but .....  I have never had an issue with logrotate

    Onstat -g iof should show the open files

    Cheers
    Paul

    Paul Watson
    Oninit LLC
    +1-913-387-7529
    www.oninit.com
    Oninit®️ is a registered trademark of Oninit LLC



    Original Message


  • 7.  RE: MSGPATH_Server Message File: How to Recycle
    Best Answer

    IBM Champion
    Posted Fri February 14, 2020 12:23 PM
    Saradhi:

    I don't remember if this task manager task arrived as early as 11.10 or 11.50 or was installed later. Look in sysadmin:ph_task for a task:

    select * from ph_task where tk_name = 'online_log_rotate';

    If it exists, enabling that task will rotate the message log on a schedule. The default is to run that task every 30 days, but you can modify the ph_task record to change that if you need/want to. The task is disabled by default.

    If it doesn't exist in your version of Informix you will have to write something yourself. FWIW, both 11.10 and 11.50 are out-of-support and you should upgrade to v12.10 or better v14.10FC3 or later which is now stable. Both are faster than 11.xx and have more features. In particular 14.10 Enterprise Edition includes the Storage Optimization feature (compression) which was an add on in v11.xx and v12.10!

    Art

    Art S. Kagel, President and Principal Consultant
    ASK Database Management


    Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference.  Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.






    Original Message


  • 8.  RE: MSGPATH_Server Message File: How to Recycle

    Posted Fri February 14, 2020 03:36 PM

    HI Art,
    Thank you so much for your insight.

    I will check.

    Re: Upgrade to newer version, that is actually correct, but I doubt the customer is willing to invest as they seem to migrate away from their applications on Informix :(

    Regards, Saradhi.



    ------------------------------
    Saradhi Motamarri
    Researcher/ Independent Consultant
    APuHC
    Sydney
    (6143) 002-2130
    ------------------------------

    Original Message