473,597 Members | 2,092 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

db2fmp

I have a problem with that the db2fmp process are hung , with truss can
I see this :

/4: nanosleep(0xFC4 CFBF8, 0xFC4CFBF0) = 0
/4: semop(1441803, 0xFC4CFC78, 1) Err#11 EAGAIN
/4: nanosleep(0xFC4 CFBF8, 0xFC4CFBF0) = 0
/4: semop(1441803, 0xFC4CFC78, 1) Err#11 EAGAIN
/4: nanosleep(0xFC4 CFBF8, 0xFC4CFBF0) = 0
etc ...

Our application runs java stored procedures which are called
concurrently and this seems to cause problem for the db2fmp process
because after a while the application doesn't respond.

My first thought was that there wasn't enough db2fmp's so I changed
NUM_INITFENCED and
FENCED_POOL but the problem perisist.
Current values in dbm cfg are :
Keep fenced process (KEEPFENCED) = YES
Number of pooled fenced processes (FENCED_POOL) =
MAX_COORDAGENTS
Initial number of fenced processes (NUM_INITFENCED ) = 2
Max number of existing agents (MAXAGENTS) = 200
Max number of coordinating agents (MAX_COORDAGENT S) = MAXAGENTS
..
db2fmp for java , is it one for each connection or ?
/Roger

Sep 5 '06 #1
1 6157
ka******@hotmai l.com wrote:
I have a problem with that the db2fmp process are hung , with truss can
I see this :

/4: nanosleep(0xFC4 CFBF8, 0xFC4CFBF0) = 0
/4: semop(1441803, 0xFC4CFC78, 1) Err#11 EAGAIN
/4: nanosleep(0xFC4 CFBF8, 0xFC4CFBF0) = 0
/4: semop(1441803, 0xFC4CFC78, 1) Err#11 EAGAIN
/4: nanosleep(0xFC4 CFBF8, 0xFC4CFBF0) = 0
etc ...

Our application runs java stored procedures which are called
concurrently and this seems to cause problem for the db2fmp process
because after a while the application doesn't respond.

My first thought was that there wasn't enough db2fmp's so I changed
NUM_INITFENCED and
FENCED_POOL but the problem perisist.
Current values in dbm cfg are :
Keep fenced process (KEEPFENCED) = YES
Number of pooled fenced processes (FENCED_POOL) =
MAX_COORDAGENTS
Initial number of fenced processes (NUM_INITFENCED ) = 2
Max number of existing agents (MAXAGENTS) = 200
Max number of coordinating agents (MAX_COORDAGENT S) = MAXAGENTS
.
db2fmp for java , is it one for each connection or ?
/Roger
Are these db2fmp (C) or db2fmp (Java) processes?
(& use ps -ef |grep db2fmp to check parent PID)

We have an open problem with db2fmp (C) dying (orphans) now on AIX.
(db2 8.1 FP10 on AIX 5.3.0-TL05, 32bit DB2, 64bit AIX, 32bit Java 1.4)

dbx shows:

(dbx) th
thread state-k state-u ..function
$t1 wait blocked $PTRGL
$t2 run blocked _global_lock_co mmon
$t3 zombie terminated sqloAppWaitOnTh read
$t4 zombie terminated sqloAppWaitOnTh read
$t5 zombie terminated sqloAppWaitOnTh read

(dbx) where
pth_spinlock._g lobal_lock_comm on(??, ??, ??) at 0xd0110420
rec_mutex._rec_ mutex_lock(??) at 0xd0335b24
cuexit.unatexit (??) at 0xd034909c
....dlclose at 0xd03ee180

According to DB2 support, this is a known problem in AIX,
when multiple terminating threads call dlclose() and exit().
AIX-team is undecided whether to do a design change in locking,
or go the Doc-APAR route and ignore it. In DB2-land they are
preparing IY87538 to avoid the problem, regardless of AIX direction.
(targeted to ship with FP14 if testing goes well).

There are also several recent APARS for db2fmp (Java) problems.
Can you divulge your OS & DB2 levels, and if you see any relevant
error messages in the db2diag.log ??

Eric
Sep 5 '06 #2

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

Similar topics

8
3634
by: Rob S | last post by:
I have UDB 8.1 Personal Edition installed. I'm using Development centre to develop JAVA Stored Procedues. I am unable to debug them. I have installed IBM Distributed Debugger and have set DB2ROUTINE_DEBUG=ON. I installed Distributed Debugger after UDB. The Procs will build with debug but no debugger window appears when run in debug mode. I followed the instructions that came with Debugger regarding the installation directory etc.
2
7757
by: aj | last post by:
Red Hat Linus AS 2.1 DB2 WSE 8.1 FP5 I am using the following JVM for my java UDF's: java version "1.3.1" Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1) Classic VM (build 1.3.1, J2RE 1.3.1 IBM build cxia32131-20020302 (JIT enabled: jitc))
2
30327
by: Toralf Kirsten | last post by:
Hi, we use DB2 8.1 EEE on a Linux server. Currently, there is a long run'ner process in the task list which occupies one processor to 99%. The proces user is db2fenc and the command is db2fmp. Does anybody knows, what does it means and how I can terminate the process (or should I kill it)? Thanks, Toralf
3
6298
by: ChrisWinterscheid | last post by:
We are running DB2 8.1 on AIX 5.2. DB2level shows: DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08016" with level identifier "02070106". Informational tokens are "DB2 v8.1.1.56", "s040616", "U497635", and FixPak "6". Product is installed at "/usr/opt/db2_08_01".
4
2231
by: Janick Bernet | last post by:
After updating to FP10, everytime i want to execute a stored procedure it gives me an error "Java or .NET interpreter startup or communication failed". In the db2diag.log there is an info just bevore the error saing that it attempts loading "libjvm.so" and also there is something about an SQL08023 which I could not find any information about. Anyone had similar problems? Would appreciate any help/tips which could lead to a solution.
1
2522
by: Lennart | last post by:
Is it possible to figure out which db a db2fmt process is running against? If so, how? Thanx /Lennart
2
3452
by: db2admin | last post by:
Hi, I have db2 database at V8 + FP 12 and i saw db2fmp process running at 80% cpu I have health monitor turned off and automatic maintainence turned off as well what could be the reason for this ?
0
3458
by: p.thorn.ru | last post by:
Hello, I am running db2 express-c 9.5 under linux (fedora 7), and my error log frequently shows messages like these: 2008-01-08-18.30.01.952964+180 I651334G1048 LEVEL: Error (OS) PID : 2639 TID : 45063056 PROC : db2fmp ( INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 Common, OSSe, ossGetDiskInfo, probe:140 MESSAGE : ECF=0x90000017=-1879048169=ECF_FILE_PATH_ACCESS_DENIED
0
2184
by: Lew | last post by:
Hi, Is there a way to determine what procedure is currently executing in a particular db2fmp process. I have one that is consuming a large amount of cpu and would like to no what it is running. Lew
0
7962
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
7884
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
8267
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8380
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
8024
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,...
0
8258
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
5844
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
3880
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...
0
3921
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

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.