If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > not able to start db2

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-17-09, 07:11
abhinash abhinash is offline
Registered User
 
Join Date: Dec 2009
Posts: 5
not able to start db2

hi !!!!!!!
m new to db2 , i have successfully installed the db2 software but m not been able to find its storage path .
plz help me in accessing it ???

thankyou
Reply With Quote
  #2 (permalink)  
Old 12-17-09, 08:35
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
What DB2 version and OS are you using. Define what you mean by "storage path".

Andy
Reply With Quote
  #3 (permalink)  
Old 12-17-09, 08:54
abhinash abhinash is offline
Registered User
 
Join Date: Dec 2009
Posts: 5
m using db2exc_9.7.0-8_i386.deb and os is ubuntu

storage path simply means that after the installation of db2 from where should i start it to access it
Reply With Quote
  #4 (permalink)  
Old 12-17-09, 10:52
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
Login in as the instance owner (defaults to db2inst1, but you might have changed it during installation). Then issue "db2start". Then do all other DB2 tasks using the instance owner.

Andy
Reply With Quote
  #5 (permalink)  
Old 12-18-09, 04:42
abhinash abhinash is offline
Registered User
 
Join Date: Dec 2009
Posts: 5
for "db2start" it was showing command not found
and the path set is
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/opt/ibm/ibm-java2-i386-50/bin:/opt/ibm/ibm-java2-i386-50/jre/bin
Reply With Quote
  #6 (permalink)  
Old 12-18-09, 08:22
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
Either your instance owner is not setup properly, or you are not logged in as the instance owner.

Andy
Reply With Quote
  #7 (permalink)  
Old 12-18-09, 12:43
abhinash abhinash is offline
Registered User
 
Join Date: Dec 2009
Posts: 5
it's also not working as a root

how to find a url of db2 ???
Reply With Quote
  #8 (permalink)  
Old 12-18-09, 14:21
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
It is not supposed to work with root, only the instance. When you did the install, did you set up the instance?

Andy
Reply With Quote
  #9 (permalink)  
Old 12-19-09, 08:31
abhinash abhinash is offline
Registered User
 
Join Date: Dec 2009
Posts: 5
Red face

could you plz tell me how to find url of db2
Reply With Quote
  #10 (permalink)  
Old 12-19-09, 09:59
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
I don't know what you mean by "url of db2". Like Andy said, you need to login as the DB2 instance owner id.

Check if you have this file: /var/db2/global.reg

If you do, you can view it using "strings /var/db2/global.reg"

This file will give you the instance name - for example db2inst1. If this file is empty or doesn't exist, then most likely the instance was not created. In this case, login as root and use db2icrt command to create it. See this URL for info on how to create an instance:
IBM DB2 9.7 for Linux, UNIX and Windows Information Center


Then, switch to the instance using "su - <instance name>" or login as <instance name> directly and execute db2start
Reply With Quote
  #11 (permalink)  
Old 12-19-09, 13:11
stolze stolze is offline
Registered User
 
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
Quote:
Originally Posted by ARWinner View Post
Either your instance owner is not setup properly, or you are not logged in as the instance owner.

Andy
Andy is right. Check if the home directory of the instance owner has a "sqllib" directory. If not, you didn't create the instance. You can use the "db2icrt" executable (in the location where you installed DB2, subdirectory "instance") for that. If you do have a sqllib directory, make sure that your .profile sources sqllib/db2profile. Otherwise, you won't have the PATH environment variable set up correctly.
__________________
Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On