>From the DB2 UDB memory model document, I found the following info:
=============== ===============
The agent private memory set consist of the following memory pools.
Their sizes are specified in the database configuration parameters
enclosed in parenthesis:
Application Heap (applheapsz)
Sort Heap (sortheap)
Statement Heap (stmtheap)
Statistics Heap (stat_heap_sz)
Query Heap (query_heap_sz)
Java Interpreter Heap (java_heap_sz)
=============== =============== =
Since I am now using a 32bits DB2 in AIX and the agent private memory
area is limited to max 256MB, I wonder how my existing setting can be
handled by DB2:
Application Heap (applheapsz) 512 ~= 2MB
Sort Heap (sortheap) 10240 ~= 40MB
Statement Heap (stmtheap) 32767 ~= 134MB
Statistics Heap (stat_heap_sz) 20000 ~= 82MB
Query Heap (query_heap_sz) 1024 ~= 4MB
Java Interpreter Heap (java_heap_sz) 2048 ~= 8MB
Total 270 MB per agent that is larger than the limitation of the agent
private memory segment in AIX.
Actually I can have 7 concurrent applications with intra-parallel ON
that 2-4 agents are assigned to one application. How can these agents
fit into the 256MB agent private memory segment in AIX? Does db2
agents only get what it need? These settings are hard limit only?
3  3349 
On Mar 30, 11:10 am, "Woody Ling" <woodyl...@gmai l.comwrote:
From the DB2 UDB memory model document, I found the following info:
=============== ===============
The agent private memory set consist of the following memory pools.
Their sizes are specified in the database configuration parameters
enclosed in parenthesis:
Application Heap (applheapsz)
Sort Heap (sortheap)
Statement Heap (stmtheap)
Statistics Heap (stat_heap_sz)
Query Heap (query_heap_sz)
Java Interpreter Heap (java_heap_sz)
=============== =============== =
Since I am now using a 32bits DB2 in AIX and the agent private memory
area is limited to max 256MB, I wonder how my existing setting can be
handled by DB2:
Application Heap (applheapsz) 512 ~= 2MB
Sort Heap (sortheap) 10240 ~= 40MB
Statement Heap (stmtheap) 32767 ~= 134MB
Statistics Heap (stat_heap_sz) 20000 ~= 82MB
Query Heap (query_heap_sz) 1024 ~= 4MB
Java Interpreter Heap (java_heap_sz) 2048 ~= 8MB
Total 270 MB per agent that is larger than the limitation of the agent
private memory segment in AIX.
Actually I can have 7 concurrent applications with intra-parallel ON
that 2-4 agents are assigned to one application. How can these agents
fit into the 256MB agent private memory segment in AIX? Does db2
agents only get what it need? These settings are hard limit only?
Hi Woody,
These values are only hard limits - we'll only use that much memory
for each heap if and when needed. Also, some of these heaps are
mutually-exclusive - the statistics heap is only used when gathering
table statistics (i.e. the runstats command), and the statement heap
is only used when compiling/optimizing an SQL query before running it
(so, a single agent won't be using the statement heap at the same time
as the sort heap, for example).
Cheers,
Liam.
Woody Ling wrote:
Actually I can have 7 concurrent applications with intra-parallel ON
that 2-4 agents are assigned to one application. How can these agents
fit into the 256MB agent private memory segment in AIX? Does db2
agents only get what it need? These settings are hard limit only?
To add to what Liam wrote, each *agent* has its own private memory.
Parallel agents communicate with each other using the Application
Control Heap (which is allocated from the application group shared
memory segment).
On Mar 31, 11:44 am, Ian <ianb...@mobile audio.comwrote:
Woody Ling wrote:
Actually I can have 7 concurrent applications with intra-parallel ON
that 2-4 agents are assigned to one application. How can these agents
fit into the 256MB agent private memory segment in AIX? Does db2
agents only get what it need? These settings are hard limit only?
To add to what Liam wrote, each *agent* has its own private memory.
Parallel agents communicate with each other using the Application
Control Heap (which is allocated from the application group shared
memory segment).
Yes, Thank you. :) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Jim |
last post by:
I have a situation with a 6 server setup whereby merge agents
will not run if other merge agents are alreay running. Basically
we have a 5 laptop, one tower config with the tower being the
publisher. In theory we want to be able to hook a laptop up
and have it sync within, say, 5 mins. Trouble is, if agents for
the other laptops are running (trying and failing to connect because
those laptops aren't connected) then the agents for the...
|
by: Conference Secretary |
last post by:
CALL FOR PAPERS
International Conference on Intelligent Agents, Web Technologies
and Internet Commerce
http://www.ise.canberra.edu.au/conferences/iawtic05/
Jointly with
International Conference on Computational Intelligence for Modelling,
Control and Automation
|
by: Kor |
last post by:
Hi,
Does anybody understand why the technique described in
http://www.macromedia.com/devnet/server_archive/articles/css_positioning_dynamic_repositioning.html
doesnt work in Netscape 6/7 and Mozilla? I tried it out but to no
avail. I am certainly not a (javascript) programmer / DOM expert but
it seems to me it should work (see for example
http://www.quirksmode.org/dom/w3c_html.html )
|
by: Robert Bowen |
last post by:
Hello peeplez. I have an odd problem. When I put the ANSI symbol for
"less than" ("<"), the word STRONG and then the ANSI symbol for
"greater than" (">") in my web page, followed by some text, then close
the STRONG tag the same way, my text appears in bold. No problem.
When I do the same things with the corresponding HTML tags (< ,
> ) the tag is not interpreted, it is simply displayed:
<STRONG>text</STRONG>
|
by: Evan Smith |
last post by:
During a routine performance check using an event monitor, I
discovered a class of query whose performance has me baffled.
The monitor captured:
SELECT * FROM EWM_CASE fetch first 1 rows only
It took 14 seconds of CPU time to execute. After looking up the
documentation on the FETCH FIRST notation I find "Limiting the result
table to the first integer rows can improve performance. The database
| | |
by: hikums |
last post by:
On a AIX 5.2, DB2 UDB V8.2, the dbm snapshot is as below.
There are around 50 applications at any point of time, intra-parallel
turned on, oltp and reporting queries are run on the server. 8 Gigs of
RAM, what parameters are recommended for
maxagents,max_coordagents,maxcagents,maxconnections?
If you require other information, I'd be glad to post.
Thanks for the help.
|
by: shorti |
last post by:
DB2 UDB V8.2 on AIX. Is there a db2 command/function to terminate a
single idle agents from the agent pool. I could kill -9 the process
but I was wonder if there was a more graceful or appropriate way to do
this. I did not see an API call like sqleEndCtx that could
perminently remove the agent and clean up memory. Any ideas?
|
by: Steven Simpson |
last post by:
Stefan Ram wrote (in "More than one language in a page"):
Is this a new trend of user-agent writers (Microformats, and now Google)
staking claims on the @class namespace? I'm surely not the only one
disturbed by this. Somehow, an author publishing on the web, with no
control over which user agents will access his page, has to avoid
clashes with the union of all names deemed special by all those user
agents, now and in the future?
I...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
