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

    Unanswered: db2 installation - users

    v9.7 installation.

    The db2inst1, db2fenc1 and dasusr1 user ids are added as an LDAP accounts in /etc/passwd

    Is it fine to run them as LDAP accounts or should they be local to the server?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I always make them local. I have encountered some servers where a system admin changed them to LDAP, with disastrous results every time the LDAP server had the slightest hiccup.
    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
    What happens to existing and new connections when the instance owner id is defined as an LDAP account and the LDAP server has a brief hiccup? Loose connection / can't connect to the db?

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If it's the instance owner, I believe that DB2 hangs, or crashes, don't recall which. I would never define those three id's as LDAP. DB2 does support LDAP groups, but I try to avoid that also.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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