Performance Tuning der Datasources per Script

Da die Konfiguration der Datasources in der ISC recht zeitaufwendig ist nutze ich hierzu seit langem Scripts.

Die gesetzten Werte entsprechen dem IBM Connections V4 Performance Guide und können nach Bedarf angepasst werden.

Ausgeführt werden die Scripte über wsadmin:

/opt/ibm/WebSphere/AppServer/profiles/Dmgr/bin/wsadmin.sh -lang jython -f xxx

DB2:

t1=AdminConfig.getid('/DataSource:activities/')
AdminConfig.modify(t1,'[[statementCacheSize "100"]]')
AdminConfig.modify(t1, '[[connectionPool [[minConnections "1"][maxConnections "50"]]]]')
AdminConfig.save()
t1=AdminConfig.getid('/DataSource:blogs/')
AdminConfig.modify(t1,'[[statementCacheSize "100"]]')
AdminConfig.modify(t1, '[[connectionPool [[minConnections "1"][maxConnections "250"]]]]')
AdminConfig.save()
t1=AdminConfig.getid('/DataSource:communities/')
AdminConfig.modify(t1,'[[statementCacheSize "100"]]')
AdminConfig.modify(t1, '[[connectionPool [[minConnections "10"][maxConnections "200"]]]]')
AdminConfig.save()
t1=AdminConfig.getid('/DataSource:dogear/')
AdminConfig.modify(t1,'[[statementCacheSize "100"]]')
AdminConfig.modify(t1, '[[connectionPool [[minConnections "1"][maxConnections "150"]]]]')
AdminConfig.save()
t1=AdminConfig.getid('/DataSource:files/')
AdminConfig.modify(t1,'[[statementCacheSize "100"]]')
AdminConfig.modify(t1, '[[connectionPool [[minConnections "10"][maxConnections "100"]]]]')
AdminConfig.save()
t1=AdminConfig.getid('/DataSource:forum/')
AdminConfig.modify(t1,'[[statementCacheSize "100"]]')
AdminConfig.modify(t1, '[[connectionPool [[minConnections "50"][maxConnections "100"]]]]')
AdminConfig.save()
t1=AdminConfig.getid('/DataSource:homepage/')
AdminConfig.modify(t1,'[[statementCacheSize "100"]]')
AdminConfig.modify(t1, '[[connectionPool [[minConnections "20"][maxConnections "100"]]]]')
AdminConfig.save()
t1=AdminConfig.getid('/DataSource:metrics/')
AdminConfig.modify(t1,'[[statementCacheSize "100"]]')
AdminConfig.modify(t1, '[[connectionPool [[minConnections "1"][maxConnections "75"]]]]')
AdminConfig.save()
t1=AdminConfig.getid('/DataSource:mobile/')
AdminConfig.modify(t1,'[[statementCacheSize "100"]]')
AdminConfig.modify(t1, '[[connectionPool [[minConnections "1"][maxConnections "100"]]]]')
AdminConfig.save()
t1=AdminConfig.getid('/DataSource:news/')
AdminConfig.modify(t1,'[[statementCacheSize "100"]]')
AdminConfig.modify(t1, '[[connectionPool [[minConnections "50"][maxConnections "75"]]]]')
AdminConfig.save()
t1=AdminConfig.getid('/DataSource:profiles/')
AdminConfig.modify(t1,'[[statementCacheSize "100"]]')
AdminConfig.modify(t1, '[[connectionPool [[minConnections "1"][maxConnections "100"]]]]')
AdminConfig.save()
t1=AdminConfig.getid('/DataSource:search/')
AdminConfig.modify(t1,'[[statementCacheSize "100"]]')
AdminConfig.modify(t1, '[[connectionPool [[minConnections "50"][maxConnections "75"]]]]')
AdminConfig.save()
t1=AdminConfig.getid('/DataSource:wikis/')
AdminConfig.modify(t1,'[[statementCacheSize "100"]]')
AdminConfig.modify(t1, '[[connectionPool [[minConnections "1"][maxConnections "100"]]]]')
AdminConfig.save()

Oracle:

t1=AdminConfig.getid('/DataSource:activities/') AdminConfig.modify(t1,'[[statementCacheSize "50"]]') AdminConfig.modify(t1, '[[connectionPool [[minConnections "100"][maxConnections "100"]]]]') AdminConfig.save() t1=AdminConfig.getid('/DataSource:blogs/') AdminConfig.modify(t1,'[[statementCacheSize "50"]]') AdminConfig.modify(t1, '[[connectionPool [[minConnections "50"][maxConnections "100"]]]]') AdminConfig.save() t1=AdminConfig.getid('/DataSource:communities/') AdminConfig.modify(t1,'[[statementCacheSize "50"]]') AdminConfig.modify(t1, '[[connectionPool [[minConnections "50"][maxConnections "100"]]]]') AdminConfig.save() t1=AdminConfig.getid('/DataSource:dogear/') AdminConfig.modify(t1,'[[statementCacheSize "50"]]') AdminConfig.modify(t1, '[[connectionPool [[minConnections "50"][maxConnections "100"]]]]') AdminConfig.save() t1=AdminConfig.getid('/DataSource:files/') AdminConfig.modify(t1,'[[statementCacheSize "50"]]') AdminConfig.modify(t1, '[[connectionPool [[minConnections "50"][maxConnections "100"]]]]') AdminConfig.save() t1=AdminConfig.getid('/DataSource:forum/') AdminConfig.modify(t1,'[[statementCacheSize "50"]]') AdminConfig.modify(t1, '[[connectionPool [[minConnections "50"][maxConnections "100"]]]]') AdminConfig.save() t1=AdminConfig.getid('/DataSource:homepage/') AdminConfig.modify(t1,'[[statementCacheSize "50"]]') AdminConfig.modify(t1, '[[connectionPool [[minConnections "50"][maxConnections "100"]]]]') AdminConfig.save() t1=AdminConfig.getid('/DataSource:metrics/') AdminConfig.modify(t1,'[[statementCacheSize "50"]]') AdminConfig.modify(t1, '[[connectionPool [[minConnections "50"][maxConnections "100"]]]]') AdminConfig.save() t1=AdminConfig.getid('/DataSource:mobile/') AdminConfig.modify(t1,'[[statementCacheSize "50"]]') AdminConfig.modify(t1, '[[connectionPool [[minConnections "50"][maxConnections "100"]]]]') AdminConfig.save() t1=AdminConfig.getid('/DataSource:news/') AdminConfig.modify(t1,'[[statementCacheSize "50"]]') AdminConfig.modify(t1, '[[connectionPool [[minConnections "50"][maxConnections "100"]]]]') AdminConfig.save() t1=AdminConfig.getid('/DataSource:profiles/') AdminConfig.modify(t1,'[[statementCacheSize "50"]]') AdminConfig.modify(t1, '[[connectionPool [[minConnections "50"][maxConnections "100"]]]]') AdminConfig.save() t1=AdminConfig.getid('/DataSource:search/') AdminConfig.modify(t1,'[[statementCacheSize "50"]]') AdminConfig.modify(t1, '[[connectionPool [[minConnections "50"][maxConnections "100"]]]]') AdminConfig.save() t1=AdminConfig.getid('/DataSource:wikis/') AdminConfig.modify(t1,'[[statementCacheSize "50"]]') AdminConfig.modify(t1, '[[connectionPool [[minConnections "50"][maxConnections "100"]]]]') AdminConfig.save()

Leave a Reply

Your email address will not be published. Required fields are marked *