IBM Support

DB2Look command returns error SQL30082 rc=26

Technote (troubleshooting)


When I try running the db2look command I receive error SQL30082 rc=26. How do I resolve this?

Resolving the problem

What does error SQL30082 reason code 26 mean?

It means:

SQL30082N Security processing failed with reason reason-code (reason-string).


An error occurred during security processing. The cause of the security error is described by the reason-code and corresponding reason-string value.

The following is a list of reason codes and corresponding reason strings:


The server security plugin encountered an unexpected error. The administration notification log file on the server contains more specific problem information. The following are examples of issues that can cause problems:

  • The security service was not started.
  • The userid starting the DB2 service did not have admin privileges.

To resolve this issue please do the following steps:

1.) Connect to the database

2.) CD to \SQLLIB\bnd\ directory.

3.) Run: db2 bind db2look.bnd grant public blocking all

4.) Run: db2 bind db2lkfun.bnd grant public blocking all

5.) Run: db2 terminate

6.) Rerun the db2look command and the error should be gone.

Document information

More support for: DB2 for Linux, UNIX and Windows
DB2 Tools - db2look

Software version: 9.1, 9.5, 9.7

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

Reference #: 1429994

Modified date: 22 June 2010

Translate this page: