ASIQ에서 커넥션풀에서 허용하는 Max Connection를 확인하고 싶습니다.
그리고 connection이 된 이후 Timeout 시간를 확인 할려고 하는데 어디서 확인할수 있습니까?
즐거운 하루 되세요.
서버명.cfg file ( iq start시 사용하는 환경file 예)
start_asiq 서버명.cfg....) 의 내용을 보시면 확인하실수 있습니다. 물론 수정가능 하구요.
-gm xx : IQ 최대접수가능수
-ti xx : client idle time before disconnect (단위 분)
감사합니다.
새해 큰복 받으실 겁니다.
찾아보니 -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파일의 각 파리미터명이 무엇인지 알수 있을까요?
관련된 사이트나 파일이 있으면 알려주시면 감사하겠습니다. ^^;;
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
호홋