|
Problem IT38534
|
Status: Closed |
DB2ICRT CREATES / CHANGES .PROFILE OF THE INSTANCE OWNER TO HAVEA GROUP OF THE FENCED USER SPECIFIED WITH IT.
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
On Db2 V11.1.4.6 and later, when we create a Db2 instance with
db2icrt command , we see the
following behavior:
1. Create a user to be an instance owner.
# useradd db2inst1
# ls -la /home/db2inst1
total 20
drwx------ 2 db2inst1 db2inst1 90 Sep 15 20:20 .
drwxr-xr-x. 9 root root 113 Sep 15 20:20 ..
-rw-r--r-- 1 db2inst1 db2inst1 18 Dec 4 2020 .bash_logout
-rw-r--r-- 1 db2inst1 db2inst1 141 Dec 4 2020 .bash_profile
-rw-r--r-- 1 db2inst1 db2inst1 376 Dec 4 2020 .bashrc
-rw-r--r-- 1 db2inst1 db2inst1 172 Feb 6 2020 .kshrc
-rw-r--r-- 1 db2inst1 db2inst1 658 Mar 3 2020 .zshrc
2. Create an instance with a db2icrt command as follows.
# ./db2icrt -u db2fenc1 db2inst1
3. After that, a .profile file was generated, and its group was
the one for the fenced user.
# ls -la /home/db2inst1
total 28
drwxr-xr-x 6 db2inst1 db2inst1 161 Sep 15 21:25 .
drwxr-xr-x. 9 root root 113 Sep 15 20:20 ..
-rw-r--r-- 1 db2inst1 db2inst1 18 Dec 4 2020 .bash_logout
-rw-r--r-- 1 db2inst1 db2inst1 141 Dec 4 2020 .bash_profile
-rw-r--r-- 1 db2inst1 db2inst1 526 Sep 15 21:25 .bashrc
drwxrwxr-x 3 db2inst1 db2inst1 19 Sep 15 21:25 .config
drwxrwxr-x 3 db2inst1 db2inst1 17 Sep 15 21:25 .ibm
-rw-r--r-- 1 db2inst1 db2inst1 172 Feb 6 2020 .kshrc
drwxrwxr-x 3 db2inst1 db2inst1 19 Sep 15 21:25 .local
-rw-r--r-- 1 db2inst1 db2fenc1 169 Sep 15 21:25 .profile
drwxrwsr-t 18 db2inst1 db2inst1 4096 Sep 15 21:25 sqllib
-rw-r--r-- 1 db2inst1 db2inst1 658 Mar 3 2020 .zshrc
The group of the .profile of the instance owner should be the
one for the instance owner itself, but it becomes the one for
the fenced user. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.1.4.7 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.1.4.7 *
**************************************************************** |
| Comment |
Upgrade to 11.1.4.7 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.09.2021
17.04.2022
17.04.2022 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
