Troubleshooting
Problem
When I try running the db2look command I receive error SQL30082 rc=26. How do I resolve this?
Symptom
N/A
Environment
Resolving The Problem
What does error SQL30082 reason code 26 mean?
It means:
SQL30082N Security processing failed with reason reason-code (reason-string).
Explanation:
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.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21429994