Informix

 View Only

  • 1.  DIfferent uptime from Informix and OS

    Posted Mon February 12, 2024 02:15 AM

    Hello,

    This is not an issue for me now, just a question if anybody has already seen that and what your experience is...

    I was playing a bit with the Informix server, and because I expected the Informix would have been destroyed, I created a VM snapshot. After some time I restored the VM snapshot and saw that Informix uptime is higher than the OS uptime.

    Informix is running, I can connect, I can read data, but may it cause any issues? Checkpoints? Warm restores?

    Restart of the database will solve the "issue", but in this situation... May it cause any harm to any database process?

    Thank you



    ------------------------------
    Ondrej
    ------------------------------


  • 2.  RE: DIfferent uptime from Informix and OS

    IBM Champion
    Posted Mon February 12, 2024 06:44 AM

    Ondrej:

    The difference in "uptime" should not make any difference or have any effect on the Informix instance. The reported uptime is for you. The engine does not care how long it has been online.

    Art



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------

    Original Message


  • 3.  RE: DIfferent uptime from Informix and OS

    IBM Champion
    Posted Mon February 12, 2024 07:08 AM

    What the engine remembers is its start time, and what onstat displays as "Up" time simply is the difference between that and current time.

    Not much indeed depends on that start time, so I'd agree with Art there probably won't be any problems arising from this calculation.

    Things might be slightly different wrt. the gap that will have occurred when waking a live engine from such artificial OS sleep - quite a few things do depend on time of day and e.g. distance to events of the past, but I think most of these would quickly adjust to the new time and forget or not even notice any gap. (It might be quite different if waking the system with the system clock turned back into the past.)

    BR,

     Andreas



    ------------------------------
    Andreas Legner
    ------------------------------

    Original Message


  • 4.  RE: DIfferent uptime from Informix and OS

    IBM Champion
    Posted Mon February 12, 2024 10:46 AM

    Hi Ondrej,

    The UPTIME at the informix instance level is the elapsed time from when you started your engine (instance). If you bring the engine down and restart, the UPTIME starts from 0 again. It is not based on the system time. As long as the instance is up, the UPTIME increases; the longer the better since the data caching in the bufferpool (instance memory) stays available for users and avoids going to disk to get them. So no issues from the usage (checkpoints, etc). The system time (that could be different from time zone to another and can be modified) impacts the date and time that you see in the messages in the "ONLINE.LOG", but that is only for information; the only thing is that you might be confused  when reading yourself the times of each logged message. No impact though on the way the instance functions.

    So the UPTIME at the instance level is only indicative, and each instance will have its own UPTIME.

    Cordialement, Regards,    Khaled Bentebal  Email: khaled.bentebal@consult-ix.fr Site Web:  www.consult-ix.fr
    Le 12/02/2024 à 08:15, Ondřej Žižka via IBM TechXchange Community a écrit :
    0100018d9c2b7af9-bb5d9b85-7dc1-415f-8285-95c1ae58bafd-000000@email.amazonses.com">
    Hello, This is not an issue for me now, just a question if anybody has already seen that and what your experience is... I was playing a bit... -posted to the "Informix" group



    Original Message


  • 5.  RE: DIfferent uptime from Informix and OS

    Posted Wed February 21, 2024 01:31 AM

    Thank you all for your answers.



    ------------------------------
    Ondřej
    ------------------------------

    Original Message