Operating System - HP-UX
1828786 Members
2833 Online
109985 Solutions
New Discussion

informix listener not restarting

 
Lana Cameli
Advisor

informix listener not restarting

hi there,
i have an HP-UX 10.x server with Informix DB on it. i also have some applications that access the Informix db and to enable that, i have a listener enabled on port 987. Every now and then, the listener goes down and i am not able to restart it on a command line. i get port bound error. the only way i am able to get it going again is by rebooting the system. i suspected omnitrig (we use bru utility to do our backup and on occasion, tar)and commented it out which seemed to help a little, however, somehow it gets re-initialized and the listener goes down again. i don't have that much experience with this and was hoping i can find some help here.

questions i have:
1. can i start the sqlexec as a service, rather then process off the command line, which i'm assuming would require kernel configuration.

2. how can i find out what holds up the port thus not enabling the listener restart.

3. what is omnitrig and do i need it.

any help would be appreciated.
thank you.
4 REPLIES 4
Steven E. Protter
Exalted Contributor

Re: informix listener not restarting

omnitrig is the 15 minute trigger to run backup jobs. If any backup jobs are on the schedule omnitrig wruns them.

netstat -rn or -an will get you a good look at the ports.

lsof
http://hpux.connect.org.uk/hppd/hpux/Sysadmin/lsof-4.70/

Can get you a better look.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
A. Clay Stephenson
Acclaimed Contributor

Re: informix listener not restarting

Omnitrig is only used by OmniBack/Data Protector. If you do not have these products installed then you don't need it. I susprect the problem is that the listener is not shutting down properly for backup and thus is not restarting when the backup completes. This assumes that you are doing a cold database backup. I assume that you have scripts to either shutdown the database or put it in a backup mode for hotbackups. If not, your database backups are worthless.
If it ain't broke, I can fix that.
Gustavo Ferraro
Advisor

Re: informix listener not restarting

Lana,
- which Informix version are you using?

- do you use omniback/data protector for backups {logical logs and instance backups) ?

- as far as i know, Informix doesn't have a separate listener, it's bulting in the server and configured via sqlhosts and onconfig configuration files.

- hp-ux 10.20 needs some patches in order to run Informix without problems.
Lana Cameli
Advisor

Re: informix listener not restarting

i have not changed the backup routine in any way and it has worked in the past, for both, sys and db. however, it would be worth checking just to make sure. thank you.

- Informix version we're using is 7.20

- I dont' know what omniback/data protector for backups {logical logs and instance backups) is.

- to enable a "listener" i downloaded CSDK for Informix which required to have some type of a listener enabled on the HP end. I did that in the /etc/services file (as DAServer) and assigned it to port 987/tcp.

i then enabled it by excecuting the following command:
/usr/informix/lib/sqlexecd -l /tmp/SQLConnect.log

we back up all files nightly using either BRU (backup and restore utility) or tar (once a week) and so far, i did not receive any errors. the db is not used at night by users but maybe used by cron jobs.

also, there were a bunch of patches installed a while ago but i wouldn't mind looking into that....just need to figure out how.