IBM Support

SQl30060N error during rebind.

Troubleshooting


Problem

Using db2rbind command after migrating from V8 to V9.1 or above, may receive the following error while binding CLI packages: SQL30060N "" does not have the privilege to perform operation "0x2203".SQLSTATE=08004 CLI based applications also receive the same message while accessing data. Error message in Notify log/db2diag.log: ADM13001E Plug-in "IBMOSgroups" received error code "-1" from the DB2 security plug-in API "db2secGetGroupsForUser" with the error message " ".

Symptom

Error message

Cause

The issue could be due to the CLI and Utilities packages bound with a different user. ACTION REPLACE opton will recreate the packages.

Resolving The Problem

Bind the CLI packages and utilities with ACTION REPLACE option.

As the instance owner, run the following commands:

cd <Instance home>/sqllib/bnd

    1. db2 terminate
    2. db2 connect to <database name>
    3. db2 bind @db2cli.lst blocking all grant public action replace sqlerror continue
    4. db2 bind @db2ubind.lst blocking all grant public action replace sqlerror continue
    5. db2 bind db2schema.bnd blocking all grant public action replace sqlerror continue
    6. db2 terminate

Related Information

SQl30060N

Bind:

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

Document Information

Modified date:
16 June 2018

UID

swg21383278

Page Feedback