Configure a new WAS40 connection pool

• Identify the parent ID:

  set new40ds [$AdminConfig getid /Cell:cellname/Node:nodename/JDBCProvider:JDBC1/WAS40DataSource:was4DS1/]
  

  was4DS1(cells/cellname/nodes/nodenames:resources.xml$WAS40DataSource_1)
  

• Get required attributes:

  $AdminConfig required WAS40ConnectionPool
  

  Example output:

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

• Set up required attributes:

  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}
  

• Create was40 connection pool:

  $AdminConfig create WAS40ConnectionPool $new40ds $40cpAttrs
  

  Example output:

  (cells/cellname/nodes/nodename:resources.xml#WAS40ConnectionPool_1)
  

• Save changes:

  $AdminConfig save
  

 

IBM is a trademark of the IBM Corporation in the United States, other countries, or both.