472,126 Members | 1,569 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,126 software developers and data experts.

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

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
1 7850
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.

Similar topics

4 posts views Thread by Luca T. | last post: by
4 posts views Thread by Daedric | last post: by
8 posts views Thread by situ | last post: by
7 posts views Thread by Gabriella | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.