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 > My First DB2 Installation

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-14-04, 13:26
JCScoobyRS JCScoobyRS is offline
Registered User
 
Join Date: Feb 2003
Location: In your thoughts
Posts: 195
My First DB2 Installation

I've ran db2setup and everything went without a hitch. I followed all the instructions but now, when I go into db2cc and try to create a new db under my instance, it says that my instance doesn't exist. Is there a good article on how to install this or can someone tell me what needs to follow the installation so I can use this? Thanks, Jeremy

P.S. - This is a development server for testing of a TOAD like app I'm writing for DB2.
__________________
Nothing better than a good ride.
Reply With Quote
  #2 (permalink)  
Old 01-14-04, 16:24
db2nemo db2nemo is offline
Registered User
 
Join Date: Jan 2004
Location: Canada
Posts: 12
Re: My First DB2 Installation

Quote:
Originally posted by JCScoobyRS
I've ran db2setup and everything went without a hitch. I followed all the instructions but now, when I go into db2cc and try to create a new db under my instance, it says that my instance doesn't exist. Is there a good article on how to install this or can someone tell me what needs to follow the installation so I can use this? Thanks, Jeremy

P.S. - This is a development server for testing of a TOAD like app I'm writing for DB2.
What platform are you on? And what version of DB2 are you installing?
Reply With Quote
  #3 (permalink)  
Old 01-14-04, 16:43
JCScoobyRS JCScoobyRS is offline
Registered User
 
Join Date: Feb 2003
Location: In your thoughts
Posts: 195
DB2 Version: V8.1
Platform: Red Hat Linux 8.0

I'm running db2setup and I see that it's having problems with the users. I'm diagnosing. Laters, Jeremy
__________________
Nothing better than a good ride.
Reply With Quote
  #4 (permalink)  
Old 01-14-04, 16:44
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,198
You need to log off root and log on to the instance owner id.
__________________
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
  #5 (permalink)  
Old 01-14-04, 21:33
JCScoobyRS JCScoobyRS is offline
Registered User
 
Join Date: Feb 2003
Location: In your thoughts
Posts: 195
Let's start from the top.

I am running Red Hat 8.0 and I would like to install DB2 8.1 Universal (Enterprise Edition). I've tried this many times today and I am yet to have a successful installation. Three thinks keep failing and I'm sure that one is causing the others:

DB2 Database Creation
Health Administration Server
DB2 Catalog

(Not exact names due to me not being at that machine)

Is there anything I have to do before installing besides setting up the kernel parameters? Everytime I run db2setup, I use existing users created specifically for DB2. No matter what though, it always fails. I can do a db2idrop instance name after the install the do a db2icrt and then I can actually start the instance but if I ever try to use my DAS Admin to start DAS, I usually get the "SQL4401C" error and after looking in the log, I see that I couldn't bind to port 523. I do an nmap -sT -O localhost and I get that ibm-db2 is listening on 523. I've done everything so before I left work, I fully uninstalled the system. Can someone help me install this please? Thanks in advance, Jeremy
__________________
Nothing better than a good ride.
Reply With Quote
  #6 (permalink)  
Old 01-14-04, 21:58
db2nemo db2nemo is offline
Registered User
 
Join Date: Jan 2004
Location: Canada
Posts: 12
Quote:
Originally posted by JCScoobyRS
Let's start from the top.

I am running Red Hat 8.0 and I would like to install DB2 8.1 Universal (Enterprise Edition). I've tried this many times today and I am yet to have a successful installation. Three thinks keep failing and I'm sure that one is causing the others:

DB2 Database Creation
Health Administration Server
DB2 Catalog

(Not exact names due to me not being at that machine)

Is there anything I have to do before installing besides setting up the kernel parameters? Everytime I run db2setup, I use existing users created specifically for DB2. No matter what though, it always fails. I can do a db2idrop instance name after the install the do a db2icrt and then I can actually start the instance but if I ever try to use my DAS Admin to start DAS, I usually get the "SQL4401C" error and after looking in the log, I see that I couldn't bind to port 523. I do an nmap -sT -O localhost and I get that ibm-db2 is listening on 523. I've done everything so before I left work, I fully uninstalled the system. Can someone help me install this please? Thanks in advance, Jeremy
You may want to choose a different port for the DAS:
For instance: db2dasport 5001
Then see if you can start the DAS.
Reply With Quote
  #7 (permalink)  
Old 01-14-04, 22:00
JCScoobyRS JCScoobyRS is offline
Registered User
 
Join Date: Feb 2003
Location: In your thoughts
Posts: 195
Great idea. I never thought about that. I'll do that and upate in the morning. Thanks, Jeremy
__________________
Nothing better than a good ride.
Reply With Quote
  #8 (permalink)  
Old 01-15-04, 10:00
JCScoobyRS JCScoobyRS is offline
Registered User
 
Join Date: Feb 2003
Location: In your thoughts
Posts: 195
I'm back at work so I'll try this but why does the ibm-db2 service conflict with das? There has to be something more than just modifying the port on which das starts. I'll try it but I want to understand. What does the ibm-db2 service do and why have it? Thanks, Jeremy
__________________
Nothing better than a good ride.
Reply With Quote
  #9 (permalink)  
Old 01-15-04, 22:09
db2nemo db2nemo is offline
Registered User
 
Join Date: Jan 2004
Location: Canada
Posts: 12
Hm.. that I am not sure. I saw 523 sometimes show up in the port number field when I catalog an Instance.

Does that mean port 523 is used by instance by default?


Quote:
Originally posted by JCScoobyRS
I'm back at work so I'll try this but why does the ibm-db2 service conflict with das? There has to be something more than just modifying the port on which das starts. I'll try it but I want to understand. What does the ibm-db2 service do and why have it? Thanks, Jeremy
Reply With Quote
  #10 (permalink)  
Old 01-16-04, 01:26
JCScoobyRS JCScoobyRS is offline
Registered User
 
Join Date: Feb 2003
Location: In your thoughts
Posts: 195
I got everything working by uninstalling then installing everything manually. I created the das, then the instance and then got everything to work. Once I got away from db2setup, I was good to go. Laters, Jeremy
__________________
Nothing better than a good ride.
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