Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004

    Unanswered: Security Plug-in Problem

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

    2007-09-14- 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
    "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


  2. #2
    Join Date
    Jan 2007
    Jena, Germany
    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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Apr 2004
    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 " ".


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts