How to increase the number of simultaneous(concurrent) connections to the Sybase IQ

[Former Member]

Hi All,

I am very new to Sybase IQ and this is the first time we have using the product.

We are getting an error when we have more than 10 connections to the Sybase IQ DB. is there a way to increase this number of connections ? We are using a fully licensed version of Sybase IQ 15.4.

Same Error appears when we connect via SAP BusinessObjects and InfiniteInsight to the DB.

Please see attached screenshot for the error on InfiniteInsight.

Thank you,

Shanka

[Former Member · Accepted solution]

Setting was changed on the params.cfg file on the folder where the DB files were saved and it worked.

Thank you all for helping out!

Shanka

[Former Member]

Thank you all for the replays. We have changed the setting for -gm in the default.cfg file under C:\....\IQ-15_4\Scripts\

Still it seems to be allowing only 10 connections.

Thanks,

Shanka

[Former Member]

SyBooks Online

You need -gm option

[markmumy]

When increasing -gm, make sure to also set -gn to 1.5x the value of -gm.  If -gm is set to 100, then -gm would need to be set to 150.

Additionally, as you increase the number of connections, you would also want to increase the amount of catalog cache via the -c option, or alternatively via -cl and -ch.

For some descriptions on these values, the caches, threads, etc see my IQ Sizing Guide here:

Mark

[Former Member]

Hello Shanka,

it is obvious that you are using default values for your IQ server.

It is possible to change numbet of concurrent connections to db server, by changing values for - gm switch in your configuration file.

See description of -gm switch on sybase infocenter:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00168.1540/doc/html/saiq-...

Regards,

Marian

[c_baker]

Shanka,

If you are using the default values that come with the iqdemo installation, then you will also need to increase the cache memory configurations as well.  Examine -iqmc, -iqtc and -iqlm to start with.

Chris