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"}}]
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.
Was this topic helpful?
Document Information
Modified date:
30 April 2025
UID
swg21983800