Monthly Archives: April 2005

Treasure hunting with Websphere on AIX and DB2

not really. It is offically called performance troubleshooting which is part of my job. The following checks have been proven very useful in my PD session on WAS & DB2 application hanging. They’ve saved me lots of time. Moreover other … Continue reading

Posted in websphere | Leave a comment

use Jython for some proof of concept in JDBC

We have a slow SQL in DB2 running over 10 seconds. One of index clustering ratio is too low and can’t be easily improved without affecting other indexes. One workaround we found is to increase DB2 ‘s query optimazation level … Continue reading

Posted in jython | Leave a comment