Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  LOG FILES

    Posted Tue July 22, 2025 01:46 PM

    Hello everyone.
    Previously, I checked that in some cases the log files were filling up, and this was causing errors at some point.
    So we decided to increase the number of log files as well as their size.
    Today we had a problem because they filled up, and the log manager remained in CKPT REQ, so we immediately backed them up.
    With ontape -a and automatically, the log manager was released.
    My question is how do we get the log manager to automatically back them up or discard them for recycling so this doesn't happen?

    Regards.



    ------------------------------
    Eduardo Rodriguez
    ------------------------------


  • 2.  RE: LOG FILES

    Posted Tue July 22, 2025 02:58 PM

    Eduardo:

    In your ONCONFIG file the ALARMPROGRAM parameter should be set to alarmprogram.sh.

    If you edit whichever file is set there, there will be a line:

    BACKUPLOGS=N

    Just change the "N" to "Y". If you are using ontape -s to make archives, then you also need to change this line:

    BACKUP_CMD="onbar -b -l"

    to

    BACKUP_CMD="ontape -a"

    But if you are using "onbar -b ..." to archive the server then it should be set to "onbar -b -l" as above.

    Once you make these changes and save the file, whenever a logical log file completes it will automatically be backed up by the ALARMPROGRAM script and you will see lines like these in your message log (onstat -m):

     
    07/22/2025 13:33:33   Logical Log 3626 Complete, timestamp: 0x11c1ff62e.
    07/22/2025 13:33:34   Logical Log 3626 - Backup Started
    07/22/2025 13:33:35   Logical Log 3626 - Backup Completed

    Although your timestamps may look different depending on what version of Informix you are running and what you have the MSG_DATE parameter set to in later releases.

    Art



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



  • 3.  RE: LOG FILES

    Posted Thu July 24, 2025 12:30 PM

    Hi Eduardo,

    I assue that you are using the late versions of the Informix engine (but this applies most versions).

    You should make sure that some of the parameters of the ALARMPROGRAM have been positioned correctly to alarmprogram.sh

    BACKUPLOGS should be Y (for yes that you want to backup the logical logs)

    BACKUP_CMD should either "ontape -a -d" if you azre using ontape to perform backups or "onbar -b -l" if you are using the onbar tool to perform backups.


    Old versions of Informix used to use the log_full.sh script. Both the alarmprogram.sh and log_full.sh scripts are located in $INFORMIXDIR/etc on UNIX/Linux or %INFORMIXDIR%\etc\ on the windows plateforms.

    Cordialement, Regards,    Khaled Bentebal Directeur Général - ConsultiX Tél: 33 (0) 1 39 12 18 00 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web:  www.consult-ix.fr
    Le 22/07/2025 à 19:46, Eduardo Rodriguez via IBM TechXchange Community a écrit :
    01000198333e3695-43c787d0-3687-486e-b35d-1c6c0c46ef5b-000000@email.amazonses.com">
    Hello everyone. Previously, I checked that in some cases the log files were filling up, and this was causing errors at some point. So we decided... -posted to the "Informix" group





Related Content