Informix

 View Only
  • 1.  Probably not the record but ....

    Posted Wed June 28, 2023 12:54 PM
    1779 days for uptime is not bad .....

    bash-4.2$ onstat -

    IBM Informix Extended Parallel Server Version 8.51.FC3???? -- On-Line -- Up 1779 days 06:38:21 -- 3936160 Kbytes



    --  Paul Watson Oninit www.oninit.com Tel: +1 913 364 0360 Cell: +1 913 387 7529  Oninit?? is a registered trademark of Oninit LLC  If you want to improve, be content to be thought foolish and stupid Failure is not as frightening as regret


  • 2.  RE: Probably not the record but ....

    Posted Thu June 29, 2023 04:22 AM

    Even this version's creator is impressed! ;-)



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



  • 3.  RE: Probably not the record but ....

    Posted Thu June 29, 2023 11:16 PM
    Impressive indeed!  
    Just curious, what:
    
    OS?  
    hardware?
    If Linux, kernel version?
    
    The longest uptime I ever saw on a box I logged into was 2487 days,
    Solaris 8 on a public shell server for an ISP.  They had ftp and 
    telnet open on it the whole time.  Hardware was being decomissioned, 
    else it would probably still be running.
    
    scot



  • 4.  RE: Probably not the record but ....

    Posted Fri June 30, 2023 09:34 AM
    this was AIX, not sure about the hardware

    On 6/29/2023 10:15 PM, Scot Jenkins via IBM TechXchange Community wrote:
    010001890a4cc60d-293542bf-655a-47e3-83d8-e0e9ddb6794a-000000@email.amazonses.com">
    Impressive indeed! Just curious, what: OS? hardware? If Linux, kernel version? The longest uptime I ever saw on a box I logged into was 2487... -posted to the "Informix" group
    IBM TechXchange Community

    Informix

    Post New Message
    Re: Probably not the record but ....
    Reply to Group Reply to Sender
    Scot Jenkins
    Jun 29, 2023 11:16 PM
    Scot Jenkins
    Impressive indeed! Just curious, what: OS? hardware? If Linux, kernel version? The longest uptime I ever saw on a box I logged into was 2487 days, Solaris 8 on a public shell server for an ISP. They had ftp and telnet open on it the whole time. Hardware was being decomissioned, else it would probably still be running. scot
      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  




     
    You are subscribed to "Informix" as paul@oninit.com. To change your subscriptions, go to My Subscriptions. To unsubscribe from this community discussion, go to Unsubscribe.



    Original Message:
    Sent: 6/29/2023 11:16:00 PM
    From: Scot Jenkins
    Subject: RE: Probably not the record but ....

    Impressive indeed!  
    Just curious, what:
    
    OS?  
    hardware?
    If Linux, kernel version?
    
    The longest uptime I ever saw on a box I logged into was 2487 days,
    Solaris 8 on a public shell server for an ISP.  They had ftp and 
    telnet open on it the whole time.  Hardware was being decomissioned, 
    else it would probably still be running.
    
    scot


  • 5.  RE: Probably not the record but ....

    Posted Fri June 30, 2023 10:00 AM
    Edited by Boycho Velkov Fri June 30, 2023 10:01 AM

    Hi,

    In one of our client's system - the UpTime was - 1547days: Ministry of Interior - Bulgaria "Border Control" - real 24x7 system.

    Informix 12.10.FC9 - Red Hat 7.3

    Till last week ...

    Down time after restarting:  - 4 min.

    Regards, and remember - INFORMIX is OnLine ;-)



    ------------------------------
    Boycho Velkov
    ------------------------------



  • 6.  RE: Probably not the record but ....

    Posted Fri June 30, 2023 10:34 AM

    One of our clients had a server that in November 2021 had been up for 3029 days - over 8 years!  I took a screen shot so I would have a record.  The Informix version is 7.31.UC5.  I'm not sure of the OS, but some of their old servers were on HPUX.  



    ------------------------------
    Barrie Shaw
    ------------------------------



  • 7.  RE: Probably not the record but ....

    Posted Fri June 30, 2023 11:13 AM

    I had one instance that ran for around 1,500 days, until we had to shut down for a planned power outage.  I took the opportunity to upgrade from 7.31 to 9.3, and then it ran another 1,100 or so until we decided to update to 9.4.  

    We had another that kept mysteriously going down.  It was a HP workstation style box, sitting on a desk in the server room of the other plant (ninety miles from my location at the time), with the disk array next to it.  Eventually, I discovered that someone had a habit of going behind the desk to get to his AS400, instead of around it.  He would frequently step on the cord for the drive array and replace it, thinking nothing of it.  The server crashed, and I would call over and have one of the network guys check it, see the console locked up and reboot it.  This went on every couple of months until I happened to be over at the other plant and saw what happened.

     

                                    --EEM

     






  • 8.  RE: Probably not the record but ....

    Posted Fri June 30, 2023 11:00 AM
    onstat -
     
    IBM Informix Dynamic Server Version 11.70.FC4GE -- On-Line (Prim) -- Up 179 days 00:43:26 -- 10589984 Kbytes
     
    [informix@ehive6 ~]$ uptime
     15:57:36 up 2454 days,  7:19,  1 user,  load average: 1.46, 1.52, 1.55


    ------------------------------
    Clive Eisen
    ------------------------------



  • 9.  RE: Probably not the record but ....

    Posted Fri June 30, 2023 12:28 PM
    Edited by Art Kagel Fri June 30, 2023 12:29 PM

    The longest Informix uptime that I am aware of is from a story that Lester Knutsen tells. He was called to a new client because one of the systems that they used to run their business had stopped working and someone remembered that it had something to do with an Informix database. He went on site and asked where the server was. No one knew, but they took him to their "computer room". None of the servers there were running Informix or even had it installed. Going to their network patch panel with their "network guy" they found a line that didn't see to go to any server in the room nor to the work areas of the company. Tracing the wires through the floor and ceiling they found that it went behind a wall. One of the older employees remembered that there was an old telephone equipment closet at that location that had been walled up 10 or 15 years before. Breaking into that wall they found the old closet and inside was an old Intel 386 machine that had crashed because it's power supply had failed. Someone went out and bought a new power supply and the machine was resurrected. When it booted up into SCO Unix an Informix engine booted with it. I don't remember if that was a v5.xx or early 7.xx release, but once it was back online and finished Fast Recovery, the application could connect and was back online.

    So, that would be between 3600 and 5400 days online before it crashed!



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