DB2 CPU USAGE

**Larry** · Nov 12 '05, 09:43 AM

Re: DB2 CPU USAGE

You've said nothing about your configuration, what os you are running,
what version/release/fixpack level of DB2. My advice is to open up a PMR
with IBM. This could be a host of different things ... some inside DB2
.... some not even related to DB2.

Larry Edelstein

Fabian Knopf wrote:[color=blue]
> Hi @ll,
>
> my IBM DB2 server runs with 60% Cpu Usage but no task has to be done.
> Why this ???
>
> Cu,
>
> Fabian[/color]

**Ian** · Nov 12 '05, 09:43 AM

Re: DB2 CPU USAGE

Fabian Knopf wrote:[color=blue]
> Hi @ll,
>
> my IBM DB2 server runs with 60% Cpu Usage but no task has to be done.
> Why this ???
>[/color]

What is using the CPU? Is it DB2? Something else on the server?

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

**Hardy** · Nov 12 '05, 09:43 AM

Re: DB2 CPU USAGE

you should have provided more info. to be help. as a start, you can use OS
tools to find which process occupying the CPU.

on aix, you can use
ps aux |head -1 ;ps aux |sort -rn +2 |head -10
to get the first 10 CPU threads.
on other os, I think you can also find ways to do the same thing.

"Fabian Knopf" <F.Knopf@gmx.de > ???? news:2vjdgjF2m9 u49U1@uni-berlin.de...[color=blue]
> Hi @ll,
>
> my IBM DB2 server runs with 60% Cpu Usage but no task has to be done.
> Why this ???
>
> Cu,
>
> Fabian[/color]

**Mark Yudkin** · Nov 12 '05, 09:43 AM

Re: DB2 CPU USAGE

Disable the OpenGL screensaver.

(Next time, give us some details).

"Fabian Knopf" <F.Knopf@gmx.de > wrote in message
news:2vjdgjF2m9 u49U1@uni-berlin.de...[color=blue]
> Hi @ll,
>
> my IBM DB2 server runs with 60% Cpu Usage but no task has to be done.
> Why this ???
>
> Cu,
>
> Fabian[/color]

**Fabian Knopf** · Nov 12 '05, 09:43 AM

Re: DB2 CPU USAGE

Larry wrote:[color=blue]
> You've said nothing about your configuration, what os you are running,
> what version/release/fixpack level of DB2. My advice is to open up a PMR
> with IBM. This could be a host of different things ... some inside DB2
> ... some not even related to DB2.
>
> Larry Edelstein
>
> Fabian Knopf wrote:
>[color=green]
>> Hi @ll,
>>
>> my IBM DB2 server runs with 60% Cpu Usage but no task has to be done.
>> Why this ???
>>
>> Cu,
>>
>> Fabian[/color]
>
>[/color]
Hi @ll,

sry for this lame post.

United Linux DB2 V.8.1 .

1 Xeon CPU 1 Gigs Ram

enough Space 200 Gigs.

The db2inst1 instance is feeding this cpu power.

Cu,

Fabian

**Larry** · Nov 12 '05, 09:45 AM

Re: DB2 CPU USAGE

OK ... what shows 60% cpu usage? Where in VMSTATs is it? User? System?
How do you know it's DB2? Is the 60% consistent or transient? If
transient, what is it doing the rest of the time? What happens if you
stop db2 and all the db2 processes are stopped? When DB2 is started,
what end user queries are running? What is the response to "DB2 LIST
APPLICATIONS SHOW DETAIL"?

Larry Edelstein

Fabian Knopf wrote:[color=blue]
> Larry wrote:
>[color=green]
>> You've said nothing about your configuration, what os you are running,
>> what version/release/fixpack level of DB2. My advice is to open up a
>> PMR with IBM. This could be a host of different things ... some inside
>> DB2 ... some not even related to DB2.
>>
>> Larry Edelstein
>>
>> Fabian Knopf wrote:
>>[color=darkred]
>>> Hi @ll,
>>>
>>> my IBM DB2 server runs with 60% Cpu Usage but no task has to be done.
>>> Why this ???
>>>
>>> Cu,
>>>
>>> Fabian[/color]
>>
>>
>>[/color]
> Hi @ll,
>
> sry for this lame post.
>
> United Linux DB2 V.8.1 .
>
> 1 Xeon CPU 1 Gigs Ram
>
> enough Space 200 Gigs.
>
> The db2inst1 instance is feeding this cpu power.
>
> Cu,
>
> Fabian[/color]

**Fabian Knopf** · Nov 12 '05, 09:46 AM

Re: DB2 CPU USAGE

Larry wrote:[color=blue]
> OK ... what shows 60% cpu usage? Where in VMSTATs is it? User? System?
> How do you know it's DB2? Is the 60% consistent or transient? If
> transient, what is it doing the rest of the time? What happens if you
> stop db2 and all the db2 processes are stopped? When DB2 is started,
> what end user queries are running? What is the response to "DB2 LIST
> APPLICATIONS SHOW DETAIL"?
>
> Larry Edelstein
>
> Fabian Knopf wrote:
>[color=green]
>> Larry wrote:
>>[color=darkred]
>>> You've said nothing about your configuration, what os you are
>>> running, what version/release/fixpack level of DB2. My advice is to
>>> open up a PMR with IBM. This could be a host of different things ...
>>> some inside DB2 ... some not even related to DB2.
>>>
>>> Larry Edelstein
>>>
>>> Fabian Knopf wrote:
>>>
>>>> Hi @ll,
>>>>
>>>> my IBM DB2 server runs with 60% Cpu Usage but no task has to be done.
>>>> Why this ???
>>>>
>>>> Cu,
>>>>
>>>> Fabian
>>>
>>>
>>>
>>>[/color]
>> Hi @ll,
>>
>> sry for this lame post.
>>
>> United Linux DB2 V.8.1 .
>>
>> 1 Xeon CPU 1 Gigs Ram
>>
>> enough Space 200 Gigs.
>>
>> The db2inst1 instance is feeding this cpu power.
>>
>> Cu,
>>
>> Fabian[/color]
>
>[/color]
Hi Larry,

it's the main process who takes 60% CPU Power. When i stop the main
process everything is normal again.
Here the list application show detail command output:

Auth Id Application Name Appl.
Application Id
Seq# Number of Coordinating DB Coordinator Status
Status Change Time DB Name DB Path
Handle
Agents partition number pid/thread
------------------------------ -------------------- ----------
-----------------
------------- ---- ---------- ---------------- ---------------
-----------------
------------- -------------------------- -------- --------------------
ROOT svas.exe 383
C0A86569.H505.0 0D
C88075111 0007 1 0 21103 UOW Waiting
Not Collected ARCHIV
/home/db2inst1/db2inst1/NODE00
00/SQL00002/
ROOT svas.exe 382
C0A86569.H405.0 0D
C88075109 0007 1 0 20994 UOW Waiting
Not Collected ARCHIV
/home/db2inst1/db2inst1/NODE00
00/SQL00002/
ROOT svas.exe 381
C0A86569.H305.0 0D
C88075107 0007 1 0 3541 UOW Waiting
Not Collected ARCHIV
/home/db2inst1/db2inst1/NODE00
00/SQL00002/
ROOT svas.exe 380
C0A86569.H205.0 0D
C88075105 0007 1 0 21110 UOW Waiting
Not Collected ARCHIV
/home/db2inst1/db2inst1/NODE00
00/SQL00002/
ROOT svas.exe 379
C0A86569.H105.0 0D
C88075103 0007 1 0 21397 UOW Waiting
Not Collected ARCHIV
/home/db2inst1/db2inst1/NODE00
00/SQL00002/
ROOT aqt.exe 376
C0A86569.GB05.0 1E
788074949 0006 1 0 1052 UOW Waiting
Not Collected ARCHIV
/home/db2inst1/db2inst1/NODE00
00/SQL00002/
ROOT svds 348
*LOCAL.db2inst1 .0
0F668040933 0001 1 0 21394 Connect
Completed
Not Collected ARCHIV
/home/db2inst1/db2inst1/NODE00
00/SQL00002/
ROOT svds 347
*LOCAL.db2inst1 .0
0F668040932 0001 1 0 21395 Connect
Completed
Not Collected ARCHIV
/home/db2inst1/db2inst1/NODE00
00/SQL00002/
ROOT svds 346
*LOCAL.db2inst1 .0
0F668040931 0002 1 0 21396 UOW Waiting
Not Collected ARCHIV
/home/db2inst1/db2inst1/NODE00
00/SQL00002/
ROOT svds 345
*LOCAL.db2inst1 .0
0F668040930 0002 1 0 1053 UOW Waiting
Not Collected ARCHIV
/home/db2inst1/db2inst1/NODE00
00/SQL00002/
ROOT svds 344
*LOCAL.db2inst1 .0
0F668040929 0002 1 0 20993 UOW Waiting
Not Collected ARCHIV
/home/db2inst1/db2inst1/NODE00
00/SQL00002/
ROOT svas.exe 337
C0A86569.AD04.0 09
688072551 001f 1 0 1054 UOW Waiting
Not Collected ARCHIV
/home/db2inst1/db2inst1/NODE00
00/SQL00002/
ROOT svas.exe 336
C0A86569.AC04.0 09
688072549 0003 1 0 3542 UOW Waiting
Not Collected ARCHIV
/home/db2inst1/db2inst1/NODE00
00/SQL00002/
ROOT svas.exe 335
C0A86569.AB04.0 09
688072547 0017 1 0 20992 UOW Waiting
Not Collected ARCHIV
/home/db2inst1/db2inst1/NODE00
00/SQL00002/
ROOT aqt.exe 317
C0A86577.J00C.0 C4
FC7142436 0009 1 0 21243 UOW Waiting
Not Collected ARCHIV
/home/db2inst1/db2inst1/NODE00
00/SQL00002/
DB2INST1 db2bp 1
*LOCAL.db2inst1 .0
08002094412 0001 1 0 1044 Connect
Completed
Not Collected ARCHIV
/home/db2inst1/db2inst1/NODE00
00/SQL00002/

I hope that you do something with this.

Cu,

Fabian

**Larry** · Nov 12 '05, 09:46 AM

Re: DB2 CPU USAGE

Still not really enough information.

Maybe someone from the lab can comment, but you're DB2 LIST APPLICATIONS
looks strange. Why are there DB2 applications showing up under ROOT?
I've never seen that before. svas?

Larry Edelstein

Fabian Knopf wrote:[color=blue]
> Larry wrote:
>[color=green]
>> OK ... what shows 60% cpu usage? Where in VMSTATs is it? User? System?
>> How do you know it's DB2? Is the 60% consistent or transient? If
>> transient, what is it doing the rest of the time? What happens if you
>> stop db2 and all the db2 processes are stopped? When DB2 is started,
>> what end user queries are running? What is the response to "DB2 LIST
>> APPLICATIONS SHOW DETAIL"?
>>
>> Larry Edelstein
>>
>> Fabian Knopf wrote:
>>[color=darkred]
>>> Larry wrote:
>>>
>>>> You've said nothing about your configuration, what os you are
>>>> running, what version/release/fixpack level of DB2. My advice is to
>>>> open up a PMR with IBM. This could be a host of different things ...
>>>> some inside DB2 ... some not even related to DB2.
>>>>
>>>> Larry Edelstein
>>>>
>>>> Fabian Knopf wrote:
>>>>
>>>>> Hi @ll,
>>>>>
>>>>> my IBM DB2 server runs with 60% Cpu Usage but no task has to be done.
>>>>> Why this ???
>>>>>
>>>>> Cu,
>>>>>
>>>>> Fabian
>>>>
>>>>
>>>>
>>>>
>>>>
>>> Hi @ll,
>>>
>>> sry for this lame post.
>>>
>>> United Linux DB2 V.8.1 .
>>>
>>> 1 Xeon CPU 1 Gigs Ram
>>>
>>> enough Space 200 Gigs.
>>>
>>> The db2inst1 instance is feeding this cpu power.
>>>
>>> Cu,
>>>
>>> Fabian[/color]
>>
>>
>>[/color]
> Hi Larry,
>
> it's the main process who takes 60% CPU Power. When i stop the main
> process everything is normal again.
> Here the list application show detail command output:
>
> Auth Id Application Name Appl. Application Id
> Seq# Number of Coordinating DB Coordinator Status
> Status Change Time DB Name DB Path
> Handle
> Agents partition number pid/thread
> ------------------------------ -------------------- ----------
> -----------------
> ------------- ---- ---------- ---------------- ---------------
> -----------------
> ------------- -------------------------- -------- --------------------
> ROOT svas.exe 383 C0A86569.H505.0 0D
> C88075111 0007 1 0 21103 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svas.exe 382 C0A86569.H405.0 0D
> C88075109 0007 1 0 20994 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svas.exe 381 C0A86569.H305.0 0D
> C88075107 0007 1 0 3541 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svas.exe 380 C0A86569.H205.0 0D
> C88075105 0007 1 0 21110 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svas.exe 379 C0A86569.H105.0 0D
> C88075103 0007 1 0 21397 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT aqt.exe 376 C0A86569.GB05.0 1E
> 788074949 0006 1 0 1052 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svds 348 *LOCAL.db2inst1 .0
> 0F668040933 0001 1 0 21394 Connect
> Completed
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svds 347 *LOCAL.db2inst1 .0
> 0F668040932 0001 1 0 21395 Connect
> Completed
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svds 346 *LOCAL.db2inst1 .0
> 0F668040931 0002 1 0 21396 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svds 345 *LOCAL.db2inst1 .0
> 0F668040930 0002 1 0 1053 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svds 344 *LOCAL.db2inst1 .0
> 0F668040929 0002 1 0 20993 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svas.exe 337 C0A86569.AD04.0 09
> 688072551 001f 1 0 1054 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svas.exe 336 C0A86569.AC04.0 09
> 688072549 0003 1 0 3542 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svas.exe 335 C0A86569.AB04.0 09
> 688072547 0017 1 0 20992 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT aqt.exe 317 C0A86577.J00C.0 C4
> FC7142436 0009 1 0 21243 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> DB2INST1 db2bp 1 *LOCAL.db2inst1 .0
> 08002094412 0001 1 0 1044 Connect
> Completed
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
>
> I hope that you do something with this.
>
> Cu,
>
> Fabian[/color]

**Mark Yudkin** · Nov 12 '05, 09:46 AM

Re: DB2 CPU USAGE

Still no performance info. Use the snapshot monitor to figure out what's
happening and post that.
Also, why are applications running as root? And what are these applications
(svas, svds, aqt) doing anyway?

"Fabian Knopf" <F.Knopf@gmx.de > wrote in message
news:303ag3F2ru reaU1@uni-berlin.de...[color=blue]
> Larry wrote:[color=green]
>> OK ... what shows 60% cpu usage? Where in VMSTATs is it? User? System?
>> How do you know it's DB2? Is the 60% consistent or transient? If
>> transient, what is it doing the rest of the time? What happens if you
>> stop db2 and all the db2 processes are stopped? When DB2 is started, what
>> end user queries are running? What is the response to "DB2 LIST
>> APPLICATIONS SHOW DETAIL"?
>>
>> Larry Edelstein
>>
>> Fabian Knopf wrote:
>>[color=darkred]
>>> Larry wrote:
>>>
>>>> You've said nothing about your configuration, what os you are running,
>>>> what version/release/fixpack level of DB2. My advice is to open up a
>>>> PMR with IBM. This could be a host of different things ... some inside
>>>> DB2 ... some not even related to DB2.
>>>>
>>>> Larry Edelstein
>>>>
>>>> Fabian Knopf wrote:
>>>>
>>>>> Hi @ll,
>>>>>
>>>>> my IBM DB2 server runs with 60% Cpu Usage but no task has to be done.
>>>>> Why this ???
>>>>>
>>>>> Cu,
>>>>>
>>>>> Fabian
>>>>
>>>>
>>>>
>>>>
>>> Hi @ll,
>>>
>>> sry for this lame post.
>>>
>>> United Linux DB2 V.8.1 .
>>>
>>> 1 Xeon CPU 1 Gigs Ram
>>>
>>> enough Space 200 Gigs.
>>>
>>> The db2inst1 instance is feeding this cpu power.
>>>
>>> Cu,
>>>
>>> Fabian[/color]
>>
>>[/color]
> Hi Larry,
>
> it's the main process who takes 60% CPU Power. When i stop the main
> process everything is normal again.
> Here the list application show detail command output:
>
> Auth Id Application Name Appl. Application Id
> Seq# Number of Coordinating DB Coordinator Status
> Status Change Time DB Name DB Path
> Handle
> Agents partition number pid/thread
> ------------------------------ -------------------- ----------
> -----------------
> ------------- ---- ---------- ---------------- ---------------
> -----------------
> ------------- -------------------------- -------- --------------------
> ROOT svas.exe 383 C0A86569.H505.0 0D
> C88075111 0007 1 0 21103 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svas.exe 382 C0A86569.H405.0 0D
> C88075109 0007 1 0 20994 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svas.exe 381 C0A86569.H305.0 0D
> C88075107 0007 1 0 3541 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svas.exe 380 C0A86569.H205.0 0D
> C88075105 0007 1 0 21110 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svas.exe 379 C0A86569.H105.0 0D
> C88075103 0007 1 0 21397 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT aqt.exe 376 C0A86569.GB05.0 1E
> 788074949 0006 1 0 1052 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svds 348 *LOCAL.db2inst1 .0
> 0F668040933 0001 1 0 21394 Connect
> Completed
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svds 347 *LOCAL.db2inst1 .0
> 0F668040932 0001 1 0 21395 Connect
> Completed
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svds 346 *LOCAL.db2inst1 .0
> 0F668040931 0002 1 0 21396 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svds 345 *LOCAL.db2inst1 .0
> 0F668040930 0002 1 0 1053 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svds 344 *LOCAL.db2inst1 .0
> 0F668040929 0002 1 0 20993 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svas.exe 337 C0A86569.AD04.0 09
> 688072551 001f 1 0 1054 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svas.exe 336 C0A86569.AC04.0 09
> 688072549 0003 1 0 3542 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT svas.exe 335 C0A86569.AB04.0 09
> 688072547 0017 1 0 20992 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> ROOT aqt.exe 317 C0A86577.J00C.0 C4
> FC7142436 0009 1 0 21243 UOW Waiting
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
> DB2INST1 db2bp 1 *LOCAL.db2inst1 .0
> 08002094412 0001 1 0 1044 Connect
> Completed
> Not Collected ARCHIV
> /home/db2inst1/db2inst1/NODE00
> 00/SQL00002/
>
> I hope that you do something with this.
>
> Cu,
>
> Fabian[/color]

**Fabian Knopf** · Nov 12 '05, 09:46 AM

Re: DB2 CPU USAGE

Mark Yudkin wrote:[color=blue]
> Still no performance info. Use the snapshot monitor to figure out what's
> happening and post that.
> Also, why are applications running as root? And what are these applications
> (svas, svds, aqt) doing anyway?
>
> "Fabian Knopf" <F.Knopf@gmx.de > wrote in message
> news:303ag3F2ru reaU1@uni-berlin.de...
>[color=green]
>>Larry wrote:
>>[color=darkred]
>>>OK ... what shows 60% cpu usage? Where in VMSTATs is it? User? System?
>>>How do you know it's DB2? Is the 60% consistent or transient? If
>>>transient, what is it doing the rest of the time? What happens if you
>>>stop db2 and all the db2 processes are stopped? When DB2 is started, what
>>>end user queries are running? What is the response to "DB2 LIST
>>>APPLICATIO NS SHOW DETAIL"?
>>>
>>>Larry Edelstein
>>>
>>>Fabian Knopf wrote:
>>>
>>>
>>>>Larry wrote:
>>>>
>>>>
>>>>>You've said nothing about your configuration, what os you are running,
>>>>>what version/release/fixpack level of DB2. My advice is to open up a
>>>>>PMR with IBM. This could be a host of different things ... some inside
>>>>>DB2 ... some not even related to DB2.
>>>>>
>>>>>Larry Edelstein
>>>>>
>>>>>Fabian Knopf wrote:
>>>>>
>>>>>
>>>>>>Hi @ll,
>>>>>>
>>>>>>my IBM DB2 server runs with 60% Cpu Usage but no task has to be done.
>>>>>>Why this ???
>>>>>>
>>>>>>Cu,
>>>>>>
>>>>>>Fabian
>>>>>
>>>>>
>>>>>
>>>>>
>>>>Hi @ll,
>>>>
>>>>sry for this lame post.
>>>>
>>>>United Linux DB2 V.8.1 .
>>>>
>>>>1 Xeon CPU 1 Gigs Ram
>>>>
>>>>enough Space 200 Gigs.
>>>>
>>>>The db2inst1 instance is feeding this cpu power.
>>>>
>>>>Cu,
>>>>
>>>>Fabian
>>>
>>>[/color]
>>Hi Larry,
>>
>>it's the main process who takes 60% CPU Power. When i stop the main
>>process everything is normal again.
>>Here the list application show detail command output:
>>
>>Auth Id Application Name Appl. Application Id
>> Seq# Number of Coordinating DB Coordinator Status
>> Status Change Time DB Name DB Path
>> Handle
>> Agents partition number pid/thread
>>------------------------------ -------------------- ----------
>>-----------------
>>------------- ---- ---------- ---------------- ---------------
>>-----------------
>>------------- -------------------------- -------- --------------------
>>ROOT svas.exe 383 C0A86569.H505.0 0D
>>C88075111 0007 1 0 21103 UOW Waiting
>> Not Collected ARCHIV
>>/home/db2inst1/db2inst1/NODE00
>>00/SQL00002/
>>ROOT svas.exe 382 C0A86569.H405.0 0D
>>C88075109 0007 1 0 20994 UOW Waiting
>> Not Collected ARCHIV
>>/home/db2inst1/db2inst1/NODE00
>>00/SQL00002/
>>ROOT svas.exe 381 C0A86569.H305.0 0D
>>C88075107 0007 1 0 3541 UOW Waiting
>> Not Collected ARCHIV
>>/home/db2inst1/db2inst1/NODE00
>>00/SQL00002/
>>ROOT svas.exe 380 C0A86569.H205.0 0D
>>C88075105 0007 1 0 21110 UOW Waiting
>> Not Collected ARCHIV
>>/home/db2inst1/db2inst1/NODE00
>>00/SQL00002/
>>ROOT svas.exe 379 C0A86569.H105.0 0D
>>C88075103 0007 1 0 21397 UOW Waiting
>> Not Collected ARCHIV
>>/home/db2inst1/db2inst1/NODE00
>>00/SQL00002/
>>ROOT aqt.exe 376 C0A86569.GB05.0 1E
>>788074949 0006 1 0 1052 UOW Waiting
>> Not Collected ARCHIV
>>/home/db2inst1/db2inst1/NODE00
>>00/SQL00002/
>>ROOT svds 348 *LOCAL.db2inst1 .0
>>0F668040933 0001 1 0 21394 Connect
>>Completed
>> Not Collected ARCHIV
>>/home/db2inst1/db2inst1/NODE00
>>00/SQL00002/
>>ROOT svds 347 *LOCAL.db2inst1 .0
>>0F668040932 0001 1 0 21395 Connect
>>Completed
>> Not Collected ARCHIV
>>/home/db2inst1/db2inst1/NODE00
>>00/SQL00002/
>>ROOT svds 346 *LOCAL.db2inst1 .0
>>0F668040931 0002 1 0 21396 UOW Waiting
>> Not Collected ARCHIV
>>/home/db2inst1/db2inst1/NODE00
>>00/SQL00002/
>>ROOT svds 345 *LOCAL.db2inst1 .0
>>0F668040930 0002 1 0 1053 UOW Waiting
>> Not Collected ARCHIV
>>/home/db2inst1/db2inst1/NODE00
>>00/SQL00002/
>>ROOT svds 344 *LOCAL.db2inst1 .0
>>0F668040929 0002 1 0 20993 UOW Waiting
>> Not Collected ARCHIV
>>/home/db2inst1/db2inst1/NODE00
>>00/SQL00002/
>>ROOT svas.exe 337 C0A86569.AD04.0 09
>>688072551 001f 1 0 1054 UOW Waiting
>> Not Collected ARCHIV
>>/home/db2inst1/db2inst1/NODE00
>>00/SQL00002/
>>ROOT svas.exe 336 C0A86569.AC04.0 09
>>688072549 0003 1 0 3542 UOW Waiting
>> Not Collected ARCHIV
>>/home/db2inst1/db2inst1/NODE00
>>00/SQL00002/
>>ROOT svas.exe 335 C0A86569.AB04.0 09
>>688072547 0017 1 0 20992 UOW Waiting
>> Not Collected ARCHIV
>>/home/db2inst1/db2inst1/NODE00
>>00/SQL00002/
>>ROOT aqt.exe 317 C0A86577.J00C.0 C4
>>FC7142436 0009 1 0 21243 UOW Waiting
>> Not Collected ARCHIV
>>/home/db2inst1/db2inst1/NODE00
>>00/SQL00002/
>>DB2INST1 db2bp 1 *LOCAL.db2inst1 .0
>>08002094412 0001 1 0 1044 Connect
>>Completed
>> Not Collected ARCHIV
>>/home/db2inst1/db2inst1/NODE00
>>00/SQL00002/
>>
>>I hope that you do something with this.
>>
>>Cu,
>>
>>Fabian[/color]
>
>
>[/color]
Hi svas svds aqt are my programms who connect to the db2 database. why
root i dont know who to do this in an other way.

Database Lock Snapshot

Database name = ARCHIV
Database path =
/home/db2inst1/db2inst1/NODE0000/SQL00002/
Input database alias = ARCHIV
Locks held = 0
Applications currently connected = 4
Agents currently waiting on locks = 0
Snapshot timestamp = 19/11/2004 07.07.32.141473

Application handle = 34
Application ID = C0A86569.FE06.0 0D748095715
Sequence number = 0030
Application name = svas.exe
Authorization ID = ROOT
Application status = UOW Waiting
Status change time = Not Collected
Application code page = 1208
Locks held = 0
Total wait time (ms) = 0

Application handle = 376
Application ID = C0A86569.GB05.0 1E788074949
Sequence number = 0025
Application name = aqt.exe
Authorization ID = ROOT
Application status = UOW Waiting
Status change time = Not Collected
Application code page = 1208
Locks held = 0
Total wait time (ms) = 0

Application handle = 317
Application ID = C0A86577.J00C.0 C4FC7142436
Sequence number = 0012
Application name = aqt.exe
Authorization ID = ROOT
Application status = UOW Waiting
Status change time = Not Collected
Application code page = 1208
Locks held = 0
Total wait time (ms) = 0

Application handle = 1
Application ID = *LOCAL.db2inst1 .008002094412
Sequence number = 0001
Application name = db2bp
Authorization ID = DB2INST1
Application status = Connect Completed
Status change time = Not Collected
Application code page = 923
Locks held = 0
Total wait time (ms) = 0

Hope this is now the information you want.

Cu,

Fabian

**Larry** · Nov 12 '05, 09:46 AM

Re: DB2 CPU USAGE

Fabian,

Do you have a local IBM rep? I think you're best bet is to seek that
person out and find out what options may exist for you to get some
configuration, performance/tuning assistance. That is just something
that isn't too easy to work through on an internet newsgroup.

My suggestion is that you figure out why those applications are being
connected to DB2 from ROOT. Move them to another id, or to the DB2
instance owner. I can't promise you that this is the source of your
performance problems. But it just doesn't look right compared to what
I've seen in the past.

Larry Edelstein

Fabian Knopf wrote:[color=blue]
> Mark Yudkin wrote:
>[color=green]
>> Still no performance info. Use the snapshot monitor to figure out
>> what's happening and post that.
>> Also, why are applications running as root? And what are these
>> applications (svas, svds, aqt) doing anyway?
>>
>> "Fabian Knopf" <F.Knopf@gmx.de > wrote in message
>> news:303ag3F2ru reaU1@uni-berlin.de...
>>[color=darkred]
>>> Larry wrote:
>>>
>>>> OK ... what shows 60% cpu usage? Where in VMSTATs is it? User?
>>>> System? How do you know it's DB2? Is the 60% consistent or
>>>> transient? If transient, what is it doing the rest of the time? What
>>>> happens if you stop db2 and all the db2 processes are stopped? When
>>>> DB2 is started, what end user queries are running? What is the
>>>> response to "DB2 LIST APPLICATIONS SHOW DETAIL"?
>>>>
>>>> Larry Edelstein
>>>>
>>>> Fabian Knopf wrote:
>>>>
>>>>
>>>>> Larry wrote:
>>>>>
>>>>>
>>>>>> You've said nothing about your configuration, what os you are
>>>>>> running, what version/release/fixpack level of DB2. My advice is
>>>>>> to open up a PMR with IBM. This could be a host of different
>>>>>> things ... some inside DB2 ... some not even related to DB2.
>>>>>>
>>>>>> Larry Edelstein
>>>>>>
>>>>>> Fabian Knopf wrote:
>>>>>>
>>>>>>
>>>>>>> Hi @ll,
>>>>>>>
>>>>>>> my IBM DB2 server runs with 60% Cpu Usage but no task has to be
>>>>>>> done.
>>>>>>> Why this ???
>>>>>>>
>>>>>>> Cu,
>>>>>>>
>>>>>>> Fabian
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>> Hi @ll,
>>>>>
>>>>> sry for this lame post.
>>>>>
>>>>> United Linux DB2 V.8.1 .
>>>>>
>>>>> 1 Xeon CPU 1 Gigs Ram
>>>>>
>>>>> enough Space 200 Gigs.
>>>>>
>>>>> The db2inst1 instance is feeding this cpu power.
>>>>>
>>>>> Cu,
>>>>>
>>>>> Fabian
>>>>
>>>>
>>>>
>>> Hi Larry,
>>>
>>> it's the main process who takes 60% CPU Power. When i stop the main
>>> process everything is normal again.
>>> Here the list application show detail command output:
>>>
>>> Auth Id Application Name Appl. Application Id
>>> Seq# Number of Coordinating DB Coordinator Status
>>> Status Change Time DB Name DB Path
>>> Handle
>>> Agents partition number pid/thread
>>> ------------------------------ -------------------- ----------
>>> -----------------
>>> ------------- ---- ---------- ---------------- ---------------
>>> -----------------
>>> ------------- -------------------------- -------- --------------------
>>> ROOT svas.exe 383
>>> C0A86569.H505.0 0D
>>> C88075111 0007 1 0 21103 UOW
>>> Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>> 00/SQL00002/
>>> ROOT svas.exe 382
>>> C0A86569.H405.0 0D
>>> C88075109 0007 1 0 20994 UOW
>>> Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>> 00/SQL00002/
>>> ROOT svas.exe 381
>>> C0A86569.H305.0 0D
>>> C88075107 0007 1 0 3541 UOW
>>> Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>> 00/SQL00002/
>>> ROOT svas.exe 380
>>> C0A86569.H205.0 0D
>>> C88075105 0007 1 0 21110 UOW
>>> Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>> 00/SQL00002/
>>> ROOT svas.exe 379
>>> C0A86569.H105.0 0D
>>> C88075103 0007 1 0 21397 UOW
>>> Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>> 00/SQL00002/
>>> ROOT aqt.exe 376
>>> C0A86569.GB05.0 1E
>>> 788074949 0006 1 0 1052 UOW
>>> Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>> 00/SQL00002/
>>> ROOT svds 348
>>> *LOCAL.db2inst1 .0
>>> 0F668040933 0001 1 0 21394
>>> Connect Completed
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>> 00/SQL00002/
>>> ROOT svds 347
>>> *LOCAL.db2inst1 .0
>>> 0F668040932 0001 1 0 21395
>>> Connect Completed
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>> 00/SQL00002/
>>> ROOT svds 346
>>> *LOCAL.db2inst1 .0
>>> 0F668040931 0002 1 0 21396 UOW
>>> Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>> 00/SQL00002/
>>> ROOT svds 345
>>> *LOCAL.db2inst1 .0
>>> 0F668040930 0002 1 0 1053 UOW
>>> Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>> 00/SQL00002/
>>> ROOT svds 344
>>> *LOCAL.db2inst1 .0
>>> 0F668040929 0002 1 0 20993 UOW
>>> Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>> 00/SQL00002/
>>> ROOT svas.exe 337
>>> C0A86569.AD04.0 09
>>> 688072551 001f 1 0 1054 UOW
>>> Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>> 00/SQL00002/
>>> ROOT svas.exe 336
>>> C0A86569.AC04.0 09
>>> 688072549 0003 1 0 3542 UOW
>>> Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>> 00/SQL00002/
>>> ROOT svas.exe 335
>>> C0A86569.AB04.0 09
>>> 688072547 0017 1 0 20992 UOW
>>> Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>> 00/SQL00002/
>>> ROOT aqt.exe 317
>>> C0A86577.J00C.0 C4
>>> FC7142436 0009 1 0 21243 UOW
>>> Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>> 00/SQL00002/
>>> DB2INST1 db2bp 1 *LOCAL.db2inst1 .0
>>> 08002094412 0001 1 0 1044
>>> Connect Completed
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>> 00/SQL00002/
>>>
>>> I hope that you do something with this.
>>>
>>> Cu,
>>>
>>> Fabian[/color]
>>
>>
>>
>>[/color]
> Hi svas svds aqt are my programms who connect to the db2 database. why
> root i dont know who to do this in an other way.
>
> Database Lock Snapshot
>
> Database name = ARCHIV
> Database path =
> /home/db2inst1/db2inst1/NODE0000/SQL00002/
> Input database alias = ARCHIV
> Locks held = 0
> Applications currently connected = 4
> Agents currently waiting on locks = 0
> Snapshot timestamp = 19/11/2004 07.07.32.141473
>
> Application handle = 34
> Application ID = C0A86569.FE06.0 0D748095715
> Sequence number = 0030
> Application name = svas.exe
> Authorization ID = ROOT
> Application status = UOW Waiting
> Status change time = Not Collected
> Application code page = 1208
> Locks held = 0
> Total wait time (ms) = 0
>
>
> Application handle = 376
> Application ID = C0A86569.GB05.0 1E788074949
> Sequence number = 0025
> Application name = aqt.exe
> Authorization ID = ROOT
> Application status = UOW Waiting
> Status change time = Not Collected
> Application code page = 1208
> Locks held = 0
> Total wait time (ms) = 0
>
>
> Application handle = 317
> Application ID = C0A86577.J00C.0 C4FC7142436
> Sequence number = 0012
> Application name = aqt.exe
> Authorization ID = ROOT
> Application status = UOW Waiting
> Status change time = Not Collected
> Application code page = 1208
> Locks held = 0
> Total wait time (ms) = 0
>
>
> Application handle = 1
> Application ID = *LOCAL.db2inst1 .008002094412
> Sequence number = 0001
> Application name = db2bp
> Authorization ID = DB2INST1
> Application status = Connect Completed
> Status change time = Not Collected
> Application code page = 923
> Locks held = 0
> Total wait time (ms) = 0
>
>
> Hope this is now the information you want.
>
> Cu,
>
> Fabian[/color]

**Mark Yudkin** · Nov 12 '05, 09:47 AM

Re: DB2 CPU USAGE

Unfortunately, all you're giving us is the identity of the applications that
have connected. What you have to give us is performance information.
Especially, as you're using multiple private applications.

You need to use the snapshot monitor for performance (not just locks).

Perhaps you'd be best off hiring somebody from your area to help you?

"Fabian Knopf" <F.Knopf@gmx.de > wrote in message
news:305sivF2tb bhgU1@uni-berlin.de...[color=blue]
> Mark Yudkin wrote:[color=green]
>> Still no performance info. Use the snapshot monitor to figure out what's
>> happening and post that.
>> Also, why are applications running as root? And what are these
>> applications (svas, svds, aqt) doing anyway?
>>
>> "Fabian Knopf" <F.Knopf@gmx.de > wrote in message
>> news:303ag3F2ru reaU1@uni-berlin.de...
>>[color=darkred]
>>>Larry wrote:
>>>
>>>>OK ... what shows 60% cpu usage? Where in VMSTATs is it? User? System?
>>>>How do you know it's DB2? Is the 60% consistent or transient? If
>>>>transient , what is it doing the rest of the time? What happens if you
>>>>stop db2 and all the db2 processes are stopped? When DB2 is started,
>>>>what end user queries are running? What is the response to "DB2 LIST
>>>>APPLICATION S SHOW DETAIL"?
>>>>
>>>>Larry Edelstein
>>>>
>>>>Fabian Knopf wrote:
>>>>
>>>>
>>>>>Larry wrote:
>>>>>
>>>>>
>>>>>>You've said nothing about your configuration, what os you are running,
>>>>>>what version/release/fixpack level of DB2. My advice is to open up a
>>>>>>PMR with IBM. This could be a host of different things ... some inside
>>>>>>DB2 ... some not even related to DB2.
>>>>>>
>>>>>>Larry Edelstein
>>>>>>
>>>>>>Fabian Knopf wrote:
>>>>>>
>>>>>>
>>>>>>>Hi @ll,
>>>>>>>
>>>>>>>my IBM DB2 server runs with 60% Cpu Usage but no task has to be done.
>>>>>>>Why this ???
>>>>>>>
>>>>>>>Cu,
>>>>>>>
>>>>>>>Fabian
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>Hi @ll,
>>>>>
>>>>>sry for this lame post.
>>>>>
>>>>>United Linux DB2 V.8.1 .
>>>>>
>>>>>1 Xeon CPU 1 Gigs Ram
>>>>>
>>>>>enough Space 200 Gigs.
>>>>>
>>>>>The db2inst1 instance is feeding this cpu power.
>>>>>
>>>>>Cu,
>>>>>
>>>>>Fabian
>>>>
>>>>
>>>Hi Larry,
>>>
>>>it's the main process who takes 60% CPU Power. When i stop the main
>>>process everything is normal again.
>>>Here the list application show detail command output:
>>>
>>>Auth Id Application Name Appl. Application Id
>>> Seq# Number of Coordinating DB Coordinator Status
>>> Status Change Time DB Name DB Path
>>> Handle
>>> Agents partition number pid/thread
>>>------------------------------ -------------------- ----------
>>>-----------------
>>>------------- ---- ---------- ---------------- ---------------
>>>-----------------
>>>------------- -------------------------- -------- --------------------
>>>ROOT svas.exe 383 C0A86569.H505.0 0D
>>>C88075111 0007 1 0 21103 UOW
>>>Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>>00/SQL00002/
>>>ROOT svas.exe 382 C0A86569.H405.0 0D
>>>C88075109 0007 1 0 20994 UOW
>>>Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>>00/SQL00002/
>>>ROOT svas.exe 381 C0A86569.H305.0 0D
>>>C88075107 0007 1 0 3541 UOW
>>>Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>>00/SQL00002/
>>>ROOT svas.exe 380 C0A86569.H205.0 0D
>>>C88075105 0007 1 0 21110 UOW
>>>Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>>00/SQL00002/
>>>ROOT svas.exe 379 C0A86569.H105.0 0D
>>>C88075103 0007 1 0 21397 UOW
>>>Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>>00/SQL00002/
>>>ROOT aqt.exe 376 C0A86569.GB05.0 1E
>>>788074949 0006 1 0 1052 UOW
>>>Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>>00/SQL00002/
>>>ROOT svds 348 *LOCAL.db2inst1 .0
>>>0F66804093 3 0001 1 0 21394 Connect
>>>Completed
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>>00/SQL00002/
>>>ROOT svds 347 *LOCAL.db2inst1 .0
>>>0F66804093 2 0001 1 0 21395 Connect
>>>Completed
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>>00/SQL00002/
>>>ROOT svds 346 *LOCAL.db2inst1 .0
>>>0F66804093 1 0002 1 0 21396 UOW
>>>Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>>00/SQL00002/
>>>ROOT svds 345 *LOCAL.db2inst1 .0
>>>0F66804093 0 0002 1 0 1053 UOW
>>>Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>>00/SQL00002/
>>>ROOT svds 344 *LOCAL.db2inst1 .0
>>>0F66804092 9 0002 1 0 20993 UOW
>>>Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>>00/SQL00002/
>>>ROOT svas.exe 337 C0A86569.AD04.0 09
>>>688072551 001f 1 0 1054 UOW
>>>Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>>00/SQL00002/
>>>ROOT svas.exe 336 C0A86569.AC04.0 09
>>>688072549 0003 1 0 3542 UOW
>>>Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>>00/SQL00002/
>>>ROOT svas.exe 335 C0A86569.AB04.0 09
>>>688072547 0017 1 0 20992 UOW
>>>Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>>00/SQL00002/
>>>ROOT aqt.exe 317 C0A86577.J00C.0 C4
>>>FC7142436 0009 1 0 21243 UOW
>>>Waiting
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>>00/SQL00002/
>>>DB2INST1 db2bp 1 *LOCAL.db2inst1 .0
>>>0800209441 2 0001 1 0 1044 Connect
>>>Completed
>>> Not Collected ARCHIV
>>> /home/db2inst1/db2inst1/NODE00
>>>00/SQL00002/
>>>
>>>I hope that you do something with this.
>>>
>>>Cu,
>>>
>>>Fabian[/color]
>>
>>
>>[/color]
> Hi svas svds aqt are my programms who connect to the db2 database. why
> root i dont know who to do this in an other way.
>
> Database Lock Snapshot
>
> Database name = ARCHIV
> Database path =
> /home/db2inst1/db2inst1/NODE0000/SQL00002/
> Input database alias = ARCHIV
> Locks held = 0
> Applications currently connected = 4
> Agents currently waiting on locks = 0
> Snapshot timestamp = 19/11/2004 07.07.32.141473
>
> Application handle = 34
> Application ID = C0A86569.FE06.0 0D748095715
> Sequence number = 0030
> Application name = svas.exe
> Authorization ID = ROOT
> Application status = UOW Waiting
> Status change time = Not Collected
> Application code page = 1208
> Locks held = 0
> Total wait time (ms) = 0
>
>
> Application handle = 376
> Application ID = C0A86569.GB05.0 1E788074949
> Sequence number = 0025
> Application name = aqt.exe
> Authorization ID = ROOT
> Application status = UOW Waiting
> Status change time = Not Collected
> Application code page = 1208
> Locks held = 0
> Total wait time (ms) = 0
>
>
> Application handle = 317
> Application ID = C0A86577.J00C.0 C4FC7142436
> Sequence number = 0012
> Application name = aqt.exe
> Authorization ID = ROOT
> Application status = UOW Waiting
> Status change time = Not Collected
> Application code page = 1208
> Locks held = 0
> Total wait time (ms) = 0
>
>
> Application handle = 1
> Application ID = *LOCAL.db2inst1 .008002094412
> Sequence number = 0001
> Application name = db2bp
> Authorization ID = DB2INST1
> Application status = Connect Completed
> Status change time = Not Collected
> Application code page = 923
> Locks held = 0
> Total wait time (ms) = 0
>
>
> Hope this is now the information you want.
>
> Cu,
>
> Fabian[/color]

DB2 CPU USAGE

DB2 CPU USAGE

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment