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
Expand all | Collapse all

Scheduled Automatic Backup - FAIL

  • 1.  Scheduled Automatic Backup - FAIL

    Posted 05/09/23 10:35 AM

    Hi.

    I'm getting a warning when trying to backup using Scheduled Backup.

    Here installation details:
    Linux RHEL 8.7
    Informix 14.10.FC10 (Also the same with 14.10.FC9)
    INFORMIXDIR /home/informix
    Backup directory /backup/data.
    Owner informix
    Permissions 770

    I used InformixHQ to create ontape backup level 0

    When I try to do the backup, I'm getting:

    Warning: could not access ONCONFIG /home/informix/etc//home/informix.
    WARNING: Cannot access configuration file /home/informix/etc//home/informix.

    running ontape -s -L 0 as informix, it work as always.

    I don't know which is the problem.

    Thank You



    ------------------------------
    Luis Panozzo
    ------------------------------


  • 2.  RE: Scheduled Automatic Backup - FAIL

    Posted 05/09/23 10:43 AM

    You posted this setting

    INFORMIXDIR /home/informix

    What is the ONCONFIG setting?
    (It would seem like you set ONCONFIG to /home/informix too, rather than to the name of your onconfig file.)

    The file ultimately being used will be:

    $INFORMIXDIR/etc/$ONCONFIG.

    HTH,
     Andreas



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



  • 3.  RE: Scheduled Automatic Backup - FAIL

    Posted 05/09/23 11:03 AM
    Hi Andreas.

    First it was without $ONCONFIG setting.

    Then I was thinking about this and set:
    export ONCONFIG=onconfig

    The same behavior.

    Thank you.

    --
    Luis Panozzo Saavedra
    Gerente Técnico
    luis_panozzo@sisa.com.bo
    Soluciones Integrales S.A.
    Av. Montenegro, bloque "B" #5 - Edif. SPICA - Piso 3 - San Miguel
    Teléfonos y Fax: +(591)(2) 2916983 / 2916984
    La Paz - Bolivia





  • 4.  RE: Scheduled Automatic Backup - FAIL

    Posted 05/09/23 11:07 AM

    So the Informix server software is installed under /home/informix?  Which I'd not consider ideal, esp. if this really is user informix' $HOME, but be it so.
    And this instance's configuration file is /home/informix/etc/onconfig?



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



  • 5.  RE: Scheduled Automatic Backup - FAIL

    Posted 05/09/23 11:13 AM
    Yes Andreas.

    The Informix server software is installed under /home/informix

    And this instance's configuration file is /home/informix/etc/onconfig


    --
    Luis Panozzo Saavedra
    Gerente Técnico
    luis_panozzo@sisa.com.bo
    Soluciones Integrales S.A.
    Av. Montenegro, bloque "B" #5 - Edif. SPICA - Piso 3 - San Miguel
    Teléfonos y Fax: +(591)(2) 2916983 / 2916984
    La Paz - Bolivia





  • 6.  RE: Scheduled Automatic Backup - FAIL

    Posted 05/09/23 11:52 AM

    I think I'm not quite getting what you're doing:

    - a manual ontape backup works - so server environment shouldn't be an issue.

    - ontape (?) backup through HQ, connected to same server --- throws said warnings, how, where?



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



  • 7.  RE: Scheduled Automatic Backup - FAIL

    Posted 05/09/23 12:04 PM
    Hi Andreas.

    When it is manual, it works. Because it is using TAPEDEV parameter from onconfig.

    When using HQ I'm getting this warning in the LOG backup.
    image.png
    So, if I try execute task, same thing.

    Thanks.
    --
    Luis Panozzo Saavedra






  • 8.  RE: Scheduled Automatic Backup - FAIL

    Posted 05/09/23 12:08 PM

    Strange.

    Can you post an 'onstat -g env' output from the server?



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



  • 9.  RE: Scheduled Automatic Backup - FAIL

    Posted 05/09/23 12:16 PM
    Here it is.

    onstat -g env

    IBM Informix Dynamic Server Version 14.10.FC10 -- On-Line -- Up 00:16:55 -- 164868 Kbytes
    2023-05-09 12:14:07

    Server start-up environment:

    Variable            Value [values-list]
    DBCENTURY           C
    DBDATE              DMY4-
    DBDELIMITER         |
    DBPATH              .
    DBPRINT             lp -s
    DBTEMP              /tmp
    IGNORE_UNDERFLOW    1
    INFORMIXDIR         /home/informix
                        [/home/informix]
                        [/usr/informix]
    INFORMIXSERVER      ifmx
    INFORMIXTERM        terminfo
                        [terminfo]
                        [terminfo]
    LANG                en_US.UTF-8
    LC_COLLATE          en_US.UTF-8
    LC_CTYPE            en_US.UTF-8
    LC_MONETARY         en_US.UTF-8
    LC_NUMERIC          en_US.UTF-8
    LC_TIME             en_US.UTF-8
    LKNOTIFY            yes
    LOCKDOWN            no
    NODEFDAC            no
    ONCONFIG            onconfig
    PATH                /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/home/inf
                         ormix/bin:.:/home/informix/bin:.:/root/bin
    SERVER_LOCALE       en_US.819
    SHELL               /bin/bash
    TERM                xterm
                        [xterm]
                        [dumb]
    TERMCAP             /etc/termcap


    --
    Luis Panozzo Saavedra






  • 10.  RE: Scheduled Automatic Backup - FAIL

    Posted 05/09/23 12:21 PM

    Looking good, all there that we'd expect (how else would this server run?)

    So, to get HQ out of the picture, would the following work or run onto same problem:

    echo "execute function admin('ontape archive directory level 0', '/backup/data', '32');" | dbaccess sysadmin



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



  • 11.  RE: Scheduled Automatic Backup - FAIL

    Posted 05/09/23 12:37 PM
    Informix is the only thing.

    Running execute function admin
    image.png

    Nothing happened

    The ph_task file has:
    image.png

    --
    Luis Panozzo Saavedra






  • 12.  RE: Scheduled Automatic Backup - FAIL

    Posted 05/09/23 12:45 PM

    Don't look in ph_taks (those entries likely are for some sensors you've asked HQ to configure?), look in command_history table instead.

    Or re-run the statement with 'task' instead of 'admin'.



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



  • 13.  RE: Scheduled Automatic Backup - FAIL

    Posted 05/09/23 12:55 PM
    Here the record.

    image.png

    --
    Luis Panozzo Saavedra
    Gerente Técnico
    luis_panozzo@sisa.com.bo
    Soluciones Integrales S.A.
    Av. Montenegro, bloque "B" #5 - Edif. SPICA - Piso 3 - San Miguel
    Teléfonos y Fax: +(591)(2) 2916983 / 2916984
    La Paz - Bolivia





  • 14.  RE: Scheduled Automatic Backup - FAIL

    Posted 05/09/23 12:58 PM

    Alright, so not an HQ problem.

    Now, since it says "Warning" only, does a backup get created?  Should be mentioned in online.log, maybe also other messages of interest?



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



  • 15.  RE: Scheduled Automatic Backup - FAIL

    Posted 05/09/23 01:04 PM
    Andreas.

    I found this thing.

    Starting the engine
    When ONCONFIG environment variable is not set, the problem appears.
    When ONCONFIG environment variable is set, no problem.

    I just restart the engine with ONCONFIG environment variable set, everything working fine.

    So the warning is not only a Warning, No backup made.

    I knew that it is not necessary ONCONFIG environment variable when you are using just one engine. But seems like it is necessary for Backup using execute function [admin|task]


    Thank You 

    --
    Luis Panozzo Saavedra
    Gerente Técnico
    luis_panozzo@sisa.com.bo
    Soluciones Integrales S.A.
    Av. Montenegro, bloque "B" #5 - Edif. SPICA - Piso 3 - San Miguel
    Teléfonos y Fax: +(591)(2) 2916983 / 2916984
    La Paz - Bolivia





  • 16.  RE: Scheduled Automatic Backup - FAIL

    Posted 05/09/23 01:07 PM

    Interesting find!

    Yes, you're right, if ONCONFIG env var isn't set, "onconfig" would be assumed, but apparently not in all places.
    Also interesting that 'onstat -g env' hides the fact that ONCONFIG actually isn't set.



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



  • 17.  RE: Scheduled Automatic Backup - FAIL

    Posted 05/09/23 01:14 PM
    Andreas.

    Yes, Very interesting.

    Thank You for your time.

    Regards.

    --
    Luis Panozzo Saavedra