hi,

I Have a database on ASE 11.9..2,every thing was well before the following
alerting .
After I add 4 text field in the order_master table,
if exceed 3 user update this table on the same time(
of course the differ order_no), the data blocked happen.
the client that have opened the order_master table
cannot get any reply from the server.

I execuse the SP_LOCK to see, there are 4-7 process locktype show
'Sh_row-blk' or 'Sh_intent-blk' or 'Sh_table-blk' ..., I have to delete
the process manual then the server will run normally.

How can I avoid this stuation? Please give me a hand.


Kadee