MSGPATH_Server Message File: How to Recycle

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

Assuming linux then just add the file to logrotate Cheers Paul

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 www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ 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.

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

Hi Paul, Thank you. This is HP-UX. Regards, Saradhi. ------------------------------ Saradhi Motamarri Researcher/ Independent Consultant Sydney (6143) 002-2130 ------------------------------

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

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

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