Configure new WAS40 connection pools using wsadmin.sh (deprecated)

Use scripting to configure a new WAS40 connection pool.

See the topic on starting the wsadmin tool for more information.

Perform the following steps to configure a new WAS40 connection pool:

Tasks

1. Identify the parent ID:
   • Jacl:

     set new40ds [$AdminConfig getid /Cell:mycell/Node:mynode/
     Server:server1/JDBCProvider:JDBC1/WAS40DataSource:was4DS1/]
     

   • Jython:

     new40ds = AdminConfig.getid('/Cell:mycell/Node:mynode/
     Server:server1/JDBCProvider:JDBC1/WAS40DataSource:was4DS1/')
     print new40ds
     

   Example output:

   was4DS1(cells/mycell/nodes/mynodes:resources.xml$WAS40DataSource_1)
   

2. Get required attributes:
   • Jacl:

     $AdminConfig required WAS40ConnectionPool
     

   • Jython:

     print AdminConfig.required('WAS40ConnectionPool')
     

   Example output:

   Attribute      	Type
   minimumPoolSize     Integer
   maximumPoolSize     Integer
   connectionTimeout   Integer
   idleTimeout        Integer
   orphanTimeout       Integer
   statementCacheSize  Integer
   

3. Set up required attributes:
   • Jacl:

     set mps [list minimumPoolSize 5]
     set minps [list minimumPoolSize 5]
     set maxps [list maximumPoolSize 30]
     set conn [list connectionTimeout 10]
     set idle [list idleTimeout 5]
     set orphan [list orphanTimeout 5]
     set scs [list statementCacheSize 5]
     set 40cpAttrs [list $minps $maxps $conn $idle $orphan $scs]
     

     Example output:

     {minimumPoolSize 5} {maximumPoolSize 30} 
     {connectionTimeout 10} {idleTimeout 5} 
     {orphanTimeout 5} {statementCacheSize 5}
     

   • Jython:

     minps = ['minimumPoolSize', 5]
     maxps = ['maximumPoolSize', 30]
     conn = ['connectionTimeout', 10]
     idle = ['idleTimeout', 5]
     orphan = ['orphanTimeout', 5]
     scs = ['statementCacheSize', 5]
     cpAttrs = [minps, maxps, conn, idle, orphan, scs]
     print cpAttrs
     

     Example output:

     [[minimumPoolSize, 5], [maximumPoolSize, 30], 
     [connectionTimeout, 10], [idleTimeout, 5],  
     [orphanTimeout, 5], [statementCacheSize, 5]]
     

4. Create was40 connection pool:
   • Jacl:

     $AdminConfig create WAS40ConnectionPool $new40ds $40cpAttrs
     

   • Jython:

     print AdminConfig.create('WAS40ConnectionPool', new40ds, 40cpAttrs)
     

   Example output:

   (cells/mycell/nodes/mynode:resources.xml#WAS40ConnectionPool_1)
   

5. Save the configuration changes.
6. In a network deployment environment only, synchronize the node.

Start the wsadmin scripting client

wsadmin AdminConfig

Save wsadmin configuration changes

Synchronize nodes

Commands for the AdminConfig object