DB2 move fenced user home directory

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... Read more →

How to find the DB2 installation path using db2ls

Question: Is there a DB2 utility to find the DB2 installation path? The utility should also return installation date and other useful information. I need this utility to run on Linux. Answer: From DB2 9.5 , the db2ls command is available. On a typical installation of a DB2 server, a symbolic link is added to the /usr/local/bin path. A different resultset returns, depending on the installation. If you execute db2ls as root, only root installations are returned. If you execute as a non-root , the recordset includes DB2 installations by root and the DB2 installations completed by the id. The... Read more →