Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

    Unanswered: Permissions for directories containing databases

    From IBM DB2 9.7 for Linux, UNIX and Windows Information Center

    For the directories containing the databases, each and every directory level up to and including NODE000x needs the following permissions:

    drwxrwxr-x 11 db2inst1 db2grp1 4096 Jun 14 15:53 NODE0000/

    For example, if a database is located in /db2/data/db2inst1/db2inst1/NODE0000 then the directories: /db2, /db2/data, /db2/data/db2inst1, /db2/data/db2inst1/db2inst1 and /db2/data/db2inst1/db2inst1/NODE0000 need drwxrwxr-x.

    Can you think of why group needs w(write)? Why can't be drwxr-xr-x ?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by db2girl View Post
    From IBM DB2 9.7 for Linux, UNIX and Windows Information Center




    Can you think of why group needs w(write)? Why can't be drwxr-xr-x ?
    I make sure that the instance owner owns the main directories/mount points used by DB2, and then when DB2 creates sub-directories and files under that it decides what authority to use.

    I would not try and second guess why DB2 created a sub-directory or file with a certain group level permission.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    I'm just trying to understand why group needs write access to the sub-directories db2 creates. The top-level directories I create myself are set to 755.

Posting Permissions

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