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 > unable to start db2

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-16-10, 06:11
nezha_bo nezha_bo is offline
Registered User
 
Join Date: Feb 2010
Posts: 2
unable to start db2

Hi,

I'm connectig to a machine with the user root, i navigate the file /opt/IBM/db2 and when i type the db2start command i got this error

SQL1092N root does not have the authority to perform the requested command

can anyone help to get start with db2??

thank you for your help
Reply With Quote
  #2 (permalink)  
Old 02-16-10, 06:17
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
never start db2 from root/system
this should be started by instance
su - db2inst1 or other instance and execute db2start for this instance
do db2ilist to find the instances
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #3 (permalink)  
Old 02-16-10, 08:06
nezha_bo nezha_bo is offline
Registered User
 
Join Date: Feb 2010
Posts: 2
Ok thank you

i have an other question, i would like to connect to db2 using the interface and i type db2cc but i git this error
sh :/opt/IBMJava2-142/jre/bin/java: No such file or directory DB2JAVIT : RC = 127

i tried also to start teh database using db2start and it doesn't work
SQL6048N A communication error occured during START or STOP DATABASE MANAGER procesisng.
SQL1032N No start database maanger command was issued. SQLSTATE= 57019


thank you for your help

regards,
Reply With Quote
  #4 (permalink)  
Old 02-16-10, 15:21
blazer789 blazer789 is offline
Registered User
 
Join Date: Jun 2009
Posts: 221
Sometimes memory on the box which you are working migh not be enough to open the control centre [db2cc]. Try to install a DB2 windows client on the box and open control centre from there. start - programs -IBM DB2 - General Administration tools - Control Centre.
Reply With Quote
  #5 (permalink)  
Old 02-16-10, 15:27
blazer789 blazer789 is offline
Registered User
 
Join Date: Jun 2009
Posts: 221
which version of db2 are you under ? If you are running on V9.5, Please make sure the instance whic you are starting is present under /opt/IBM/db2/V9.5/instance/db2ilist

Please let me know whether or not you are using the instance user id to start the instance.

And also make sure to cat this file INSTANCE_PATH/sqllib/db2nodes.cfg and see if the host name is present in it.
Reply With Quote
  #6 (permalink)  
Old 02-16-10, 15:32
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,198
Quote:
Originally Posted by nezha_bo View Post
Ok thank you

i have an other question, i would like to connect to db2 using the interface and i type db2cc but i git this error
sh :/opt/IBMJava2-142/jre/bin/java: No such file or directory DB2JAVIT : RC = 127

i tried also to start teh database using db2start and it doesn't work
SQL6048N A communication error occured during START or STOP DATABASE MANAGER procesisng.
SQL1032N No start database maanger command was issued. SQLSTATE= 57019


thank you for your help

regards,
The DB2 GUI tools do not work well under Linux (and are often not installed correctly). Run them under Windows or use command line.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
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