Link to home
Start Free TrialLog in
Avatar of marrowyung
marrowyung

asked on

Restarting DB2 V8.1

Dear all,

what is the command to restart DB2 V8.1?

DBA100.
Avatar of Kent Olsen
Kent Olsen
Flag of United States of America image

On LUW you can run:

  db2start

from the instance owner.



Kent
Avatar of marrowyung
marrowyung

ASKER

sorry, LUW  means ?

"from the instance owner."

meansn under the user account that is the instance owner, then we type the command ?
SOLUTION
Avatar of momi_sabag
momi_sabag
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
"in windows you can just search for the db2 service and start it"

Sorry any tools can quickly find it?
What situtation that the db2start doens't work even under the instance owner name ?
and how to fix it?
under windows - > control panel -> administration - >services

you will have to check the db2diag.log file in order to figure out why the instance is not starting
are you using windows or linux/unix?
"under windows - > control panel -> administration - >services"

we use AIX, so this is not going to apply ?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi!

You can become the db2 instance owner by using either root or a user with sudo privilege to change to the "db2 master user" (by default it is db2inst1 ) .
From there issue "db2start".
If that doesn't work look into the sqllib/db2dump/db2diag.log file for errors. The sqllib directory is usually under the instance owners home directory.
If that won't tell you anything then look into the AIX system log for clues.

Regards,
    Tomas Helgi
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial