IBM Support

SQL30082N rc=3 error while connecting to the database

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

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Security \/ Plug-Ins - IBM Suplied\/Default","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.8;9.7;9.5;10.1;10.5","Edition":"Advanced Enterprise Server;Enterprise Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21645024