DB2 Stress Testing

[techiebrandon]

I have been put in charge of running stress tests to monitor DB2's memory usage. I have never had to do stress testing myself and am fairly new to the area, so I am in foreign territory. I have found Jmeter to work with and have successfully connected and can run about 10k requests from one of my lab machines against DB2 located on another lab machine. I am using a simple SELECT * FROM <table_name> statement for each request. I am currently working under WinSrv2k3 and would like to monitor my memory usage of DB2 during the tests. I have found that the task/perf manager isn't much help, or I don't know how to read it, as it does not change much physical memory usage but the page file usage skyrockets when I start testing. I have found Microsoft's PerfWiz and have been working with that but I am still not sure I am getting accurate readings since the amount of "Available KBytes" for Memory never seems to change despite modifications to scale. So I have a number of questions...

Does DB2 have a resource to indicate it's current/peak memory usage?
Is there a better way to judge the memory usage? formula to use?
Is DB2 not using much memory because I continue to throw the same query at it?


I am ultimately testing a script I am trying to use to limit the memory usage of DB2 in order to be in line with the 4Gig limitation expressed at this link:

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.uprun.doc/doc/t0008099.htm

My current script is:

------Change_mem_usage.bat---------------------------
echo Preparing to change DB2 Express memory limitation"
CONNECT TO <db_name>
UPDATE DATABASE CONFIGURATION using DATABASE_MEMORY 250000 IMMEDIATE
AUTOCONFIGURE USING MEM_PERCENT 33 APPLY DB AND DBM
CONNECT RESET
echo Completing the change of DB2 Express memory limitation;
QUIT
--------------------------------------------------------------------
I am using 250000 since I want to use 1 Gig of Memory (instead of 4 Gig, 1000000, as used in the link) and I am working on a 3 Gig machine...so 1 Gig is 33% of 3Gigs. Any thoughts on the script are welcome also...