Tuesday, October 26, 2010

DB2 fails to start or issues with connecting to database

Symptom: DB2 may fail to start of you may face issues listing active databases even though DB2 started.

The problem is caused by the DB2 instance home file system being mounted with the "nosuid" option. When this problem occurs, the DB2 instance can be started and the users can connect to the database implicitly, without specifying the user ID and password.This problem can occur if the filesystem is mounted with the nosuid option set and db2start is an suid program.


To resolve this issue, ensure mount where you install DB2 is with NOSUID unset.

Edit the fstab file vi /etc/fstab and change it depending on your needs. 

Link:
http://www-01.ibm.com/support/docview.wss?uid=swg21209278
http://www-01.ibm.com/support/docview.wss?uid=swg21198111
http://www.faqs.org/docs/securing/chap5sec45.html

No comments:

Post a Comment