Re: Informix 9.4 Arcserve 11 Unable to open connection to database server
Posted in 2004
Topics: Backup & Restore, Installation, Setup & Upgrades, Server Administration, Networking & sqlhosts Configuration
"Colin Bull" <Colin.Bull@videonetworks.com> wrote in message news:<ce2cmf$dv9$1@news.xmission.com>...
> Rochelle wrote
> > We're running Informix 9.4 on Windows 2000 Server (sp4) with Arcserve
> > 11 Backup Agent for Informix. These two pieces of software
> > are installed on a "clean" machine (flattened and rebuilt).
> > Just after the Informix 9.4 software and the Arcserve agent
> > was installed, I ran a full backup from the Arcserve Manager
> > server. It worked just fine.
> > The DBA started tweaking the Informix server to get it ready
> > to import the data from our production database and now it
> > won't allow us to back it up any more. We get the Unable to
> > open connection to database server 155 (0x9b) error. I have
> > another clean system that I installed a similar configuration
> > on and it has continued to allow us to use Arcserve to back
> > up the database (no changes were made to the Informix server
> > configuration though). A couple of other notes - the
> > Arcserve manager resides on a separate server and all of the
> > servers in my configuration are workgroup (not domain)
> > servers. We've compared the configurations of the two
> > servers mentioned above and re-entered configuration data
> > until we're blue in the face. About the only thing we
> > haven't done is uninstalled and/or re-installed any of the
> > software. Anyone have any ideas about what might be causing
> > this problem?
> >
> What configuration files have you checked -
> Services
> Onconfig
> Sqlhosts
>
> Does the INFORMIXSERVER entry in onconfig match the entry in sqlhosts ?
> Is this variable set in your environment ?
>
> Colin Bull
> C.bull@videonetworks.com
>
> ________________________________________________________________________
> This email has been scanned for all known viruses by the MessageLabs Email
> Security System.
> ________________________________________________________________________
>
> sending to informix-list
Yes, I've checked everything -
environment variables
sqlhosts (as configured in ISA - there is no sqlhosts file per se)
hosts
services
onconfig
the registry
alarmprogram.bat
onbar.bat
sm_versions
the CA Informix Agent & Batch Job configurations
Everything looks like it is set the way it is supposed to be or it
matches (in syntax) the server that is working with the same versions
of Arcserve and Informix. This doesn't make any sense whatsoever. We
installed the software, I ran a backup from the CA manager and it
worked. The DBA changed the configuration of the database and
imported data and it stopped working. The DBA was able to get an ISM
backup to disk to work - which also uses onbar. He didn't get the
connection error when he did that. But I still get the same "unable
to connect" error message when I try a CA backup.
Any help would be greatly appreciated.
Thanks, Rochelle