Urgent : Net connection problem on production

#1

Hi all,

After installing an other application on my production box. I receive the
following error when I try to connect to my tcpip server interface :
908 : Attempt to connect to database server <databaseServerName> failed
No record locks available

But when I try to connect to my ipcshm server interface, all is ok.

I have this problem one or 2 times a day. and when I restart my informix
server, my problems are resolved.

Did some one have any idea what can be this problem ?? It seams like a
resource problem. I reduce my LOCKS config parameter, but the problem is
still here !

I am using Informix 7.24 under AIX 4.3.3

Thanks for any help

__________________________________________________ _______________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail

sending to informix-list

#2

On Tue, 26 Aug 2003 12:18:23 -0400, samir BADAOUI wrote:

Don't reduce LOCKS increase it!

Art S. Kagel

Quote:

Hi all,

After installing an other application on my production box. I receive the
following error when I try to connect to my tcpip server interface : 908 :
Attempt to connect to database server <databaseServerName> failed No record
locks available

But when I try to connect to my ipcshm server interface, all is ok.

I have this problem one or 2 times a day. and when I restart my informix
server, my problems are resolved.

Did some one have any idea what can be this problem ?? It seams like a
resource problem. I reduce my LOCKS config parameter, but the problem is still
here !

I am using Informix 7.24 under AIX 4.3.3

Thanks for any help

__________________________________________________ _______________ The new MSN
8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail

sending to informix-list

#3

First - error 908 states that you might be facing network congestion.

When this problem occurs - check ping status to the server machine from
client machine( u can run it continuously and see the difference when
the problem occurs).

Second - use onstat -k to check number of active locks ( and total
number of locks ), if it is near the total number of locks u configured
in onconfig , increase ( not decrease ) the number of locks.

Hope this helps

Rgds
Preetinder

samir BADAOUI wrote:

Quote:

Hi all,

After installing an other application on my production box. I receive
the following error when I try to connect to my tcpip server interface :
908 : Attempt to connect to database server <databaseServerName> failed
No record locks available

But when I try to connect to my ipcshm server interface, all is ok.

I have this problem one or 2 times a day. and when I restart my
informix server, my problems are resolved.

Did some one have any idea what can be this problem ?? It seams like
a resource problem. I reduce my LOCKS config parameter, but the
problem is still here !

I am using Informix 7.24 under AIX 4.3.3

Thanks for any help

__________________________________________________ _______________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail

sending to informix-list

sending to informix-list

#4

One more thing - error 908 mentions ( in finderr utility) , how to deal
with slow/congested network.
( INFORMIXCONTIME and INFORMIXCONRETRY variable)

Rgds
Preetinder

samir BADAOUI wrote:

Quote:

Hi all,

After installing an other application on my production box. I receive
the following error when I try to connect to my tcpip server interface :
908 : Attempt to connect to database server <databaseServerName> failed
No record locks available

But when I try to connect to my ipcshm server interface, all is ok.

I have this problem one or 2 times a day. and when I restart my
informix server, my problems are resolved.

Did some one have any idea what can be this problem ?? It seams like
a resource problem. I reduce my LOCKS config parameter, but the
problem is still here !

I am using Informix 7.24 under AIX 4.3.3

Thanks for any help

__________________________________________________ _______________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail

sending to informix-list

sending to informix-list

#5

this site ( machine specific release notes for 7.24 ) specifies this bug

http://www-3.ibm.com/software/data/i...24c1.htm#known

Rgds
Preetinder

samir BADAOUI wrote:

Quote:

Hi all,

After installing an other application on my production box. I receive
the following error when I try to connect to my tcpip server interface :
908 : Attempt to connect to database server <databaseServerName> failed
No record locks available

But when I try to connect to my ipcshm server interface, all is ok.

I have this problem one or 2 times a day. and when I restart my
informix server, my problems are resolved.

Did some one have any idea what can be this problem ?? It seams like
a resource problem. I reduce my LOCKS config parameter, but the
problem is still here !

I am using Informix 7.24 under AIX 4.3.3

Thanks for any help

__________________________________________________ _______________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail

sending to informix-list

sending to informix-list

#6

Thinks preetinder,
I don't tink that is a lock probleme. I checked the number of active locks
when the problem accurs, and I had a just few active locks.

Quote:

From: preetinder dhaliwal <preetinder.dhaliwal (AT) dhl (DOT) com
To: samir BADAOUI <samir_badaoui (AT) hotmail (DOT) com
CC: informix-list (AT) iiug (DOT) org
Subject: Re: Urgent : Net connection problem on production
Date: Tue, 26 Aug 2003 10:13:47 -0700

First - error 908 states that you might be facing network congestion.

When this problem occurs - check ping status to the server machine from
client machine( u can run it continuously and see the difference when the
problem occurs).

Second - use onstat -k to check number of active locks ( and total number
of locks ), if it is near the total number of locks u configured in
onconfig , increase ( not decrease ) the number of locks.

Hope this helps

Rgds
Preetinder

samir BADAOUI wrote:

Hi all,

After installing an other application on my production box. I receive the
following error when I try to connect to my tcpip server interface :
908 : Attempt to connect to database server <databaseServerName> failed
No record locks available

But when I try to connect to my ipcshm server interface, all is ok.

I have this problem one or 2 times a day. and when I restart my informix
server, my problems are resolved.

Did some one have any idea what can be this problem ?? It seams like a
resource problem. I reduce my LOCKS config parameter, but the problem is
still here !

I am using Informix 7.24 under AIX 4.3.3

Thanks for any help

__________________________________________________ _______________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail

sending to informix-list

sending to informix-list

__________________________________________________ _______________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail

sending to informix-list

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Urgent : Net connection problem on production

comp.databases.informix comp.databases.informix

Urgent : Net connection problem on production - 08-26-2003 , 11:18 AM

Re: Urgent : Net connection problem on production - 08-26-2003 , 12:08 PM

Re: Urgent : Net connection problem on production - 08-26-2003 , 12:13 PM

Re: Urgent : Net connection problem on production - 08-26-2003 , 12:15 PM

Re: Urgent : Net connection problem on production - 08-26-2003 , 12:30 PM

Re: Urgent : Net connection problem on production - 08-28-2003 , 09:57 AM