RE: unix system date and informix

Posted in 1999

dianne.pendleton@autodesk.com — Thu, 15 Apr 1999 10:45:45 -0700 — source: Informix-list mailing list archive (1991-1998)

We were able to change the Unix dates without stopping the engine. HP-UX 10.20. ODS 7.23.UC1. Dianne -----Original Message----- From: Sujit.Pal@BankAmerica.com [mailto:Sujit.Pal@BankAmerica.com] Sent: Thursday, April 15, 1999 8:59 AM To: Rekaish Bhardwaj Cc: informix-list@iiug.org Subject: Re: unix system date and informix Rekaish One of us noticed the Y2K informix instance going into a long transaction when we changed the system date (year) from 1999 to 2000 for our Y2K machine. We are running Informix 7.30 on Solaris. Restarting Informix caused the transaction to go away and we haven't seen it since. We dont really know if the long transaction was caused by the change of date, but we could not find any other reason for it, although AFAIK, long transactions are not determined by how much time the system has been processing a transaction. Also I have changed the system date on machines running Informix 7.24 and HP-UX at a previous client, without restarting the instance but did not notice a long transaction. HTH Sujit Rekaish Bhardwaj <RekaishB@compans.com> on 04/15/99 03:37:23 AM To: "Informix News Group Type Thingy (E-mail)" <informix-list@iiug.org> cc: (bcc: Sujit Pal) Subject: unix system date and informix hello everyone. Quick Question Is it necessary to bring INFORMIX offline if I wish to change the unix system date and then bring it back online again ?? Regards Rekaish Bhardwaj Computer Answers International Limited 1st Floor, Sapphire West 550 Streetsbrook Road Solihull West Midlands B91 1QY United Kingdom Tel: +44 (0) 121 703 0416 Fax +44 (0) 121 703 0471 Mobile: +44 (0) 498 765424 Email: rekaishb@compans.com