home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 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 FixList
9.5.0.7 FixList