Technical Blog Post
Abstract
Expert Advice: Plan ahead to avoid Group ID issues with DB2.
Body
When creating a new instance. DB2 requires the group ID to fall into the range of 100-65535. If the group ID doesn't fall in that range the instance creation will fail. You will see an error similar to below.
This means special care is needed for those systems with a large number of users and groups. Such as those who utilize LDAP, or Microsoft Active Directory. Special care should be taken to ensure that users and groups should be given ID's greater than the 65535 limit, so that this issue will not be hit.
Reproduction:
root@test # ./db2icrt -s ese -u db2test db2test
DBI1446I The db2icrt command is running, please wait.
DB2 installation is being initialized.
The GID specified for the group "db2test" is invalid. Enter a valid
GID
between "100"-65535.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
UID
ibm13287073