SunQuest
 
      DB2
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Tutorialized ForumsDatabasesDB2

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Tutorialized Forums Sponsor:
  #1  
Old November 15th, 2007, 10:58 AM
techiebrandon techiebrandon is offline
Registered User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Nov 2007
Posts: 1 techiebrandon User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 m 17 sec
Reputation Power: 0
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...

Reply With Quote
Reply

Viewing: Tutorialized ForumsDatabasesDB2 > Stress testing DB2 and limiting memory usage


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway