0 Replies Latest reply on Jun 29, 2007 6:27 AM by Marc Lorek

    #Connections vs Datasources vs. #Jboss Nodes

    Marc Lorek Newbie

      Hi,

      we have a problem concering the number of connections during the startup of 4 Jboss Nodes (2 on one phy. machine; no clustering, just farmin with a use of one shared deploy dir using a common binding file).

      The instances are bound to virtual eth Interfaces and using the same ports. Just one Info behind the scene. Before this setup we use two apaches mit mod_jk properly configured.

      This is our db configuration (DB2),e.g.

      <datasources>
      
       <xa-datasource>
       <jndi-name>WLDS</jndi-name>
       <xa-datasource-class>com.ibm.db2.jcc.DB2XADataSource</xa-datasource-class>
       <xa-datasource-property name="DriverType">4</xa-datasource-property>
       <xa-datasource-property name="DatabaseName">GAME</xa-datasource-property>
       <xa-datasource-property name="User">xxx</xa-datasource-property>
       <xa-datasource-property name="Password">xxx</xa-datasource-property>
       <xa-datasource-property name="PortNumber">xxx</xa-datasource-property>
       <xa-datasource-property name="ServerName">xxx</xa-datasource-property>
       <xa-datasource-property name="CurrentSchema">xxx</xa-datasource-property>
       <transaction-isolation>TRANSACTION_READ_UNCOMMITTED</transaction-isolation>
       <min-pool-size>40</min-pool-size>
       <max-pool-size>40</max-pool-size>
       <track-statements>true</track-statements>
       <track-connection-by-tx>true</track-connection-by-tx>
       <no-tx-separate-pools/>
       <prepared-statement-cache-size>10</prepared-statement-cache-size>
       <set-tx-query-timeout/>
       </xa-datasource>
      
       <no-tx-datasource>
       <jndi-name>QUARTZDS</jndi-name>
       <connection-url>jdbc:db2:xxx:currentSchema=xxxx;</connection-url>
       <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
       <user-name>xxx</user-name>
       <password>xx</password>
       <min-pool-size>40</min-pool-size>
       <max-pool-size>40</max-pool-size>
       <metadata>
       <type-mapping>DB2</type-mapping>
       </metadata>
       <set-tx-query-timeout/>
       <transaction-isolation>TRANSACTION_READ_UNCOMMITTED</transaction-isolation>
       <track-statements>true</track-statements>
       <track-connection-by-tx>true</track-connection-by-tx>
       <no-tx-separate-pools/>
       <prepared-statement-cache-size>0</prepared-statement-cache-size>
       <set-tx-query-timeout/>
       </no-tx-datasource>
      
      
       <local-tx-datasource>
       <jndi-name>JMSDS</jndi-name>
       <connection-url>jdbc:db2:JBOSS:currentSchema=JBOSS;</connection-url>
       <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
       <user-name>xx</user-name>
       <password>xxx</password>
       <min-pool-size>40</min-pool-size>
       <max-pool-size>40</max-pool-size>
       <metadata>
       <type-mapping>DB2</type-mapping>
       </metadata>
       <set-tx-query-timeout/>
       <transaction-isolation>TRANSACTION_READ_UNCOMMITTED</transaction-isolation>
       </local-tx-datasource>
      
      </datasources>


      During the startup of ONE instance i recognize ca. 160 DB connections using "db2 list applications".

      Why? Ok, tx-separate-pool is NOT working, so 40+40 for WLDS, 40 JMSDS and 40 for QUARTZ DS? Each further instance produce 120 Connections, so with 4 instances up i have 160+120+120+120. (=too much)

      What is the best practice to have 160 Connections at all about all 4 nodes?
      Ok, reduce it to 10, but the one machine has only 10 Connections avail and not 40 i would like to have.

      (160 is the maximum limit configured concerning the database.)

      Any ideas?

      Best regards,
      Marc