Skip to Content
0
Former Member
Apr 30, 2013 at 01:55 AM

stop of IQ Server failed by "INT: FlushStats" temporary connection.

114 Views

Customer Using SAP Sybase IQ 15.4 ESD#1 on Windows Server 2008R2.

This IQ Server start/stop via Windows Service Manager.

Sometimes, IQ service will fail to shut down.

At that time, the temporary connection "INT: FlushStats" exists.

I want to know why continue to exist this temporary connection.

ConnHandle Name Userid LastReqTime ReqType IQCmdType LastIQCmdTime IQCursors LowestIQCursorState IQthreads TxnID ConnCreateTime TempTableSpaceKB TempWorkSpaceKB IQconnID satoiq_count iqtosa_count CommLink LastIdle MPXServerName LSName

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

1000004513 INT: FlushStats unknown (0) NONE 0001-01-01 00:00:00.0 0 NONE 0 0 2013-04-24 09:30:07.0 0 0 4522 2 0 NA 0 (NULL) (NULL)

116 SQL_DBC_7248700 DBA 2013-04-25 00:45:00.412 OPEN IQUTILITYOPENCURSOR 2013-04-25 00:45:01.0 0 NONE 0 4438444 2013-04-25 00:45:01.0 0 0 32478 47 2 local 3 (NULL) (NULL)

This box has 8 CPU.

However customer set "-gm 100 -gn150 -gt4".

I think thst following values ​​are calculated number of threads IQ.

-iqmt = 60 * 4 CPU + 100(-gm) + 6 = 346

I. 04/25 09:34:49. 0000000000 Using licenses from: D:\SybaseIQ\SYSAM-2_0\licenses\SYBASE.lic;C:\Windows\system32\*.lic
I. 04/25 09:34:49. 0000000000 Checked out license for 4 IQ_CORE (9999.12310/permanent/15A0 D777 D3F9 27B8).
I. 04/25 09:34:49. 0000000000 This product is licensed to: Maruho Co.,Ltd.

I. 04/25 09:34:49. 0000000000 OpenDatabase Completed
I. 04/25 09:34:49. 0000000000 IQ cmd line srv opts: -iqmc 8192 -iqtc 10240 -iqmsgsz 10 -iqmsgnum 10
I. 04/25 09:34:49. 0000000000 IQ full cmd line: -n saidcc55_maruho -x tcpip{port=2638} -c 64m -gd DBA -gk DBA -gl all -gm 100 -gn 150 -gt 4 -iqmc 8192 -iqtc 10240 -iqmsgsz 10 -iqmsgnum 10 -m -o E:\SybaseIQ_DB\MARUHO\MaruhoSrvlog.srvlog E:\SybaseIQ_DB\MARUHO\maruho.db
I. 04/25 09:34:49. 0000000000 DB: r/w, Main 4066MB Buffs=65296, Temp 2010MB Buffs=81621, Pgsz=131072/8192blksz/16bpc, BP=2

I've read the following threads.

It should be increased "-qmt"?

connection with name INT:flushstats

http://scn.sap.com/thread/3345080

Yasuo Kogawa