Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've got an instance of DB2 installed as part of an IBM WebSphere Portal development AMI on the Amazon EC2 cloud. Its installed a separate, persistent file system from the rest of the AMI.

Yesterday, the AMI was terminated, and DB2 went down as part of that. It was not shut down cleanly, just terminated.

Today, I am trying to restart the WebSphere portal server, which needs to connect to the DB2 instance. But the DB2 instance is down.

So I need to restart my DB2 instance, but how to do that is not immediately obvious. Can someone tell me what I need to run to get it going again?

OS is SuSE Linux, DB2 version is 9.1

share|improve this question

1 Answer 1

Ok, I got this to work. What I had to do was su to the owner of the db2 instance (in this case, the user name was db2inst1)

Under that users home directory, there is a directory called "sqllib/adm" and under that is an executable called "db2start" which must be run.

This script initially failed for me with an "SQL6048N" error. To fix this, I had to change the name of the host in the sqllib/db2nodes.cfg file - the host name on the current instance was different because the host name changes when you terminate and restart an AMI image. This host name also had to be changed in the file /opt/ibm/db2/V9.1/default.env

share|improve this answer
    
Make sure there is a DB2 service set up in your System Services under YaST; this will make sure that DB2 is started automatically when your instance boots up. –  gareth_bowles May 19 '10 at 15:24

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.