dba-db2.com - db2 performance tuning, DB2 tuning,db2 performance,sql tuning db2, DBA in DB2, DBA Scripts,DB2,DB2 consulting,DB2 consultant,DB2 architecture,DB2 training

DB2 move fenced user home directory

12 November,2015 by Tom Collins

Question: I’d like to move the DB2 fenced user to a different location. The OS is Linux. There is a bug in the client application which when using DB2 and the fenced user home directory is in the same  path as DB2.

Answer:   It is an easy process . The first step is to find out the fenced user. You can identify the fenced user with the command:

Db2pd –fmp | grep –i fenced

The you can use the Linux command : usermod -m -d /path/to/new/login/home/dir  . This command changes  user home directory to a new login directory.

Option –d creates the directory if it does not exist. Option –m moves the contents of the existing user home directory into the new home directory

Once you’ve completed the usermod change , go back to the db2pd command and verify the fenced user.

 

Read More on Linux and DB2

db2start at start up on Linux - DBA DB2

db2pd troubleshooting guide - DBA DB2

 

Author: Rambler(http://www.dba-db2.com)

Share:

Posted by Tom Collins at 7:45 AM in db2pd, Linux | Permalink | Comments (1)

You can first login into the instance and then run the below command:

cat /home/INSTANCENAME/sqllib/ctrl/.fencedID

after which you can also run the below command to if db2fmp process is running.

ps -ef | grep -i db2fmp

and then run:

db2pd -fmp

Posted by: Monish Patil | Mar 3, 2021 9:47:24 PM

Verify your Comment

Previewing your Comment

Posted by: |

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on DB2 move fenced user home directory

Comments are moderated, and will not appear until the author has approved them.

dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright