By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

DB2 100% CPU Utilization

P: n/a
I am running a standalone PC (DELL 1,73MHz with 504 MB of RAM) using
Windows XPP Service Pack 2 and BD2 version 8.1 (the freeware
version!).
Right after start of the PC the process db2dasrrm.exe takes all CPU
time. This makes the system extremely slow; to start the Control
Center takes several minutes. Exploring the database, e.g. to open the
table view gives the error SQL 1032N, "No start command of the
database has been given". SQLSTATE=57019. If I try to start the
database I get the error "A Communication problem has occurred at the
DB2 administration server" If I try to start the communication server
by issuing the command C:\DBADMIN START I get "DB2 administration
server is already active"
The system has been used for several months with no problem, this
problem occurred last week.
I would appreciate any suggestion on how to solve this problem.

Note: The message text is translated from Swedish and may not
correspond exactly with the messages on a DB2 server using English.

Feb 1 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
<ma**************@foi.sewrote in message
news:11**********************@p10g2000cwp.googlegr oups.com...
>I am running a standalone PC (DELL 1,73MHz with 504 MB of RAM) using
Windows XPP Service Pack 2 and BD2 version 8.1 (the freeware
version!).
Right after start of the PC the process db2dasrrm.exe takes all CPU
time. This makes the system extremely slow; to start the Control
Center takes several minutes. Exploring the database, e.g. to open the
table view gives the error SQL 1032N, "No start command of the
database has been given". SQLSTATE=57019. If I try to start the
database I get the error "A Communication problem has occurred at the
DB2 administration server" If I try to start the communication server
by issuing the command C:\DBADMIN START I get "DB2 administration
server is already active"
The system has been used for several months with no problem, this
problem occurred last week.
I would appreciate any suggestion on how to solve this problem.

Note: The message text is translated from Swedish and may not
correspond exactly with the messages on a DB2 server using English.
Please do a db2level and post the results.

I don't know what you mean by freeware version, unless you are talking about
DB2 Express-C, but that was first released as release 8.2.

If you have the "try and buy" 8.1 FP 0, then you either need to get DB2
Express-C, or install FP14 on top of your existing try and buy.
Feb 1 '07 #2

P: n/a
On 1 Feb, 19:46, "Mark A" <nob...@nowhere.comwrote:
<matts.gustavs...@foi.sewrote in message

news:11**********************@p10g2000cwp.googlegr oups.com...


I am running a standalone PC (DELL 1,73MHz with 504 MB of RAM) using
Windows XPP Service Pack 2 and BD2 version 8.1 (the freeware
version!).
Right after start of the PC the process db2dasrrm.exe takes all CPU
time. This makes the system extremely slow; to start the Control
Center takes several minutes. Exploring the database, e.g. to open the
table view gives the error SQL 1032N, "No start command of the
database has been given". SQLSTATE=57019. If I try to start the
database I get the error "A Communication problem has occurred at the
DB2 administration server" If I try to start the communication server
by issuing the command C:\DBADMIN START I get "DB2 administration
server is already active"
The system has been used for several months with no problem, this
problem occurred last week.
I would appreciate any suggestion on how to solve this problem.
Note: The message text is translated from Swedish and may not
correspond exactly with the messages on a DB2 server using English.

Please do a db2level and post the results.

I don't know what you mean by freeware version, unless you are talking about
DB2 Express-C, but that was first released as release 8.2.

If you have the "try and buy" 8.1 FP 0, then you either need to get DB2
Express-C, or install FP14 on top of your existing try and buy.- Dölj citerad text -

- Visa citerad text -
The result from db2level is:
DB21085I Instance "DB2" uses "32" bits and DB2 code release
"SQL08024" with
level identifier "03050106".
Informational tokens are "DB2 v8.1.11.973", "s060120", "WR21365", and
FixPak
"11".
Product is installed at "C:\PROGRAM\IBM\SQLLIB".

I have donwloaded DB2 from a IBM site.

/Matts
Feb 2 '07 #3

P: n/a
On 2 Feb, 17:49, matts.gustavs...@foi.se wrote:
On 1 Feb, 19:46, "Mark A" <nob...@nowhere.comwrote:


<matts.gustavs...@foi.sewrote in message
news:11**********************@p10g2000cwp.googlegr oups.com...
>I am running a standalone PC (DELL 1,73MHz with 504 MB of RAM) using
Windows XPP Service Pack 2 and BD2 version 8.1 (the freeware
version!).
Right after start of the PC the process db2dasrrm.exe takes allCPU
time. This makes the system extremely slow; to start the Control
Center takes several minutes. Exploring the database, e.g. to open the
table view gives the error SQL 1032N, "No start command of the
database has been given". SQLSTATE=57019. If I try to start the
database I get the error "A Communication problem has occurred at the
>DB2administration server" If I try to start the communication server
by issuing the command C:\DBADMIN START I get "DB2administration
server is already active"
The system has been used for several months with no problem, this
problem occurred last week.
I would appreciate any suggestion on how to solve this problem.
Note: The message text is translated from Swedish and may not
correspond exactly with the messages on aDB2server using English.
Please do a db2level and post the results.
I don't know what you mean by freeware version, unless you are talking about
DB2Express-C, but that was first released as release 8.2.
If you have the "try and buy" 8.1 FP 0, then you either need to getDB2
Express-C, or install FP14 on top of your existing try and buy.- Döljciterad text -
- Visa citerad text -

The result from db2level is:
DB21085I Instance "DB2" uses "32" bits andDB2code release
"SQL08024" with
level identifier "03050106".
Informational tokens are "DB2v8.1.11.973", "s060120", "WR21365", and
FixPak
"11".
Product is installed at "C:\PROGRAM\IBM\SQLLIB".

I have donwloadedDB2from a IBM site.

/Matts- Dölj citerad text -

- Visa citerad text -
I have now installed FP14 and the result from DB2LEVEL is

DB21085I Instance "DB2" uses "32" bits and DB2 code release
"SQL08027" with
level identifier "03080106".
Informational tokens are "DB2 v8.1.14.292", "s061108", "WR21377", and
FixPak
"14".
Product is installed at "C:\PROGRA~1\IBM\SQLLIB".

The process db2dasrrm.exe still takes all availalble CPU time! However
I can access the database now but the system is slow!
/Matts

Feb 20 '07 #4

P: n/a
On 20 Feb, 08:40, matts.gustavs...@foi.se wrote:
On 2 Feb, 17:49,matts.gustavs...@foi.se wrote:


On 1 Feb, 19:46, "Mark A" <nob...@nowhere.comwrote:
<matts.gustavs...@foi.sewrote in message
>news:11**********************@p10g2000cwp.googleg roups.com...
I am running a standalone PC (DELL 1,73MHz with 504 MB of RAM) using
Windows XPP Service Pack 2 and BD2 version 8.1 (the freeware
version!).
Right after start of the PC the process db2dasrrm.exe takes allCPU
time. This makes the system extremely slow; to start the Control
Center takes several minutes. Exploring the database, e.g. to open the
table view gives the error SQL 1032N, "No start command of the
database has been given". SQLSTATE=57019. If I try to start the
database I get the error "A Communication problem has occurred at the
DB2administration server" If I try to start the communication server
by issuing the command C:\DBADMIN START I get "DB2administration
server is already active"
The system has been used for several months with no problem, this
problem occurred last week.
I would appreciate any suggestion on how to solve this problem.
Note: The message text is translated from Swedish and may not
correspond exactly with the messages on aDB2server using English.
Please do a db2level and post the results.
I don't know what you mean by freeware version, unless you are talking about
>DB2Express-C, but that was first released as release 8.2.
If you have the "try and buy" 8.1 FP 0, then you either need to getDB2
Express-C, or install FP14 on top of your existing try and buy.- Dölj citerad text -
- Visa citerad text -
The result from db2level is:
DB21085I Instance "DB2" uses "32" bits andDB2code release
"SQL08024" with
level identifier "03050106".
Informational tokens are "DB2v8.1.11.973", "s060120", "WR21365", and
FixPak
"11".
Product is installed at "C:\PROGRAM\IBM\SQLLIB".
I have donwloadedDB2from a IBM site.
/Matts- Dölj citerad text -
- Visa citerad text -

I have now installed FP14 and the result from DB2LEVEL is

DB21085I Instance "DB2" uses "32" bits andDB2code release
"SQL08027" with
level identifier "03080106".
Informational tokens are "DB2v8.1.14.292", "s061108", "WR21377", and
FixPak
"14".
Product is installed at "C:\PROGRA~1\IBM\SQLLIB".

The process db2dasrrm.exe still takes all availalbleCPUtime! However
I can access the database now but the system is slow!
/Matts- Dölj citerad text -

- Visa citerad text -
I have now recreated the DAS with the commands
DB2ADMIN STOP
DB2ADMIN DROP
DB2ADMIN CREATE /user=username /password=password
DB2ADMIN START
and the system works fine! But I do not know why!
/Matts

Feb 24 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.