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?
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:
26 (UNEXPECTED SERVER ERROR)
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.