"SQL30082N Security processing failed with reason "26" ("UNEXPECTEDSERVER ERROR"). SQLSTATE=08001"

Troubleshooting

Problem

One possible root cause of the SQL30082N error with reason code "26".

Symptom

When you encounter a SQL30082N error while executing DB2 commands such as db2 connect to db, check whether your db2diag.log contains the following messages:

PID : 5571008 TID : 63930 PROC : db2sysc 0
INSTANCE: DB2INST1    NODE : 000 DB : MYDB1
APPHDL : 0-48709 APPID: *LOCAL.db2inst1.160407172148
AUTHID : DB2INST1
EDUID : 63930 EDUNAME: db2agent (MYDB1) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_insert_authinfo, probe:100
RETCODE : ZRC=0x805C0177=-2141453961=SQLEX_PLGN_SRV_CON_UNEXPECTED_ERROR
  "The server security plugin encountered an unexpected error"

2016-04-07-14.21.18.429066-240 I917383858A548 LEVEL: Error
PID : 5571008 TID : 63930 PROC : db2sysc 0
INSTANCE: DB2INST1    NODE : 000 DB : MYDB1
APPHDL : 0-48709 APPID: *LOCAL.DB2INST1.160407172148
AUTHID : DB2INST1
EDUID : 63930 EDUNAME: db2agent (MYDB1) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_set_authinfo, probe:150
RETCODE : ZRC=0x805C0177=-2141453961=SQLEX_PLGN_SRV_CON_UNEXPECTED_ERROR
"The server security plugin encountered an unexpected error"

2016-04-07-14.21.18.787947-240 E917384407A906 LEVEL: Error
PID : 5571008 TID : 63930 PROC : db2sysc
INSTANCE: DB2INST1    NODE : 000 DB : MYDB1
EDUID : 63930 EDUNAME: db2agent (MYDB1) 0
FUNCTION: DB2 UDB, database application extension for utili,
adminotm_online_table_move, probe:22423
DATA #1 : String, 8 bytes
MRT_MYDB1
DATA #2 : String, 15 bytes
F_CRED_FCLT_MTH
DATA #3 : String, 4 bytes
MOVE
DATA #4 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30082 sqlerrml: 27
sqlerrmc: 26 UNEXPECTED SERVER ERROR
sqlerrp : SQL0907B
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 08001

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DB2 Tools - Troubleshooting","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;10.1;10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

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 the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

link to actual document

Was this topic helpful?

Document Information

More support for:
Db2 for Linux, UNIX and Windows

Software version:
9.7, 10.1, 10.5

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows

Document number:
279995

Modified date:
30 April 2025

UID

swg21983800

IBM Support

Tips