|
su.dbms
- SU.DBMS ----------------------------------------------------------------------
From : Vladimir Zyrianov 2:5020/400 24 Oct 2001 19:57:30
To : Vladimir Zyrianov
Subject : Re: Sybase 11.9.2 - max connections
--------------------------------------------------------------------------------
и вдогонку
из
http://manuals.sybase.com/onlinebooks/group-cn/cng1110e/ctref/@ebt-link;pt=1
2230?target=%25N%15_22122_START_RESTART_N%25
Open Client Client-Library/C Reference Manual
Using the Run-Time Configuration File
CS_MAX_CONNECT ct_init An integer value.
если вспомнить про Default 25 connect - можно и здесь посмотреть....
" Vladimir Zyrianov" <vvz@asbm.ru> wrote in message
news:9r6nss$1rlb$1@news.gamma.ru...
> Hi,
> может здесь копать?
>
> > tcp no delay = DEFAULT
> ==
> The tcp no delay parameter controls TCP (Transmission Control Protocol)
> packet batching. The default value is 0, which means that TCP packets are
> batched.
> TCP normally batches small logical packets into single larger physical
> packets (by briefly delaying packets) in order to fill physical network
> frames with as much data as possible. This is intended to improve network
> throughput in terminal emulation environments where there are mostly
> keystrokes being sent across the network.
> ===
>
> "Vladimir Podgorny" <raven@cemetery.org.ua> wrote in message
> news:9pshvm$rdg$1@snake.ukrnet.net...
> > Re ALL
> >
> > Возник вопрос - есть sybase 11.9.2 ASE и некая софтинка, достаточно
> активно
> > его насилующая. Проблема - при попытке открыть более 25 одновременных
> > соединений к sybase-у, в логах появляется ругань типа:
> >
> > <cite ругань>
> >
> > ...
> >
> > Mon Oct 8 17:33:56 2001: Error: pid=30421, Dropping request (all
database
> > logins are busy): from client xxx.xx.xxx.xxx - ID: 85
> > Mon Oct 8 17:33:56 2001: Error: pid=30421, Dropping request (all
database
> > logins are busy): from client xxx.xx.xxx.xxx - ID: 86
> > Mon Oct 8 17:33:56 2001: Error: pid=30421, Dropping request (all
database
> > logins are busy): from client xxx.xx.xxx.xxx - ID: 87
> > Mon Oct 8 17:33:56 2001: Error: pid=30421, Dropping request (all
database
> > logins are busy): from client xxx.xx.xxx.xxx - ID: 232
> >
> > ...
> >
> > </cite>
> >
> > Конфиг sybase имеет вид:
> >
> > <cite sybase.cfg>
> >
> > ...
> >
> > [Network Communication]
> > default network packet size = DEFAULT
> > max network packet size = DEFAULT
> > remote server pre-read packets = DEFAULT
> > number of remote connections = 100
> > allow remote access = DEFAULT
> > number of remote logins = 100
> > number of remote sites = 20
> > max number network listeners = 50
> > tcp no delay = DEFAULT
> > allow sendmsg = DEFAULT
> > syb_sendmsg port number = DEFAULT
> >
> > [Physical Memory]
> > total memory = 65536
> > additional network memory = DEFAULT
> > lock shared memory = DEFAULT
> > shared memory starting address = DEFAULT
> > max SQL text monitored = DEFAULT
> >
> > [User Environment]
> > number of user connections = 100
> > stack size = DEFAULT
> > stack guard size = DEFAULT
> > permission cache entries = DEFAULT
> > user log cache size = DEFAULT
> > user log cache spinlock ratio = DEFAULT
> >
> > ...
> >
> > </cite>
> >
> > Так не подскажет ли любезный ALL, куда копать, чего читать?
> >
> > --
> > VP992-RIPE [ Самое неприятное в обещаниях то, что их приходится
> выполнять. ]
>
>
--- ifmail v.2.15dev5
* Origin: Gamma NNTP server Moscow Russia (2:5020/400)
Вернуться к списку тем, сортированных по: возрастание даты уменьшение даты тема автор
|
