DB2 Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesDB2 Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
  #1  
Old April 27th, 2006, 04:55 AM
peter_tso peter_tso is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Apr 2006
Posts: 1 peter_tso User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 9 m 47 sec
Reputation Power: 0
Db2 linux install

Hi all.I have a SuSE Linux pro 9.3 system and i must install db2 v7.1 Enterprise Edition.What steps i must take to install it.plz I need a full guide with clear steps because I'm a noob.Your help is very important for me!!!!

Reply With Quote
  #2  
Old April 27th, 2006, 07:25 AM
pabloj's Avatar
pabloj pabloj is online now
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
 
Join Date: Jun 2001
Location: Outside US
Posts: 7,707 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 2 Weeks 6 Days 2 h 54 m 25 sec
Reputation Power: 259
So noob not to know Google ?

Reply With Quote
  #3  
Old May 3rd, 2006, 06:50 PM
dcaillouet's Avatar
dcaillouet dcaillouet is offline
Big Endian
Dev Shed Beginner (1000 - 1499 posts)
 
Join Date: May 2001
Location: Fly-over country
Posts: 1,173 dcaillouet User rank is Sergeant (500 - 2000 Reputation Level)dcaillouet User rank is Sergeant (500 - 2000 Reputation Level)dcaillouet User rank is Sergeant (500 - 2000 Reputation Level)dcaillouet User rank is Sergeant (500 - 2000 Reputation Level)dcaillouet User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 16 h 29 m 5 sec
Reputation Power: 24
To setup a DB2 instance (using the default db2inst1 name) on a machine via telnet I created the following "cheat sheet". This was done by wading through some documentation and making some mistakes. This is not a super-guru's guide, but the notes of a first-time DB2 installer on a SuSE box. Caveat Emptor! This worked for UDB 8.1 with 8.* SuSE. If anyone sees any problems with this process, please feel free to throw rocks at it. Since this cheat sheet is a couple of years old, I may have done some additional steps since then and forgot to go back and update these notes.

From the CD run the following command:
======================================
./db2_install

From the command prompt run the following:
==========================================

groupadd -g 999 db2iadm1
groupadd -g 998 db2fadm1
groupadd -g 997 db2asgrp

useradd -u 1004 -g db2iadm1 -m -d /home/db2inst1 db2inst1 -p password
useradd -u 1003 -g db2fadm1 -m -d /home/db2fenc1 db2fenc1 -p password
useradd -u 1002 -g db2asgrp -m -d /home/dasusr1 dasusr1 -p password

/opt/IBM/db2/V8.1/instance/db2icrt -a SERVER -u db2fenc1 db2inst1

/opt/IBM/db2/V8.1/cfg/db2ln

At this point, the install script has added the port numbers that tcp will listen to the /etc/services file.
Look at the tail of the file or grep this file for the instance name to see the port numbers. Record the name
of the service to be used in the following commands (DB2_db2inst1 in my example).

Log in as the instance owner:
su db2inst1
cd /home/db2inst1/sqllib
./db2profile
db2 update dbm cfg using SVCENAME DB2_db2inst1

You can check that the service name has been added by running:
db2 get dbm cfg |grep SVC

db2set DB2COMM=tcpip

Add a license for the product. Below is listed a license install for DB2 ESE (ftp the license and install it in the directory first):
/opt/IBM/db2/V8.1/adm/db2licm -a /opt/IBM/db2/V8.1/license/db2ese.lic

db2start

Setup the Database Administration server
========================================
Login as root.

Run the following command:
/opt/IBM/db2/V8.1/instance/dascrt -u dasusr1

Login as instance owner. Make sure the JAVA_HOME and PATH evironment variables are set. If not, run the export commands manually.

Run the following command:
db2 create tools catalog toolscat create new database toolsdb

db2 update admin cfg using smtp_server <name of email server>

db2 update admin cfg using contact_host db2inst1

Load the sample database
/opt/IBM/db2/V8.1/bin/db2sampl


...or as pabloj suggested use Google and find pages like this: DB2 on Linux HowTo
Comments on this post
pabloj agrees: Always a source of great infos

Last edited by dcaillouet : May 3rd, 2006 at 06:55 PM.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesDB2 Development > Db2 linux install


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway