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 > command to get db2 instance profile path

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-28-09, 10:25
MeeraJoy MeeraJoy is offline
Registered User
 
Join Date: Apr 2009
Posts: 16
command to get db2 instance profile path

db2ilist will list all db2 instances
what command is for listing the path of any one of the instances
Reply With Quote
  #2 (permalink)  
Old 07-28-09, 12:01
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
what do you mean by Path of the instance ?

The sqllib directory (which is where all executeables and many configs for the instance are stored) will be in the instance owner's home directory

This is on Unix

On windows, it will be a sub-directory of the sqlllib directory ...
For instance DB2, it will be
C:\......\sqllib\DB2
For instance MYINST it will be
C:\......\sqllib\Myinst

HTH
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #3 (permalink)  
Old 07-28-09, 15:22
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
If this is unix/linux, try "db2greg -dump" and then look at the line that begins with "I"
Reply With Quote
  #4 (permalink)  
Old 07-28-09, 15:48
Cougar8000 Cougar8000 is offline
Registered User
 
Join Date: Nov 2005
Location: IL
Posts: 554
Quote:
Originally Posted by db2girl
If this is unix/linux, try "db2greg -dump" and then look at the line that begins with "I"
Bella,

that is great. This works better then a find command. Specially that people where I am now decided to set up unix group access in such a way that prevents me from finding db2profile. Where this command gives me what I need and much faster.

p.s. any idea why there is almost no documentation on this command?
__________________
--
IBM Certified DBA on DB2 for Linux, UNIX, and Windows

DB2 v9.1.0.2 os 5.3.0.0
Reply With Quote
  #5 (permalink)  
Old 07-28-09, 18:05
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Cougarchik,

There is not really much to document since most people would only use -dump option. Other options require root and should not really be used without contacting DB2 support. This could be the reason why they don't have much documentation on this.
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