The directory structure appears as follows: your_database_path⁄your_instance⁄NODE0000⁄SQL00001 ⁄
How are these determined?
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:
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.
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 07: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