Troubleshooting
Problem
After upgrading DB2 to a new fixpack, db2pd started failing with rshd:0826-813 Permission is denied
Symptom
After successfully, installing a newer fixpack, the following db2pd command started failing with the following message :
db2pd -database <db_name> -dbpartitionnum 0
rshd: 0826-813 Permission is denied.
Cause
The /etc/hosts file contained a duplicate entry for the hostname. In one entry the local hostname was used as alias each with a different IP address. See below
$ uname -a
AIX test02 1 6 00F640FA4C00
Entries from /etc/hosts
52.99.88.136 test02-new test02
52.99.88.131 test02
As you can notice, the hostname, test02, is being used as a local host and an alias for two different
hosts.
Diagnosing The Problem
To diagnose the problem, you can verify the following :
- Ensure db2pd you are using is located under $INSHOME/sqllib/adm
- Check the permissions on the db2pd. The permissions should look like this
-r-sr-s--x 1 root build 16198946 Feb 11 13:52 db2pd
- Check the db2nodes.cfg file and make sure the right hostname is specified.
- Check the output from uname -a
- Compare the entries from db2nodes.cfg and uname -a with entries in /etc/hosts file to ensure they match.
- If all checks are good, you can use the following truss command to trace the db2pd command and send the file to IBM DB2 Technical Support.
truss -aef -o truss.out db2pd - -database <database_name> -dbpartitionnum 0
Resolving The Problem
To resolve the problem, ensure the entries in the /etc/hosts file are unique and match the outputs from uname -a and the entry in the db2nodes.cfg if you have one.
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21625185