I'm testing the upgrade of our ERP server (OS & Informix) on our test/dev server and everything went well except the alarmprogram not doing logical log backups. And, I am puzzled by why is not working.
prior to upgrade was SUSE Linux Enterprise Server 11 SP4 with Informix 12.10.fc7. After the upgrade is SUSE Linux Enterprise Server 15 SP2 and Informix 12.10.FC13. Is a VM on VMware vSphere, but don't think that has anything to the cause of logical logs not backing up.
I didn't see any errors or other indications of a Informix problem and on OS side I test cron and at jobs which seem to work. Also reviewed permissions/ownership and config files. But maybe reading what I want not what printed.
if have any suggestions on what to do next would be grateful.
ll ../bin/oninit
-rwsr-sr-- 1 root informix 27392099 Sep 20 2021 ../bin/oninit
ll onconf.cars
-rw-r--r-- 1 informix informix 84831 Jan 4 09:02 onconf.cars
ll alarmprogram.sh
-rwxr-xr-x 1 root informix 19716 Sep 20 2021 alarmprogram.sh
On production system that is working still on old OS/Informix as the dba user as owner and not root, and group I think also the primary for the dba user not Informix. I've tried with root:Informix and dba:common and neither seem to make a difference.
grep ALARMPROG onconf.cars
# ALARMPROGRAM - Specifies the alarm program to display event
# SYSALARMPROGRAM - Specifies the system alarm program triggered
ALARMPROGRAM /opt/informix/etc/alarmprogram.sh
SYSALARMPROGRAM /opt/informix/etc/evidence.sh
grep LTAPEDEV onconf.cars
# LTAPEDEV - The tape device path for logical logs
#LTAPEDEV /dev/null
LTAPEDEV /backups
ll / | grep backups
drwxrwx--- 3 informix informix 28672 Apr 8 08:59 backups
ll /opt | grep informix
drwxr-xr-x 35 informix informix 4096 Sep 20 2021 informix
John David Adamski
Sr. Sysadmin/DBA
Graceland University
1 University Place, Lamoni, IA 50140
adamski@graceland.edu641-784-5267
#Informix