Who's using DB2?

[Tony]

Hi All,

I have DB2 v8 server installed in Solaris9. The instance db2inst1 is a
server instance and as a client to connect to the other remote
server.

Today I notice 2 DB2 processes(db2fm) are using 50% CPU resource, how
can I know who is using the DB2?

Thanks a lot.

[Phil Sherman]

from a db2inst1 command window try:
db2 list applications

Phil Sherman
Tony wrote:

Hi All,

I have DB2 v8 server installed in Solaris9. The instance db2inst1 is a
server instance and as a client to connect to the other remote
server.

Today I notice 2 DB2 processes(db2fm) are using 50% CPU resource, how
can I know who is using the DB2?

Thanks a lot.

[Tony]

On Feb 7, 10:27 am, Phil Sherman <[e-mail]:

from a db2inst1 command window try:
db2 list applications

Phil Sherman

Thanks Phil for your reply. I run the command and it shows the
message :" SQL1032N No start database manager command was issued.
SQLSTATE=57019"

I stoped the instance(db2stop) and the processes(db2fm) still use 50%
CPU. So I think some applications maight be using the client to
connect to the other DB2 server.

But my questions now are, why the DB2 client can using so much CPU
resources? how can I know who is using the client or which
applications are using the client?

[Serge Rielau]

Tony wrote:

On Feb 7, 10:27 am, Phil Sherman <[e-mail]:

>from a db2inst1 command window try:
db2 list applications

Phil Sherman

Thanks Phil for your reply. I run the command and it shows the
message :" SQL1032N No start database manager command was issued.
SQLSTATE=57019"

I stoped the instance(db2stop) and the processes(db2fm) still use 50%
CPU. So I think some applications maight be using the client to
connect to the other DB2 server.

But my questions now are, why the DB2 client can using so much CPU
resources? how can I know who is using the client or which
applications are using the client?

Whenever I see "round" CPU numbers I suspect runaway processes. I
suppose this is a 2-way or 4 way box? If DB2 isn't even started then
it's an open and shut case force them off.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Tony]

On Feb 7, 11:00 am, Serge Rielau <[e-mail]:

Tony wrote:

On Feb 7, 10:27 am, Phil Sherman <[e-mail]:

from a db2inst1 command window try:
db2 list applications

Phil Sherman

Thanks Phil for your reply. I run the command and it shows the
message :" SQL1032N No start database manager command was issued.
SQLSTATE=57019"

I stoped the instance(db2stop) and the processes(db2fm) still use 50%
CPU. So I think some applications maight be using the client to
connect to the other DB2 server.

But my questions now are, why the DB2 client can using so much CPU
resources? how can I know who is using the client or which
applications are using the client?

Whenever I see "round" CPU numbers I suspect runaway processes. I
suppose this is a 2-way or 4 way box? If DB2 isn't even started then
it's an open and shut case force them off.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab- Hide quoted text -

- Show quoted text -

Hi Serge,

I know what's the meaning of " 2-way or 4 way box". Do you mean I just
kill the 2 processes?

Thanks.

[Tony]

Oh, please help!

After I kill the 2 db2fm processes, I restart the instance(db2start).
After a while, the db2fm comes back again, using 25% CPU.

Why and how can I prevent this happened?

Thank you very much!

[Tony]

On Feb 7, 11:40 am, "Tony" <[e-mail]:

Oh, please help!

After I kill the 2 db2fm processes, I restart the instance(db2start).
After a while, the db2fm comes back again, using 25% CPU.

Why and how can I prevent this happened?

Thank you very much!

OK, I found the reason. It's DB2's bug which the db2fm caused this
problem.

[sjaikumar]

On Feb 7, 11:14 am, "Tony" <[e-mail]:

On Feb 7, 11:40 am, "Tony" <[e-mail]:

Oh, please help!

After I kill the 2 db2fm processes, I restart the instance(db2start).
After a while, the db2fm comes back again, using 25% CPU.

Why and how can I prevent this happened?

Thank you very much!

OK, I found the reason. It's DB2's bug which the db2fm caused this
problem.

db2fm is a fault-monitor process to improve the availiablity on non-
clustered environment. It should be turned off in HACMP environment.
DB2 daemon process will restart it if it terminates abnormally. The
settings can be changed using db2fm command.

Jai

[aj]

sj*******@gmail.com wrote:

On Feb 7, 11:14 am, "Tony" <[e-mail]:

>On Feb 7, 11:40 am, "Tony" <[e-mail]:

>>Oh, please help!
After I kill the 2 db2fm processes, I restart the instance(db2start).
After a while, the db2fm comes back again, using 25% CPU.
Why and how can I prevent this happened?
Thank you very much!

OK, I found the reason. It's DB2's bug which the db2fm caused this
problem.

db2fm is a fault-monitor process to improve the availiablity on non-
clustered environment. It should be turned off in HACMP environment.
DB2 daemon process will restart it if it terminates abnormally. The
settings can be changed using db2fm command.
Jai

Can you be a bit more specific about what db2fm does? I know that DB2
daemon process will restart it if it terminates abnormally, but what
exactly does db2fm itself do?

I have DB2 LUW 8.2 FP14.

If my instance crashes, will db2fm restart it? What does it monitor?
What will it restart? What faults does it monitor?

TIA

aj

[sjaikumar]

On Feb 7, 2:27 pm, aj <[e-mail]:

[e-mail] wrote:

On Feb 7, 11:14 am, "Tony" <[e-mail]:

On Feb 7, 11:40 am, "Tony" <[e-mail]:

>Oh, please help!
After I kill the 2 db2fm processes, I restart the instance(db2start).
After a while, the db2fm comes back again, using 25% CPU.
Why and how can I prevent this happened?
Thank you very much!
OK, I found the reason. It's DB2's bug which the db2fm caused this
problem.

db2fm is a fault-monitor process to improve the availiablity on non-
clustered environment. It should be turned off in HACMP environment.
DB2 daemon process will restart it if it terminates abnormally. The
settings can be changed using db2fm command.
Jai

Can you be a bit more specific about what db2fm does? I know that DB2
daemon process will restart it if it terminates abnormally, but what
exactly does db2fm itself do?

I have DB2 LUW 8.2 FP14.

If my instance crashes, will db2fm restart it? What does it monitor?
What will it restart? What faults does it monitor?

TIA

aj- Hide quoted text -

- Show quoted text -

Yes, if DB2 instance exists prematurely, the fault monitor will
restart it. Read this tutorial for details.

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

Jai

[Tony]

On Feb 7, 2:27 pm, [e-mail] wrote:

On Feb 7, 11:14 am, "Tony" <[e-mail]:

On Feb 7, 11:40 am, "Tony" <[e-mail]:

Oh, please help!

After I kill the 2 db2fm processes, I restart the instance(db2start).
After a while, the db2fm comes back again, using 25% CPU.

Why and how can I prevent this happened?

Thank you very much!

OK, I found the reason. It's DB2's bug which the db2fm caused this
problem.

db2fm is a fault-monitor process to improve the availiablity on non-
clustered environment. It should be turned off in HACMP environment.
DB2 daemon process will restart it if it terminates abnormally. The
settings can be changed using db2fm command.

Jai

The db2fm command doesn't work. No matter I used "db2fm -f off" or
"db2fm -K", when I restart instance, the db2fm process runs
automaticly.

[sjaikumar]

On Feb 7, 3:41 pm, "Tony" <[e-mail]:

On Feb 7, 2:27 pm, [e-mail] wrote:

On Feb 7, 11:14 am, "Tony" <[e-mail]:

On Feb 7, 11:40 am, "Tony" <[e-mail]:

Oh, please help!

After I kill the 2 db2fm processes, I restart the instance(db2start).
After a while, the db2fm comes back again, using 25% CPU.

Why and how can I prevent this happened?

Thank you very much!

OK, I found the reason. It's DB2's bug which the db2fm caused this
problem.

db2fm is a fault-monitor process to improve the availiablity on non-
clustered environment. It should be turned off in HACMP environment.
DB2 daemon process will restart it if it terminates abnormally. The
settings can be changed using db2fm command.

Jai

The db2fm command doesn't work. No matter I used "db2fm -f off" or
"db2fm -K", when I restart instance, the db2fm process runs
automaticly.- Hide quoted text -

- Show quoted text -

try this..

db2fm -i <db2instance_name-f no

Jai