DB2 - Problem description
| Problem IC72129 | Status: Closed |
DB2_INSTALL FAILS WITH ERROR:DBI1135E ON NON ROOT INSTALL IF GROUP NAME CONTAINS '_' CHARACTER | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
| Problem description: | |
db2_install fails with a major error in a non root install if
the group name for the user performing the installation
contains the '_' character.
In this example the user is tuser and the group is t_grp
cd to install path
su - tuser
$ ./db2_install -p ESE
DBI1244I Directory for non-root installation of DB2 -
/home/tuser/sqllib
A major error occurred during the execution that caused this
program
terminate prematurely. If the problem persists, contact your
technica
service representative.
For more information see the DB2 installation log at
"/tmp/db2_install_tuser.log".
$ cat /tmp/db2_install_tuser.log
DB2 Setup log file started at: Mon Oct 11 12:38:21 2010 BST
============================================================
Operating system information: Linux 2.6.18-194.11.3.el5.#1 SMP
Mon Au
23 15:51:38 EDT 2010 x86_64
ERROR:DBI1135E The primary group 't_grp' of user ID 'tuser' is
invalid.
The error shows on point 4. that "_" character should be
allowed:
DBI1135E The primary group '"<users>"' of user ID
'"<test-user>"' is
invalid.
Explanation:
The primary group name of the instance user ID:
1. Cannot be one of "guests", "admins", "users" or "local".
2. Cannot start with "sql" or "ibm".
3. Cannot start with a numeral number.
4. Can contain only lowercase letters (a-z), numbers (0-9), and
the
underscore character ( _ ).
After applying the fix, the '_' character will be valid for both
root and non-root installs. | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * db2_install fails with a major error in a non root install * * if the group name for the user performing the installation * * * * contains the '_' character. * * * * * * In this example the user is tuser and the group is t_grp * * * * * * * * cd to install path * * * * * * * * su - tuser * * * * * * * * * * * * $ ./db2_install -p ESE * * * * DBI1244I Directory for non-root installation of DB2 - * * * * * * * * /home/tuser/sqllib * * * * * * * * * * * * A major error occurred during the execution that caused this * * * * program * * * * terminate prematurely. If the problem persists, contact your * * * * technica * * * * service representative. * * * * * * * * * * * * * * * * For more information see the DB2 installation log at * * * * * * * * "/tmp/db2_install_tuser.log". * * * * * * * * * * * * * * * * * * * * * * * * $ cat /tmp/db2_install_tuser.log * * * * * * * * * * * * DB2 Setup log file started at: Mon Oct 11 12:38:21 2010 BST * * * * * * * * ============================================================ * * * * * * * * * * * * * * * * Operating system information: Linux 2.6.18-194.11.3.el5.#1 * * SMP * * Mon Au * * * * 23 15:51:38 EDT 2010 x86_64 * * * * * * * * ERROR:DBI1135E The primary group 't_grp' of user ID 'tuser' * * is * * invalid. * * * * * * * * * * * * * * * * The error shows on point 4. that "_" character should be * * * * allowed: * * * * * * * * DBI1135E The primary group '"<users>"' of user ID * * * * '"<test-user>"' is * * * * invalid. * * * * * * * * Explanation: * * * * * * * * The primary group name of the instance user ID: * * * * 1. Cannot be one of "guests", "admins", "users" or "local". * * * * 2. Cannot start with "sql" or "ibm". * * * * 3. Cannot start with a numeral number. * * * * 4. Can contain only lowercase letters (a-z), numbers (0-9), * * and * * the * * * * underscore character ( _ ). * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.5 and Fix Pack 7 * **************************************************************** | |
| Local Fix: | |
| available fix packs: | |
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows | |
| Solution | |
Problem was first fixed in DB2 Version 9.5 and Fix Pack 7 | |
| Workaround | |
not known / see Local fix | |
| BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC72174 IC72175 IC72289 follow-up : | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.10.2010 15.11.2010 15.11.2010 |
| Problem solved at the following versions (IBM BugInfos) | |
9.5. | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.1.0.7 |
|
| 9.5.0.7 |
|