473,323 Members | 1,547 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

agents -recommendation

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,maxconnection s?

If you require other information, I'd be glad to post.

Thanks for the help.

Database Manager Snapshot

Node type = Database Server with
local and remote clients
Instance name = db2inst1
Number of database partitions in DB2 instance = 1
Database manager status = Active

Product name = DB2 v8.1.1.72
Service level = s040914 (U498350)

Private Sort heap allocated = 0
Private Sort heap high water mark = 14400
Post threshold sorts = 0
Piped sorts requested = 189025
Piped sorts accepted = 189025

Start Database Manager timestamp = 08/24/2005
03:00:11.215364
Last reset timestamp =
Snapshot timestamp = 08/24/2005
20:46:03.522502

Remote connections to db manager = 9
Remote connections executing in db manager = 0
Local connections = 0
Local connections executing in db manager = 0
Active local databases = 2

High water mark for agents registered = 80
High water mark for agents waiting for a token = 0
Agents registered = 75
Agents waiting for a token = 0
Idle agents = 21

Committed private Memory (Bytes) = 7782400

Switch list for db partition number 0
Buffer Pool Activity Information (BUFFERPOOL) = OFF
Lock Information (LOCK) = ON 08/24/2005
10:54:24.129543
Sorting Information (SORT) = ON 08/24/2005
11:23:42.289088
SQL Statement Information (STATEMENT) = ON 08/24/2005
11:23:11.784507
Table Activity Information (TABLE) = OFF
Take Timestamp Information (TIMESTAMP) = ON 08/24/2005
13:44:09.689430
Unit of Work Information (UOW) = ON 08/24/2005
11:23:34.652421

Agents assigned from pool = 183838
Agents created from empty pool = 217
Agents stolen from another application = 272
High water mark for coordinating agents = 39
Max agents overflow = 0
Hash joins after heap threshold exceeded = 57

Total number of gateway connections = 0
Current number of gateway connections = 0
Gateway connections waiting for host reply = 0
Gateway connections waiting for client request = 0
Gateway connection pool agents stolen = 0

Node FCM information corresponds to = 0
Free FCM buffers = 1024
Free FCM buffers low water mark = 973
Free FCM message anchors = 384
Free FCM message anchors low water mark = 382
Free FCM connection entries = 384
Free FCM connection entries low water mark = 356
Free FCM request blocks = 358
Free FCM request blocks low water mark = 331
Memory usage for database manager:

Node number = 0
Memory Pool Type = FCMBP Heap
Current size (bytes) = 4456448
High water mark (bytes) = 4456448
Configured size (bytes) = 4505600

Node number = 0
Memory Pool Type = Database Monitor Heap
Current size (bytes) = 196608
High water mark (bytes) = 360448
Configured size (bytes) = 819200

Node number = 0
Memory Pool Type = Other Memory
Current size (bytes) = 2523136
High water mark (bytes) = 2539520
Configured size (bytes) = 23379968

Nov 12 '05 #1
1 2375
<hi****@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
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,maxconnection s?

If you require other information, I'd be glad to post.

Thanks for the help.

I don't have an answer to your question, but you might be better off if you
could put your OLTP and reporting database in separate instances.

Intra-parallel is not good for OLTP.
Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Steve Moyer | last post by:
The MetaMind ( http://metamind.us ) is a new kind of search engine which lets you enter links directly. You can easily extract links from files on your computer or web pages on the net. You can...
3
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...
0
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...
0
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...
1
by: db2udbgirl | last post by:
When I issue an db2 list applications on my DB2 UDB V8.2 database on AIX 5.3 I get the following o/p /home/card30/admin] > db2 list applications Auth Id Application Appl. Application Id...
5
by: thermate2 | last post by:
Here is the daily good news. ======================== It was established at the Nuremberg that simple excuse of "following the orders" will not save your skin from crimes. You must at ALL TIMES...
3
by: Woody Ling | last post by:
>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...
4
by: charlie weaver | last post by:
I work for a large insurance company, and Im looking for a way to send emails with variable data to about 5,000 agents out in the field. (Not spam, I promise.) Id like to use Access to pull info...
2
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...
4
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.