By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,874 Members | 1,028 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,874 IT Pros & Developers. It's quick & easy.

"Database Home" and "Instance Home" (the difference)

P: n/a
I had to run DB2 on Win2k. After installation it puts a directory
under c:\DB2 and c:\DB2Log and C:\Program Files\SQLLIB
Now am all confused which is instance home, db2 home etc. I had
to configure tivoli inventory and its all *@#$ up because of this
confusion. Can someone please clarify which is which? TIA

c:\DB2>wgetrim invdh_1
RIM Host: user88
RDBMS User: user881
RDBMS Vendor: DB2
Database ID: RIM
Database Home: c:/Program Files/SQLLIB
Server ID:
Instance Home: c:/DB2
Instance Name: jk
C:\DB2>wrimtest -l invdh_1
Resource Type : RIM
Resource Label : invdh_1
Host Name : user88
User Name : user881
Vendor : DB2
Database : RIM
Database Home : C:/Program Files/SQLLIB
Server ID :
Instance Home : C:/DB2
Instance Name : ibmcis
Opening Regular Session...FRWRA0012E The RDBMS server call has failed.
The operation was: Unable to obtain DB2 Error Message
The RDBMS server call's return code was: -1
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ian
Kenjis Kaan wrote:
I had to run DB2 on Win2k. After installation it puts a directory
under c:\DB2 and c:\DB2Log and C:\Program Files\SQLLIB
Now am all confused which is instance home, db2 home etc. I had
to configure tivoli inventory and its all *@#$ up because of this
confusion. Can someone please clarify which is which? TIA


C:\Program Files\SQLLIB
Has the DB2 software, as well as the instance "home directories."
Example: ...\SQLLIB\DB2 is where the default instance named 'DB2'
keeps instance-level files; ...\SQLLIB\DB2DAS00 is where the
default Admin Server instance ('DB2DAS00') is located.

C:\DB2LOG
This is the location where the installation log files are placed.
This is safe to remove, provided you haven't configured your
database(s) to put their log files here. :-)

C:\DB2
This is the default location for any databases you created, i.e.
the 'database directory'. This directory will have (by default)
all of the tablespace containers and some other files related to
each of your databases.

Good luck,


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.