Troubleshooting
Problem
Runing db2look against a database that the instance user ID did not create may fail with the following error: Example : $ db2look -d SAMPLE >><< Error Message = SQL0031C File "PATH/db2lkfun.bnd" could not be opened.
Cause
This can happen typically if a restore of a database is done under DB2 V9.7, and the instance ID is not the same as it used to be in the other version, or it could happen if the db2 instance user did not create the database.
Resolving The Problem
In releases prior to DB2 Version 9.7, SYSADM authority included implicit DBADM authority and also provided the ability to grant and revoke all authorities and privileges. Starting in DB2 Version 9.7, the DB2 authorization model has been updated to clearly separate the duties of the system administrator, the database administrator, and the security administrator. As part of this enhancement, the abilities given by the SYSADM authority have been reduced.
In Version 9.7, only SECADM authority provides the ability to grant and revoke all authorities and privileges.
Make sure that the instance user has DBADM authority on the database db2look is being run against:
Example:
db2 "GRANT DBADM ON DATABASE TO USER <USERID>"
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21579207