To run Sybase IQ with many connections you may need to change certain system parameters. For details see the Sybase IQ Installation and Configuration Guide.