[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 458
  • Last Modified:

Restarting DB2 V8.1

Dear all,

what is the command to restart DB2 V8.1?

DBA100.
0
marrowyung
Asked:
marrowyung
  • 5
  • 2
  • 2
  • +1
3 Solutions
 
Kent OlsenData Warehouse Architect / DBACommented:
On LUW you can run:

  db2start

from the instance owner.



Kent
0
 
marrowyungAuthor Commented:
sorry, LUW  means ?

"from the instance owner."

meansn under the user account that is the instance owner, then we type the command ?
0
 
momi_sabagCommented:
luw means linux unix windows (ie, not mainframe or iseries / as400)

from the instance owner means: the user that runs the instance
in windows you can just search for the db2 service and start it
in linux / unix open a terminal, switch to the user which is used to run the db2 processes and use the command
db2 start
to start the instance
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
marrowyungAuthor Commented:
"in windows you can just search for the db2 service and start it"

Sorry any tools can quickly find it?
0
 
marrowyungAuthor Commented:
What situtation that the db2start doens't work even under the instance owner name ?
0
 
marrowyungAuthor Commented:
and how to fix it?
0
 
momi_sabagCommented:
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?
0
 
marrowyungAuthor Commented:
"under windows - > control panel -> administration - >services"

we use AIX, so this is not going to apply ?
0
 
Kent OlsenData Warehouse Architect / DBACommented:
Hi Marrow,

AIX is IBM's proprietary UNIX operating system.   The example that you posted is from a Windows operating system and won't work under AIX.

Do you know the instance owner?  That would be the database's "master user".  If so, try by logging in as this user and running the db2start command.


Kent
0
 
Tomas Helgi JohannssonCommented:
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
0
 
Tomas Helgi JohannssonCommented:
One other thing. Make sure that the instance owners passw does not expire. That could lead to some strange issues if you have recently reset or changed the instance owners password,
especially on AIX 5.3 (see this link http://www-01.ibm.com/support/docview.wss?uid=swg21224762 and search for IY67947 )

Regards,
   Tomas Helgi
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now