SQL30082N rc=3 error while connecting to the database

Technote (troubleshooting)


Problem(Abstract)

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

SQL30082N

Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows
Operating System Security - DCE/Authentication

Software version:

9.5, 9.7, 9.8, 10.1, 10.5

Operating system(s):

AIX, Linux, Solaris

Software edition:

Advanced Enterprise Server, Enterprise Server

Reference #:

1645024

Modified date:

2013-08-15

Translate my page

Machine Translation

Content navigation