|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
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
|
|||
|
|||
|
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!!!!
|
|
#2
|
||||
|
||||
|
So noob not to know Google ?
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins |
|
#3
|
||||
|
||||
|
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 Last edited by dcaillouet : May 3rd, 2006 at 06:55 PM. |
![]() |
| Viewing: Dev Shed Forums > Databases > DB2 Development > Db2 linux install |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|