Informix

nested-group-icon.png

DB2

Expand all | Collapse all

Startup Sequence

  • 1.  Startup Sequence

    Posted Fri December 04, 2020 03:13 AM
    Hi

    What is the exact informix Startup sequence, faced a fast recovery for several minutes and didn't find any explanation in informix log

    Thanks

    ------------------------------
    John Smith
    ------------------------------


  • 2.  RE: Startup Sequence

    Posted Fri December 04, 2020 06:05 AM
    A long startup is almost always due to an abnormal shutdown. Was the machine shutdown? If so check that there is a proper shutdown script in /etc/rc or /etc/systemd (depending on what Unix flavor you run).

    You can verify this by looking at the message log. Is there a "stopped" message?

    11/27/2020 15:57:42   Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 5, Llog used 2

    11/27/2020 15:57:43   IBM Informix Dynamic Server Stopped.

    12:51:09  IBM Informix Dynamic Server Started.


    During startup were there any completed or rolled back transactions?

    11/29/2020 12:51:19   Logical Recovery has reached the transaction cleanup phase.
    11/29/2020 12:51:19   Logical Recovery Complete.
             0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

    After a normal shutdown all of these numbers should be zeros. If not, then the systems crashed, you don't have a good shutdown script, or someone performed a hard halt of the machine (shutdown -h now) instead of performing a normal shutdown.


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