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 > DB2 Windows Registry Entries

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Jan 2013
Posts: 3
DB2 Windows Registry Entries

I know this is probably an arcate question, but how does DB2 Express 10 know which directory to look for the data files in (Windows)?

I searched through this Registry key but could find nothing obvious:
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2

Many thanks.

Last edited by netlib; 01-08-13 at 17:49.
Reply With Quote
  #2 (permalink)  
Old
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 2,357
If by data files you mean db2 tables / tablespaces, then it doesn't look at the registry to get this info. There is db directory, system catalog and other control files that db2 uses to get this info.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Jan 2013
Posts: 3
Thanks - is that information documented anywhere?
Reply With Quote
  #4 (permalink)  
Old
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 2,357
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Jan 2013
Posts: 3
Thanks for the link. It starts out with this:

The directory structure appears as follows: your_database_path⁄your_instance⁄NODE0000⁄SQL00001 ⁄

How are these determined?
  • your_database_path
  • your_instance
For example, I installed DB2 Express, created the Sample database and it created this directory structure, which doesn't seem to include the Sample Database name:

C:\DB2\NODE0000\SQL00001

Does DB2 always install in that directory on Windows?

Ultimately I am looking for the files where the actual data is stored (*.CAT and *.LRG I believe?) and the "master" database file that contains the information about databases, permissions, logins, etc.

Thanks again.
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 2,084
sql00001 is the name given to the first created db
db2 list db directory will indicate where the db was generated
c:\db2 is the instance name NODE0000 first node
master db is for MS SQL server : the info about grants.. is in the catalog tables owned by sysadm
all details in info center
files and location : http://publib.boulder.ibm.com/infoce.../c0005420.html
__________________
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified
http://www.infocura.be

Last edited by przytula_guy; 01-10-13 at 07:14.
Reply With Quote
Reply

Tags
db2, db2 express, windows

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