Hi,
How do I know the physical database path of a database. When I goto
the DB2INSTANCE users's directory (/home/db2inst1), I see following
folders:
/db2inst1/NODE0000/SQL00001
/db2inst1/NODE0000/SQL00002
/db2inst1/NODE0000/SQL00003
/db2inst1/NODE0000/SQL00004
/db2inst1/NODE0000/SQL00005
How do I know which database is using which of the above directory?
Is there any command, using which, if I supply the DB Name it will
give me the physical location of the database on server?
OS: Solaris 9
DB2: IBM UDB 8.1
Regards,
Kamlesh
8  7896 
In article <26************ *************@p osting.google.c om>, Kamlesh
(ka*********@ya hoo.com) says... Hi,
How do I know the physical database path of a database. When I goto
the DB2INSTANCE users's directory (/home/db2inst1), I see following
folders:
/db2inst1/NODE0000/SQL00001
/db2inst1/NODE0000/SQL00002
/db2inst1/NODE0000/SQL00003
/db2inst1/NODE0000/SQL00004
/db2inst1/NODE0000/SQL00005
How do I know which database is using which of the above directory?
Is there any command, using which, if I supply the DB Name it will
give me the physical location of the database on server?
Hi,
You can use the 'list db directory on ....' command to get the
physical path.
If you haven't moved the log files from their default location; you can
examine the database configuration and get the directory from the "Path
to log files" value.
You can also examine ..../NODE0000/sqldbdir/sqldbdir. That file contains
the database names and directory for each but it's not intended to be
read by people.
If you connect to a database; you can use "list tablespace containers
for 0" which will give you the path to the containers.
Phil Sherman
Kamlesh wrote: Hi,
How do I know the physical database path of a database. When I goto
the DB2INSTANCE users's directory (/home/db2inst1), I see following
folders:
/db2inst1/NODE0000/SQL00001
/db2inst1/NODE0000/SQL00002
/db2inst1/NODE0000/SQL00003
/db2inst1/NODE0000/SQL00004
/db2inst1/NODE0000/SQL00005
How do I know which database is using which of the above directory?
Is there any command, using which, if I supply the DB Name it will
give me the physical location of the database on server?
OS: Solaris 9
DB2: IBM UDB 8.1
Regards,
Kamlesh
"Kamlesh" <ka*********@ya hoo.com> wrote in message
news:26******** *************** **@posting.goog le.com... Hi,
How do I know the physical database path of a database. When I goto
the DB2INSTANCE users's directory (/home/db2inst1), I see following
folders:
/db2inst1/NODE0000/SQL00001
/db2inst1/NODE0000/SQL00002
/db2inst1/NODE0000/SQL00003
/db2inst1/NODE0000/SQL00004
/db2inst1/NODE0000/SQL00005
How do I know which database is using which of the above directory?
Is there any command, using which, if I supply the DB Name it will
give me the physical location of the database on server?
OS: Solaris 9
DB2: IBM UDB 8.1
I'm not sure how to get from the directory that you want to the database
name but I can tell you how to get from the database name to the directory.
If you follow these instructions, you should be able to map each of your
databases to a specific directory. Once you have built this map, it will be
easy to determine which database is associated with a specific directory.
1. Execute this command at your DB2 CLP prompt:
db2 list database directory
This will list all of your system database directory.
Find the database that interests you in the result via its database name,
e.g. SAMPLE. Look at the value of 'database drive' for that database.
2. Execute this command at your DB2 CLP prompt:
db2 list database directory on <database_drive >
The directory name you want will appear in the result of that query in the
'database directory' value for the desired database, e.g. SQL00002.
Just in case that is not clear, this is what I did on my system, which is
DB2 V7.2 on Windows XP:
db2 list database directory
Result:
[snip]
Database 6 entry:
Database alias = SAMPLE
Database name = SAMPLE
Database drive = C:\DB2
Database release level = 9.00
Comment = DB2 Sample Database
Directory entry type = Indirect
Catalog node number = 0
Then, using the 'database drive' value for database Sample, I executed:
db2 list database directory for c:\DB2
Result:
[snip]
Database 2 entry:
Database alias = SAMPLE
Database name = SAMPLE
Database directory = SQL00002
Database release level = 9.00
Comment =
Directory entry type = Home
Catalog node number = 0
Node number = 0
The directory name you want, SQL00002, is in the 'database directory' field
of this result under the SAMPLE database's entry.
If you simply repeat this process for each of your databases, you will soon
know exactly which database maps to each directory.
Rhino
Thanks for all your response on this topic. I am able to get the
details I require using the following:
db2 list database directory
and then...
db2 list database directory on <database_drive >
I need one clarification here. The solution provided by you all is
only possible I am executing the commands directly on the Server
Console. Can I get the DB Physical Location from my Client System
which is having DB2 Client software installed. I have both Windows
and Unix based clients.
Regards,
Kamlesh
"Kamlesh" <ka*********@ya hoo.com> wrote in message
news:26******** *************** ***@posting.goo gle.com... Thanks for all your response on this topic. I am able to get the
details I require using the following:
db2 list database directory
and then...
db2 list database directory on <database_drive >
I need one clarification here. The solution provided by you all is
only possible I am executing the commands directly on the Server
Console. Can I get the DB Physical Location from my Client System
which is having DB2 Client software installed. I have both Windows
and Unix based clients.
Why don't you try it yourself and see? Use the same commands at the CLP on
your client.
Rhino
"list tablespace containers for 0" is run after establishing a database
connection. This should also work on the client. You will, of course,
need appropriate authorization to run the "list tablespace containers"
command.
Phil Sherman
Kamlesh wrote: Thanks for all your response on this topic. I am able to get the
details I require using the following:
db2 list database directory
and then...
db2 list database directory on <database_drive >
I need one clarification here. The solution provided by you all is
only possible I am executing the commands directly on the Server
Console. Can I get the DB Physical Location from my Client System
which is having DB2 Client software installed. I have both Windows
and Unix based clients.
Regards,
Kamlesh
The list command for directories runs against the instance (they are
instance objects) that is identified by either the OS environment
variable DB2INSTANCE or by the db2 global registry profile variable
DB2INSDEF.
Both these variables are resolved as the application, the db2cmd command
window, is launched on the local system.
So your command on the server shows where the db's are located on that
server.
The command on your client would show the db's on your client, if any,
never the remote db's on the server.
HTH, Pierre.
Kamlesh wrote: Thanks for all your response on this topic. I am able to get the
details I require using the following:
db2 list database directory
and then...
db2 list database directory on <database_drive >
I need one clarification here. The solution provided by you all is
only possible I am executing the commands directly on the Server
Console. Can I get the DB Physical Location from my Client System
which is having DB2 Client software installed. I have both Windows
and Unix based clients.
Regards,
Kamlesh
--
Pierre Saint-Jacques - Reply to: sescons at attglobal dot com
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.
As an add on to this.
The list db directory on the client will show the path, on the server,
where the db exists.
If you map the server target drive to your platform, then you could run
the list db directory on <path>.
HTH, Pierre.
Pierre Saint-Jacques wrote: The list command for directories runs against the instance (they are
instance objects) that is identified by either the OS environment
variable DB2INSTANCE or by the db2 global registry profile variable
DB2INSDEF.
Both these variables are resolved as the application, the db2cmd command
window, is launched on the local system.
So your command on the server shows where the db's are located on that
server.
The command on your client would show the db's on your client, if any,
never the remote db's on the server.
HTH, Pierre.
Kamlesh wrote:
Thanks for all your response on this topic. I am able to get the
details I require using the following:
db2 list database directory and then...
db2 list database directory on <database_drive >
I need one clarification here. The solution provided by you all is
only possible I am executing the commands directly on the Server
Console. Can I get the DB Physical Location from my Client System
which is having DB2 Client software installed. I have both Windows
and Unix based clients.
Regards,
Kamlesh
--
Pierre Saint-Jacques - Reply to: sescons at attglobal dot com
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: yensao |
last post by:
Hi,
I have a hard time to understand difference and similarities between
Relational database model and the Object-Oriented model. Can somebody
help me with this?
Thank you in advance.
Yensao
|
by: Cherrish Vaidiyan |
last post by:
sir,
The following are the steps that i followed in setting up standby
database on Red hat Linux 9. i am using Oracle 9i.
i have followed the steps in this site :
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/create_ps.htm#66206
Still i give the steps i followed.
Preparing the Primary Database for Standby Database Creation
|
by: Cristina |
last post by:
Hallo
i am a beginner into Oracle Technologies.I would like to make backup
of my database,but i dont know how.Is there tools?Can i schedule the
backup plan?
thanks
Cristina
|
by: Massimiliano Campagnoli |
last post by:
Good morning,
Database PRODUCTION was created on a system mamanged tablespace on
drive c:\
Now drive c:\ is running out of space and I need to move PRODUCTION to
the larger drive d:\ on the same machine.
PRODUCTION is currently accessed by 50 clients running many
applications and by some REXX scripts running on the same server
machine on a timely basis.
I do not want to modify in any way clients configuration, applications,
|
by: jimdscudder |
last post by:
How can I use WMI or a WqlObjectQuery to find the hard drive letter of the
physical drive location index.
For example the following code will give me the physical drive location:
StringCollection propNames = new StringCollection();
ManagementClass driveClass = new ManagementClass("Win32_DiskDrive");
PropertyDataCollection props = driveClass.Properties;
foreach (PropertyData driveProperty in props)
{
propNames.Add(driveProperty.Name);
| | |
by: Luis Mendes |
last post by:
Hello,
I've a application in VB.NET that uses a connection to a
Access data base stored in my Hard Drive.
How can I change the location of the database (To a
network) and change the conection string?
In VB6 this was very easy, but under VB.NET I'm not able
to do it.
|
by: ad |
last post by:
I am use a Database name "myBase" of SqlExpress 2005 as DataBase.
How can I get the physical location of "myBase"
|
by: Atli |
last post by:
You may be wondering why you would want to put your files “into” the database, rather than just onto the file-system. Well, most of the time, you wouldn’t.
In situations where your PHP application needs to store entire files, the preferred method is to save the file onto the server’s file-system, and store the physical location of the file in your database. This is generally considered to be the easiest and fastest way to store files.
...
|
by: Jonathan Wood |
last post by:
I have a Web application. Initially, I created a database in the App_Data
folder and then attached it to SQL Servero 2005 (not SQL Server Express).
I realize now that this is now what I want. So I created a backup of the
database, detached the database file, and then created a new database from
the backup that is fully a part of SQL Server 2005.
The new database works just fine but I'm having the following problems:
1. I can delete...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
