IBM Support

IC72174: DB2_INSTALL FAILS WITH ERROR:DBI1135E ON NON ROOT INSTALL IF GROUP NAME CONTAINS '_' CHARACTER

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • db2_install fails with the following 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.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * This APAR will address db2 installer rules to be in line     *
    * with the documentation.                                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 and Fix Pack 4                    *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 Version 9.7 and Fix Pack 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC72174

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-10-25

  • Closed date

    2011-04-28

  • Last modified date

    2011-04-28

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

    IC72129

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC72174

Modified date: 28 April 2011