IBM Support

Connecting to a remote database may return error SQL30082N rc=24 due to SPM_NAME setting

Troubleshooting


Problem

Connecting to a remote database may return error SQL30082N rc=24 if the db alias is same as SPM_NAME in database manager configure.

Symptom

If you have cataloged a remote database and the database alias is
same with dbm configure parameter SPM_NAME, then error SQL30082N rc=24
may return when you attempt to connect to the database.

For example, you have the following in "db2 get dbm cfg":
SPM name                                     (SPM_NAME) = WIN_NAK8

By default, DB2 sets the first 8 characters from the computer name as SPM_NAME.

C:\Program Files\IBM\SQLLIB_02\BIN>db2 list db directory
 System Database Directory

 Number of entries in the directory = 1

Database 1 entry:

 Database alias                       = WIN_NAK8
 Database name                        = DCSDB400
 Node name                            = T400
 Database release level               = d.00
 Comment                              =
 Directory entry type                 = Remote
 Authentication                       = SERVER
 Catalog database partition number    = -1
 Alternate server hostname            =
 Alternate server port number         =

C:\Program Files\IBM\SQLLIB_02\BIN>db2 connect to win_nak8 user rmtuser
Enter current password for rmtuser:
SQL30082N  Security processing failed with reason "24" ("USERNAME AND/OR
PASSWORD INVALID").  SQLSTATE=08001

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Routines (SP \u0026 UDF) - SQL","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;10.1;10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
30 April 2025

UID

swg21679961

Page Feedback