Original Message:
Sent: 5/9/2023 1:07:00 PM
From: Andreas Legner
Subject: RE: Scheduled Automatic Backup - FAIL
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
------------------------------
Original Message:
Sent: Tue May 09, 2023 01:03 PM
From: Luis Panozzo
Subject: Scheduled Automatic Backup - FAIL
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.boSoluciones 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
Original Message:
Sent: 5/9/2023 12:45:00 PM
From: Andreas Legner
Subject: RE: Scheduled Automatic Backup - FAIL
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
------------------------------
Original Message:
Sent: Tue May 09, 2023 12:36 PM
From: Luis Panozzo
Subject: Scheduled Automatic Backup - FAIL
Informix is the only thing.
Running execute function admin

Nothing happened
The ph_task file has:
--
Original Message:
Sent: 5/9/2023 12:21:00 PM
From: Andreas Legner
Subject: RE: Scheduled Automatic Backup - FAIL
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
Original Message:
Sent: Tue May 09, 2023 12:15 PM
From: Luis Panozzo
Subject: Scheduled Automatic Backup - FAIL
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
--
Original Message:
Sent: 5/9/2023 12:08:00 PM
From: Andreas Legner
Subject: RE: Scheduled Automatic Backup - FAIL
Strange.
Can you post an 'onstat -g env' output from the server?
------------------------------
Andreas Legner
Original Message:
Sent: Tue May 09, 2023 12:03 PM
From: Luis Panozzo
Subject: Scheduled Automatic Backup - FAIL
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.
So, if I try execute task, same thing.
Thanks.
Original Message:
Sent: 5/9/2023 11:52:00 AM
From: Andreas Legner
Subject: RE: Scheduled Automatic Backup - FAIL
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
Original Message:
Sent: Tue May 09, 2023 11:13 AM
From: Luis Panozzo
Subject: Scheduled Automatic Backup - FAIL
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.boSoluciones 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
Original Message:
Sent: 5/9/2023 11:07:00 AM
From: Andreas Legner
Subject: RE: Scheduled Automatic Backup - FAIL
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
Original Message:
Sent: Tue May 09, 2023 11:02 AM
From: Luis Panozzo
Subject: Scheduled Automatic Backup - FAIL
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.boSoluciones 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