Archive for November, 2009

How to collect jcc trace in WebSphere to troubleshoot SQL

Sunday, November 29th, 2009

In WebSphere (should be similar in other app server), follow listed steps to enable jcc tracing:          1.    Select the data source that uses the Universal Driver from the WebSphere administrative console.           2.    Click Custom Properties on the data source configuration screen.           3.    Enter value -1 (TRACE_ALL) for the ...

Generate heap dumps for IBM WebSphere

Friday, November 20th, 2009

Generate heap dumps for IBM WebSphere You can always generate JVM heap dumps manually by setting the following environment variables in the shell in where a JVM starts. IBM_HEAPDUMP=true    heap dump in .phd format used for newer memory tools IBM_JAVA_HEAPDUMP_TEXT=true    classic heap dump format for older ...

Running iozone on AIX with CPU Affinity

Monday, November 16th, 2009

You can leverage more CPUs to run iozone on a SMP machine with thefollowing instructions:The -P option of iozone sets the processor that will be used for the test.The & at the end of the command detaches the process so all the commands will run at the sametime.The -f option ...

Getting iozone to work on AIX 6.1

Tuesday, November 10th, 2009

Take the following steps to make IOZone (IO test tool) to work on AIX 6.11) Install and setup the build treerpm -ivv iozone-3.291-1.src.rpm2) Soft link xlc, IBM xlc must be installed (use lslpp to check)ln -s /usr/vac/bin/cc /usr/bin/cc3) Execute the buildcd /opt/freeware/src/packages/SPECSrpm -ba iozone-3-291-1.spec4) Execute the newly created install rpm ...