Urgent : Net connection problem on production

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

samir BADAOUI - 26 Aug 2003 17:18 GMT

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

Reply to this Message

Art S. Kagel - 26 Aug 2003 18:08 GMT

Don't reduce LOCKS increase it!

Art S. Kagel

> Hi all,
>
[quoted text clipped - 21 lines]
>
> sending to informix-list

Reply to this Message

preetinder dhaliwal - 26 Aug 2003 18:13 GMT

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

> Hi all,
>
[quoted text clipped - 21 lines]
>
> sending to informix-list

sending to informix-list

Reply to this Message

preetinder dhaliwal - 26 Aug 2003 18:15 GMT

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

Rgds
Preetinder

> Hi all,
>
[quoted text clipped - 21 lines]
>
> sending to informix-list

sending to informix-list

Reply to this Message

preetinder dhaliwal - 26 Aug 2003 18:30 GMT

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

http://www-3.ibm.com/software/data/informix/pubs/library/notes/relnotes/ods724c1
.htm#known

Rgds
Preetinder

> Hi all,
>
[quoted text clipped - 21 lines]
>
> sending to informix-list

sending to informix-list

Reply to this Message

samir BADAOUI - 28 Aug 2003 15:57 GMT

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.

>From: preetinder dhaliwal <preetinder.dhaliwal@dhl.com>
>To: samir BADAOUI <samir_badaoui@hotmail.com>
[quoted text clipped - 46 lines]
>
>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

Reply to this Message