Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2009
    Posts
    16

    Unanswered: 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

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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.

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    If this is unix/linux, try "db2greg -dump" and then look at the line that begins with "I"

  4. #4
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    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.7.0.6 os 6.1.0.0

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

Posting Permissions

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