IT16492: DB2 PATTERN FAILS TO CREATE THE DATABASE USER WHEN THE CHOSEN USER ID IS ALREADY USED BY LDAP

IBM PureApplication System Version 2.2.2.1

APAR status

• Closed as program error.

Error description

• Currently only the local password and group files are searched
  by the DB2 pattern for available user / group IDS. This can
  lead to problems when LDAP is used for user accounts. This APAR
  will make sure that LDAP users are taken into account by the
  DB2 pattern.
  
  The error message in the log is:
  
  [TIMESTAMP] - root - DEBUG - create new OS user
     ['/opt/IBM/maestro/agent/usr/servers/
     DB2_Node.[NODE ID]/scripts/DB2/shell/func_agent.sh',
     'generate_uid']
  [TIMESTAMP] - root - DEBUG - return value=501
  [TIMESTAMP]- root - DEBUG - exit code is: '4', return message
     is: '[TIMESTAMP]  INFO: useradd -m -d /home/iauser -u 501 -g
     gdb2admi -G gdb2admi,g_sysctl,g_sysmnt iauser
     useradd: UID 501 is not unique
  

Local fix

Problem summary

• The code for UID and GID generate methods were changed to take
  into account the LDAP users
  

Problem conclusion

• A code fix is being provided in PureApplication System
  version 2.2.2.0 in the IBM DB2 with BLU Acceleration Pattern
  version 1.2.4.2.
  

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

• Fixed component name

  IWD FOR DB2 WSE

• Fixed component ID

  IWDFORDB2

Applicable component levels

• R120 PSY

     UP