filling db pool connection is very slow

[m_esfandiary]

Hi

i'm using jboss as 7 as application server and my database is informix(IDS 11)

when i start jboss , filling db pool connection is very slow.

for 2000 connection (min-pool-size=2000) time about 4 minutes required.

but if i replace DB2 as my default database ,  this problem does not exists.

can everybody help me?

thanks

this is my datasource configuration :

                   <datasource jta="true" jndi-name="java:jboss/datasources/InformixDS" pool-name="infx_Pool" enabled="true"  use-java-context="true" use-ccm="true">

                        <connection-url>jdbc:informix-sqli://60.1.2.41:12010/novelcore:INFORMIXSERVER=vjinformix;IFX_LOCK_MODE_WAIT=2;DB_LOCALE=cs_CZ.852;CLIENT_LOCALE=cs_CZ.852</connection-url>

                        <driver>informix</driver>

                        <pool>

                            <min-pool-size>500</min-pool-size>

                            <max-pool-size>500</max-pool-size>

                            <prefill>true</prefill>

                        </pool>

                        <security>

                            <user-name>novel</user-name>

                            <password>nnnnovel</password>

                        </security>

                        <validation>

                                <validate-on-match>true</validate-on-match>

                                <background-validation>true</background-validation>

                        </validation>

                        <timeout>

                            <blocking-timeout-millis>30000</blocking-timeout-millis>

                            <idle-timeout-minutes>5</idle-timeout-minutes>

                        </timeout>

                    </datasource>

[wdfink]

Maybe it depends on the driver.

Did you measured whether open connections to Informix/DB2 from a simple Java program shows the same behaviour?

[m_esfandiary]

Hi Wolf-Diieter

thanks from your reply

I did this test , but a simple java program with jdbc connection (10 connections) get all connections very soon.

i used same informix driver as jboss

thanks

[wdfink]

Hmm, not sure what the issue can be. My first thought was a general slowness - but this can be excluded as the DB2 works.

Maybe you use a smaler minsize or don't prefill the pool, in this case the pool will be a lazy filled after start

[m_esfandiary]

Thanks again Wolf-Diieter

Problem solved by modifying onconfig properties of informix.

in informix (IDS 12) default value of threads that manage connection has decreased , by increasing related parameter problem solved.