SAP IQ slow simple query.

[former_member214071]

Good day everyone,

we have a iq server 16 running on windows 2008 r2 48GB RAM and 4 procesor. it is a virtual machine.

the iq server has the following startup parameters

-c 128M
-gc 60
-gd DBA
-gl all
-gm 50
-iqmc 14745
-iqtc 19660
-iqlm 14745
-iqmsgsz 100
-iqmsgnum 3

The query is taking about 35 seconds to run, any idea how to improve performance. I alreadya created all the recommend indexes of index advice.

Thanks in advace

dba-l-0-20180905-143731-135.txt

[former_member214071]

forgot to post iqstatus.

Sybase IQ (TM),Copyright (c) 1992-2013 by Sybase, Inc. All rights reserved.
Version:,16.0.0.429/130316/P/GA/MS/Windows 2003/64bit/2013-03-16 21:30:09
Time Now:,2018-09-06 08:08:23.989
Build Time:,2013-03-16 21:30:09
File Format:,23 on 03/18/1999
Server mode:,IQ Server
Catalog Format:,2
Stored Procedure Revision:,1
Page Size:,131072/8192blksz/16bpp
Number of Main DB Files:,4
Main Store Out Of Space:,N
Number of Shared Temp DB Files:,0
Shared Temp Store Out Of Space:,N
Number of Local Temp DB Files:,5
Local Temp Store Out Of Space:,N
DB Blocks: 1-128000,IQ_SYSTEM_MAIN
DB Blocks: 1045440-3666879,IQ_USERDATA01_1
DB Blocks: 4181760-6803199,IQ_USERDATA01_2
DB Blocks: 7318080-9939519,IQ_USERDATA01_3
Local Temp Blocks: 1-128000,IQ_SYSTEM_TEMP
Local Temp Blocks: 1045440-1429439,IQ_SYSTEM_TEMP02
Local Temp Blocks: 2090880-2474879,IQ_SYSTEM_TEMP03
Local Temp Blocks: 3136320-3520319,IQ_SYSTEM_TEMP04
Local Temp Blocks: 4181760-5492479,IQ_SYSTEM_TEMP05
Create Time:,2014-12-23 15:08:56.175
Update Time:,2018-09-06 04:05:06.666
Main IQ Buffers:,117543, 14745Mb
Temporary IQ Buffers:,156725, 19660Mb
Main IQ Blocks Used:,1163889 of 7966720, 14%=9092Mb, Max Block#: 7721549
Shared Temporary IQ Blocks Used:,0 of 0, 0%=0Mb, Max Block#: 0
Local Temporary IQ Blocks Used:,5426 of 2565120, 0%=42Mb, Max Block#: 4190000
Main Reserved Blocks Available:,25600 of 25600, 100%=200Mb
Shared Temporary Reserved Blocks Available:,0 of 0, 0%=0Mb
Local Temporary Reserved Blocks Available:,25600 of 25600, 100%=200Mb
IQ Dynamic Memory:,Current: 34538mb, Max: 34730mb
Main IQ Buffers:,Used: 61086, Locked: 0
Temporary IQ Buffers:,Used: 1576, Locked: 3
Main IQ I/O:,I: L4984443/P58154 O: C5735/D23891/P21142 D:3460 C:45.0
Temporary IQ I/O:,I: L13238083/P386 O: C2373491/D2374129/P2332 D:2372681 C:55.5
Other Versions:,0 = 0Mb
Active Txn Versions:,0 = C:0Mb/D:0Mb
Last Full Backup ID:,0
Last Full Backup Time:,
Last Backup ID:,0
Last Backup Type:,None
Last Backup Time:,
DB Updated:,1
Blocks in next ISF Backup:,0 Blocks: =0Mb
Blocks in next ISI Backup:,0 Blocks: =0Mb
IQ large memory space:,14745Mb
IQ large memory flexible percentage:,50
IQ large memory flexible used:,0Mb
IQ large memory inflexible percentage:,90
IQ large memory inflexible used:,0Mb
IQ large memory anti-starvation percentage:,50
DB File Encryption Status:,ON
RLV memory limit:,2048Mb
RLV memory used:,0Mb