Changing the JDBC connection Pool Size

server1=AdminConfig.getid('/Node:Node01/Server:server1/')

print server1

jvm = AdminConfig.list('JavaVirtualMachine', server1)

print "-->  variable jvm is"

print "-->  AdminConfig.show(jvm)"

myds=AdminConfig.getid('/DataSource:TradeDataSource/')

myds=AdminConfig.getid('/DataSource:TradeDataSource/')

mydslist=AdminConfig.list('ConnectionPool',myds)

print "-->  before: "

print AdminConfig.show(mydslist)

AdminConfig.modify(myds, '[[connectionPool [[maxConnections 113]]]]')

AdminConfig.save()

#AdminConfig.modify(myds, '[[connectionPool [[minConnections 20]]]]')

#AdminConfig.save()

print "-->  after: "

mydslist=AdminConfig.list('ConnectionPool',myds)

print AdminConfig.show(mydslist)

# monitor connections at the database with the command

# watch -d -n 5 "db2 list applications | wc -l"

# or informix

# watch -d -n 5 "onstat -g ses | wc -l"

# this will include some irrelevant lines in count -- feel free to egrep them out