473,713 Members | 2,656 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

runaway/zombie fmps slowly starving engine of resources?

aj
DB2 WSE 8.1 FP 5
Red Hat Linux AS 2.1
(LUW)

I am having ongoing issues w/ FMP processes in my DB2 server, and
thought I would ask for opinions.

My dbm cfg KEEPFENCED is set to YES, and I use several very simple
DB2 UDFS (NOT java, I thought they were the problem, and have
eliminated them). The UDFS are simple, in most cases just wrapping
DB2 built-in functions, or returning comma-delimited lists from tables.

Here's the problem: after a while (ranging from days to weeks), a
BUNCH of db2fmp processes get built up. I counted 79 the other day.
Is this normal? Once a bunch of these build up, funny stuff starts to
happen in the database, with things like:
APP_CTL_HEAP_SZ not being big enough (its 512)
sqlccipcdarihan dshake errors
maximum number of agents exceeded (then refuses new connections)
sqlerDisassocia teWithFmp errors
sqlerGetFmpThre ad errors
If I bounce the database (and therefore get rid if all the fmps),
the all the errors/symptons go away, until a bunch of fmps build
up again, and it starts all over.

My theory is that all these fmp's are not normal, and are slowly
starving the engine of resources. How many should there be?

If I kill -9 these fmp process, i get db2diag.log messages "A non-EDU
child crashed", which makes me skittish...

Here's an ps -ef example:

oltpfenc 7756 21755 0 07:35 pts/2 00:00:00 db2fmp
,0,0,0,0,1,1,1e 010,2,0,1
oltpfenc 7757 7756 0 07:35 pts/2 00:00:00 db2fmp
,0,0,0,0,1,1,1e 010,2,0,1
oltpfenc 7758 7757 0 07:35 pts/2 00:00:00 db2fmp
,0,0,0,0,1,1,1e 010,2,0,1

They always come in groups of 3, with consecutive PID's...

Any thoughts?

TIA

aj
Nov 12 '05 #1
1 2285

"aj" <ro****@mcdonal ds.com> wrote in message
news:10******** *****@news.supe rnews.com...
DB2 WSE 8.1 FP 5
Red Hat Linux AS 2.1
(LUW)

I am having ongoing issues w/ FMP processes in my DB2 server, and
thought I would ask for opinions.

My dbm cfg KEEPFENCED is set to YES, and I use several very simple
DB2 UDFS (NOT java, I thought they were the problem, and have
eliminated them). The UDFS are simple, in most cases just wrapping
DB2 built-in functions, or returning comma-delimited lists from tables.

Here's the problem: after a while (ranging from days to weeks), a
BUNCH of db2fmp processes get built up. I counted 79 the other day.
Is this normal? Once a bunch of these build up, funny stuff starts to
happen in the database, with things like:
APP_CTL_HEAP_SZ not being big enough (its 512)
sqlccipcdarihan dshake errors
maximum number of agents exceeded (then refuses new connections)
sqlerDisassocia teWithFmp errors
sqlerGetFmpThre ad errors
If I bounce the database (and therefore get rid if all the fmps),
the all the errors/symptons go away, until a bunch of fmps build
up again, and it starts all over.

My theory is that all these fmp's are not normal, and are slowly
starving the engine of resources. How many should there be?
The number of FMPs that can be active at one time when KEEPFENCED=YES is
determined by the FENCED_POOL configuration parameter:

http://publib.boulder.ibm.com/infoce...n/r0000275.htm

If FENCED_POOL is not set, the default value is MAX_COORDAGENTS .
If MAX_COORDAGENTS is not set, it defaults to the value of MAXAGENTS -
NUM_INITAGENTS.
The default value of MAXAGENTS = 200 and NUM_INITAGENTS = 0.

Tuning FENCED_POOL is probably a good idea in your environment, and you may
need to tweak APP_CTL_HEAP_SZ to work with the value that you set.
If I kill -9 these fmp process, i get db2diag.log messages "A non-EDU
child crashed", which makes me skittish...


It's only a bad thing if DB2 is trying to use the db2fmp process at the time
you kill it :)

--
Matt Emmerton
Nov 12 '05 #2

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

Similar topics

1
2446
by: David Hane | last post by:
Hi all, I would like give users the ability to experiment with complex queries but I'm worried about them creating queries that will bog down the server. Does anyone have any ideas for preventing a runaway process? I'd like to empower my users AND keep my server online :-) Thanks!
4
7734
by: A. Tillman | last post by:
We are having a really big problem with a zombie process/transaction that is blocking other processes. When looking at Lock/ProcessID under Current Activity I see a bunch of processes that are blocked by process 94 and process 94 is blocked by process -2. I assume -2 is a zombie that has an open transaction. I cannot find this process to kill and it seems that this transaction is surviving database restarts. I know which table is...
4
5430
by: Matthew Groch | last post by:
Hi all, I've got a server that handles a relatively high number of concurrent transactions (on the magnitude of 1000's per second). Client applications establish socket connections with the server. Data is sent and received over these connections using the asynchronous model. The server is currently in beta testing. Sporadically over the course of the day, I'll observe the thread count on the process (via perfmon) start climbing....
2
2287
by: John H. | last post by:
Hi all, My problem is When running a Windows application that contains a Table.SetDataSource method, the resources is not release into system after execute
4
3677
by: ctclibby | last post by:
Hi All Seem to be getting zombie sessions. /tmp/sess_ exist and are owned by daemon. I am guessing and these could come from brower crashes, networks gone down ... etc ... even from stuff that I haven't done properly. So for the big question. Can I run a cron job and delete these? Or does PHP also store stuff in another location and could cause me grief down the road? Thanks in advance!
0
3668
by: shamirza | last post by:
· When was .NET announced? Bill Gates delivered a keynote at Forum 2000, held June 22, 2000, outlining the .NET 'vision'. The July 2000 PDC had a number of sessions on .NET technology, and delegates were given CDs containing a pre-release version of the .NET framework/SDK and Visual Studio.NET. · When was the first version of .NET released? The final version of the 1.0 SDK and runtime was made publicly available around 6pm PST on...
0
1337
by: nisimura | last post by:
Hi, I noticed that when I used SocketServer.ForkingMixIn (ForkingTCPServer), there were always zombie processes around. I searched for where waitpid() is called in ForkingMixIn and found it in SocketServer.py: def process_request(self, request, client_address): """Fork a new subprocess to process the request.""" self.collect_children()
0
2609
by: buttslapper | last post by:
Hi, Recently we discovered in our production server this kind of exception : We are wondering what causes the transaction to be zombied, and why do we get a nullreferenceexception in this method ? As you will see in the call stack, at every 5 minutes (timer), we are inserting data in a transaction. In a day, we can have 2-3 occurence of this problème.
4
2558
by: db2admin | last post by:
Hello, Sometime, clients disconnect after starting sql and sql keep running in the db2 engine making it a runaway sql. is there something in DB2 which can avoid this behavior i.e. clean any agents/subagents/sqls when client is no longer connected ?
0
8794
marktang
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...
0
8701
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,...
0
9166
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9066
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,...
1
6620
isladogs
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...
0
5942
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();...
0
4713
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2509
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2101
bsmnconsultancy
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...

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.