PI99773: BIG SQL HA ENABLEMENT WILL FAIL WHEN BIGSQL USER IS AN LDAP USER AND THE HOME DIRECTORY FOR THE USER IS NON-DEFAULT

APAR status

• Closed as fixed if next.

Error description

• When enabling Big SQL HA in an environment where bigsql user is
  an LDAP user, typically /etc/passwd will not have an entry for
  the user as it is not a local user. During HA  enablement, if
  an entry in /etc/passwd is not found, installation process adds
  an entry for bigsql user with the default home directory,
  /home/bigsql.
  Since the actual home directory of bigsql is not /home/bigsql,
  HA enablement will fail with the following symptom.
  bash: line 1: db2pd: command not found
  Failed to verfiy HA on primary, command output was:
  Last login: Wed Jun 13 14:59:26 UTC 2018
  

Local fix

• If bigsql user is an LDAP user and the home directory is not
  /home/bigsql, then an entry can be added to /etc/passwd prior
  to adding second head node to the cluster. Note, this step
  needs to be performed on both head nodes.
  echo "bigsql:x:"´id -u bigsql´:´id -g bigsql´"::<home directory
  of bigsql user>:/bin/bash" >> /etc/passwd
  

Problem summary

• See problem description
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels