Results 1 to 6 of 6
  1. #1
    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 18:49.

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,361
    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.

  3. #3
    Join Date
    Jan 2013
    Posts
    3
    Thanks - is that information documented anywhere?

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,361

  5. #5
    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.

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,277
    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
    Last edited by przytula_guy; 01-10-13 at 08:14.
    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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •