Connect with Db2, Informix, and other data experts to gain value from your data, share insights, and solve problems.
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.
Assuming linux then just add the file to logrotate
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 :(
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.