| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Stress testing DB2 and limiting memory usage
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 again 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: xxxx://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... |
![]() |
| Viewing: Tutorialized Forums > Databases > DB2 > Stress testing DB2 and limiting memory usage |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|