about locks question -error :1204 and connection timed out

[alma]

hi,
we got a problem in ASE 12.5.0 today, this is error log:
==========================================
00:00000:00009:2004/12/01 10:10:38.59 server Error: 1204,
Severity: 17, State:2
00:00000:00009:2004/12/01 10:10:38.59 server SQL Server has
run out of LOCKS.
Re-run your command when there are fewer active users, or
contact a user with Sy
stem Administrator (SA) role to reconfigure SQL Server with
more LOCKS.
01:00000:00193:2004/12/01 10:10:41.21 server login: Process
with spid 193 could
not connect to the SQL Server which has temporarily run out
of locks.
01:00000:00000:2004/12/01 10:47:43.59 kernel nrpacket:
recv, Connection timed out
==========================================
I have some questions:
1. our number of locks is 100,000 to solve error 1204, but
this error still occur. are we need add number of locks?
2. how to configure connection timed out?
3. how to avoid deadlock?

because we usually have locks problems.. :(
and our os AIX

thanks..

[Robert Densmore]

On 1 Dec 2004 02:39:41 -0800, alma wrote:

>hi,
> we got a problem in ASE 12.5.0 today, this is error log:
>==========================================
> 00:00000:00009:2004/12/01 10:10:38.59 server Error: 1204,
> Severity: 17, State:2
>00:00000:00009:2004/12/01 10:10:38.59 server SQL Server has
>run out of LOCKS.
>Re-run your command when there are fewer active users, or
>contact a user with Sy
>stem Administrator (SA) role to reconfigure SQL Server with
>more LOCKS.
>01:00000:00193:2004/12/01 10:10:41.21 server login: Process
>with spid 193 could
> not connect to the SQL Server which has temporarily run out
>of locks.
>01:00000:00000:2004/12/01 10:47:43.59 kernel nrpacket:
>recv, Connection timed out
>==========================================
>I have some questions:
>1. our number of locks is 100,000 to solve error 1204, but
>this error still occur. are we need add number of locks?

You can, but your not solving the problem. You need to back up and
look at the application design. You may have open transactions
holding locks more that necessary, you may have large transactions
that need to be re-thought.

>2. how to configure connection timed out?

If you fix the problem above, this will not be an issue.

>3. how to avoid deadlock?

If you fix the problem above, this issue should dramatically decrease.