Where can I find answers to correct the error below? IBM messages are not very helpful, neither are the logs.



2007-09-14-13.00.28.982950-240 I597297A491 LEVEL: Error
PID : 21388 TID : 1 PROC : db2agent (DBLIQ001) 0
INSTANCE: db2inst1 NODE : 000 DB : DBLIQ001
APPHDL : 0-598 APPID: A9238A4A.L20C.026E84170025
FUNCTION: DB2 UDB, relation data serv, sqlrr_insert_authinfo, probe:20
RETCODE : ZRC=0x805C0177=-2141453961=SQLEX_PLGN_SRV_CON_UNEXPECTED_ERROR
"Security plugin encountered an unexpected error on the server"


njs75d-0004:/app/home/db2inst1/sqllib/db2dump> db2level
DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL08022"
with level identifier "03030106".
Informational tokens are "DB2 v8.1.0.89", "special_15295", "U800790_15295", and
FixPak "9".
Product is installed at "/opt/IBM/db2/V8.1".

Solaris 8

Thanks

What kind of operation do you try to perform and what is the output produced by DB2?

The answer will depend on which security plug-in you are using. If the plug-in is home-grown, you should add traces/logging there. DB2 won't know what is going on in your own code. If it is an IBM-supplied plug-in, I totally agree with you that the information is not really sufficient. You may want to open a PMR with IBM support - if you have a support contract.

Its an IBM supplied plug-in. The users are logged into the db without any problems. The error occurs when they attempt to call a stored procedure. I can re-create it just by calling the stored procedure on the server. I got some additional info from the notify file, which maybe more helpful.

ADM13001E Plug-in "IBMOSgroups" received error code "-1" from the DB2 security
plug-in API "db2secGetGroupsForUser" with the error message " ".

Thanks