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 > Is there any command in UDB/Linux to List all mount points for a given instance?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-08-07, 15:04
pagwu pagwu is offline
Registered User
 
Join Date: Mar 2007
Posts: 70
Is there any command in UDB/Linux to List all mount points for a given instance?

Hi all,
Is there a command or a method of listing all mount points for a given DB2 instance? Any help will be much appreciated.


Thanks
Reply With Quote
  #2 (permalink)  
Old 11-08-07, 15:25
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
What do mount points have to do with a DB2 instance?
Reply With Quote
  #3 (permalink)  
Old 11-09-07, 11:46
pagwu pagwu is offline
Registered User
 
Join Date: Mar 2007
Posts: 70
Perhaps absolutely nothing...I am relatively new to DB2 on Linux and phrased the question wrongly.

Thanks for pointing this out.
Reply With Quote
  #4 (permalink)  
Old 11-09-07, 12:16
stolze stolze is offline
Registered User
 
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
Do you want to know the paths where DB2 database files are stored? (More precisely, the absolute paths of containers of tablespaces?) If so, check out the DB2 command "LIST TABLESPACES ... [SHOW DETAIL]"
__________________
Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
Reply With Quote
  #5 (permalink)  
Old 11-09-07, 13:45
pagwu pagwu is offline
Registered User
 
Join Date: Mar 2007
Posts: 70
Quote:
Originally Posted by stolze
Do you want to know the paths where DB2 database files are stored? (More precisely, the absolute paths of containers of tablespaces?) If so, check out the DB2 command "LIST TABLESPACES ... [SHOW DETAIL]"
Thanks again Knut, this is helpful. I am interested in finding all mount points for my Linux environments including those in what I may term "sub-directories".
Here's why. I issue a mount command and I get
/dev/sda1 on /ald type ext3 (rw)
/dev/sdb1 on /ali type ext3 (rw)
/dev/sdc1 on /alt type ext3 (rw)
/dev/sdd1 on /bbd type ext3 (rw)
/dev/sde1 on /bbi type ext3 (rw)
/dev/sdf1 on /bbt type ext3 (rw)
/dev/sdg1 on /dmd type ext3 (rw)
/dev/sdh1 on /dmi type ext3 (rw)
/dev/sdi1 on /dmt type ext3 (rw)
/dev/sdj1 on /dwd type ext3 (rw)
/dev/sdk1 on /dwi type ext3 (rw)
/dev/sdl1 on /dwt type ext3 (rw)

I then entered cd /sbin and I am routed to /sbin. Now, looking at the output of mount command, I did not see /sbin listed as a mount point. Why is that?
This is why I am looking for command that will list all mount points regardless of the level in the directory path.

Thanks
Reply With Quote
  #6 (permalink)  
Old 11-09-07, 17:00
stolze stolze is offline
Registered User
 
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
What you are asking has nothing to do with DB2.

Why you are not seeing /sbin listed as mount point for some device, I do not know. What happens with
Code:
$ df /sbin/
It will show you the file system applicable to the directory /sbin and also where this file system is mounted.
__________________
Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
Reply With Quote
Reply

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