database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
PostgreSQL
Firebird
Oracle
Informix
ㆍSybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
Sybase Q&A 1383 게시물 읽기
No. 1383
ASIQ에서 최대접속수와 타임아웃대기시간을 어떻게 확인합니까?
작성자
김종길(innobizard)
작성일
2005-12-16 10:15
조회수
5,173

ASIQ에서 커넥션풀에서 허용하는 Max Connection를 확인하고 싶습니다.

그리고 connection이 된 이후 Timeout 시간를 확인 할려고 하는데 어디서 확인할수 있습니까?

 

즐거운 하루 되세요.

 

이 글에 대한 댓글이 총 4건 있습니다.

서버명.cfg file ( iq start시 사용하는 환경file 예)

                        start_asiq 서버명.cfg....) 의 내용을 보시면 확인하실수 있습니다. 물론 수정가능 하구요.

 

 -gm  xx    : IQ 최대접수가능수

 -ti     xx    : client idle time before disconnect (단위 분)

대복님이 2005-12-16 10:47에 작성한 댓글입니다. Edit

감사합니다.

새해 큰복 받으실 겁니다.

 

 

찾아보니 -gm 은 있는데 -ti는 없습니다. ㅡ,.ㅡ;;

-ti가 설정되어 있지 않으면 디폴트로 적용되나요. 디폴트값은 어떻게됩니까.

.cfg 파일을 열어보니

###############################

-n name                            
-cl 128M                             
-ch 256M                             
-ct-                                 
-gm 50                               
-gk all                              
-iqmc 2000                           
-iqtc 3000                           
-x tcpip{host=nnn.nnn.nnn.nnn;port=2638} 
/dw_dev/IQDEV/name.db    

#################################          
이런식으로 되 있던데...

.cfg파일의 각 파리미터명이 무엇인지 알수 있을까요?

관련된 사이트나 파일이 있으면 알려주시면 감사하겠습니다. ^^;;

 


 

 

김종길(innobizard)님이 2005-12-16 11:28에 작성한 댓글입니다.
이 댓글은 2005-12-16 11:44에 마지막으로 수정되었습니다.

Server options (apply to server and all databases):
        -c <size>      make initial cache a maximum of <size> bytes
                       <size> may be specified as nnnK, nnnM, nnnG, nnnP
        -ca 0          disable automatic cache resizing
        -cc[+|-]       enable/disable page collection for cache warming
                       (default is enabled)
        -ch <size>     set maximum cache size of <size> bytes
                       <size> may be specified as nnnK, nnnM, nnnG, nnnP
        -cl <size>     set minimum cache size of <size> bytes
                       <size> may be specified as nnnK, nnnM, nnnG, nnnP
        -cr[+|-]       enable/disable cache warming
                       (default is enabled)
        -cs            display cache sizing statistics
        -ct[+|-]       enable/disable client-server character translation
                       (default is enabled)
        -cv[+|-]       enable/disable cache warming status messages
                       (default is disabled)
        -ec <list>     comma-separated list of communication encryption types
                       supported types: none, simple, rsa_tls(params)
        -ep            prompt for encryption keys if necessary
        -ga            automatically shutdown after last database closed
        -gc <num>      set checkpoint timeout period to <num> minutes
        -gd <level>    set starting database permission to <level>
                       <level> may be one of "dba", "all" or "none"
        -ge <size>     set external DLL thread stack size to <size>
        -gf            disable firing of triggers
        -gk <level>    set "stopping database server" permission to <level>
                       <level> may be one of "dba", "all" or "none"
        -gl <level>    set LOAD/UNLOAD permission to <level>
                       <level> may be one of "dba", "all" or "none"
        -gm <num>      set maximum number of server connections (up to licensed maximum)
        -gn <num>      set maximum number of concurrent server requests (up to gm)
        -gp <size>     set maximum page size of <size> bytes
                       <size> must be power of 2 >= 1024 and <= 32768
        -gr <num>      set maximum recovery time to <num> minutes
        -gss <size>    set engine thread stack size of <size> bytes
                       <size> may be specified as nnnK or nnnM
        -gt <num>      set maximum number of physical processors to use (up to licensed maximum)
        -gtc <num>     set maximum processor concurrency (cores & hyperthreads)
        -gu <level>    set utility commands (e.g., DROP DATABASE) permission to <level>
                       <level> may be one of "utility_db", "dba", "all" or "none"
        -k             don't collect performance statistics
        -m             truncate transaction log after checkpoint
        -n <name>      name the database server (will be truncated to 40 characters)
        -o <file>      filename for copy of message window
        -oe <file>     filename to log startup errors, fatal errors and assertions
        -os <size>     maximum size for file specified by -o
                       <size> may be specified as nnnK, nnnM, nnnG
        -p <size>      set maximum communication packet size (>300, <16000) -- default 1460
        -pc            compress communication packets
        -pt <size>     set compression threshold (minimum packet size to compress)
        -qp            suppress performance warnings
        -qw            do not display database server screen
        -r             read-only mode -- database modifications not allowed
        -s <id>        syslog facility id (none,user,daemon,local0,...,local7)
                       (default is user)
        -sb <level>    set broadcast level
                       0=Ignore all broadcasts, 1=Ignore dblocate broadcasts
        -ti <min>      client idle time before disconnect (default is 240 minutes)
        -tl <sec>      client liveness timeout in seconds (default is 120 seconds)
        -tq <time>     set quitting time
        -u             use buffered disk I/O
        -ud            run as a daemon
        -ut <min>      touch temporary files -- default every 30 minutes.
        -v             display product version information
        -x <list>      comma-separated list of network drivers to run (TCPIP)
        -xs <list>     comma-separated list of web protocols to accept (http, https)
        -z             display debugging information
        -zl            remember last statement for each connection
        -zo <file>     redirect request logging information to file
        -zr <level>    set request logging level
                       <level> may be one of "all", "sql", "sql+hostvars", or "none"
        -zs <size>     maximum size for file specified by -zo
                       <size> may be specified as nnnK, nnnM, nnnG
        -f             force database to start without transaction log

Database options (apply only to preceding database):
        -ek <key>      specify database file encryption key
        -m             truncate transaction log after checkpoint
        -n <name>      name the database
        -r             read-only mode -- database modifications not allowed

Protocol options:
        TCP/IP:   Broadcast, BroadcastListener, DoBroadcast, Host, LDAP, LocalOnly,
                  MyIP, ReceiveBufferSize, SendBufferSize, ServerPort, TDS, Timeout
        HTTP:     DatabaseName, LocalOnly, LogFile, LogFormat, LogMaxSize,
                  LogOptions, MaxConnections, MaxRequestSize, MyIP, ServerPort,
                  Timeout
        HTTPS:    Certificate, Certificate_password, DatabaseName, LocalOnly,
                  LogFile, LogFormat, LogMaxSize, LogOptions, MaxConnections,
                  MaxRequestSize, MyIP, ServerPort, Timeout

IQ options:
        -iqmt <n>     Number of IQ threads to create
        -iqsmem <meg> Create a memory pool to increase heap space
        -iqwmem <meg> Create a wired memory pool
        -iqgovern <n> Allow up to n queries to run concurrently
        -iqmc <meg> IQ Main buffer cache size in megabytes
        -iqtc <meg> IQ Temp buffer cache size in megabytes
        -iqtss <kb> Thread stack size
        -iqmpx_ov <1> Multiplex interlock override
        -iqmpx_sn <1> Multiplex single-node mode
        -iqfrec <dbname> Open database in forced recovery mode
        -iqdroplks <dbname> Enable drop of leaked blocks for <dbname>
        -iqpartition <n> number of partitions for buffer cache
        -iqnumbercpus <n> number of cpu's IQ can use
        -iqlocalreplay <str> Multiplex local store TLV log replay options
        -iqnolocalreplay <1> Multiplex: Do not replay local tlvlog after synchronize
        -iqnomain <1> Multiplex: Start reader with local store without opening shared main store
        -iqnotemp <n> size in megabytes: Create a temporary file in place of the defined temp dbspaces

(ㅠㅠ ;)님이 2005-12-16 14:58에 작성한 댓글입니다. Edit

 

호홋

감사합니다.

 

김종길(innobizard)님이 2005-12-19 17:39에 작성한 댓글입니다.
[Top]
No.
제목
작성자
작성일
조회
1386sybase 에서 int 와 numeric 사용 상 차이? [1]
심승철
2005-12-20
4697
1385컬럼값 변경 [1]
freezone
2005-12-19
3481
1384SQL Anywhere Studio 8 Developer version [1]
궁금이
2005-12-17
3181
1383ASIQ에서 최대접속수와 타임아웃대기시간을 어떻게 확인합니까? [4]
김종길
2005-12-16
5173
1382asiq에서 테이블생성시 remark를 달수 있나요? [2]
김종길
2005-12-14
3805
1381엑세스 권한에 대해서.. 급합니다.. [2]
지니
2005-12-14
4807
1380ASA 보안관련 문의 [1]
초보
2005-12-12
3364
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.026초, 이곳 서비스는
	PostgreSQL v16.2로 자료를 관리합니다