Troubleshooting
Problem
SQL30082N rc=3 error while connecting to the local database in a DPF environment
Symptom
Following error will be returned:
SQL30082N Security processing failed with reason "3" ("PASSWORD MISSING"). SQLSTATE=08001
Cause
The error can be caused by a mismatch between hostname specified in db2nodes.cfg and the hostname being returned from getaddrinfo().
Environment
DPF
Diagnosing The Problem
In DPF environment, the local connection to a database works successfully against certain database partitions on certain physical servers. Connection to the same local database from different database partition on other physical servers may with SQL30082N rc=3.
Example:
- export DB2NODE=10 --> Partition 10 exists on server A
db2 terminate
DB20000I The TERMINATE command completed successfully.
db2 connect to sample
SQL30082N Security processing failed with reason "3" ("PASSWORD MISSING"). SQLSTATE=08001
Same connection works on server B
- export DB2NODE=18 -> Partition 18 exists on server B
db2 terminate
DB20000I The TERMINATE command completed successfully.
db2 connect to sample
Database Connection Information
Database server = DB2/AIX64 9.7.4
SQL authorization ID = PSAEPI02
Local database alias = DPPSAEP
Resolving The Problem
Ensure all hostnames used in db2nodes.cfg exist in /etc/hosts file on all servers in the DPF environment. The IP address, and the order of short and long name of these servers should be consistent across all of the servers.
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21645024