Question

db2 调用存储过程，报错：SQL1646N 无法访问sqllib

使用的是数据库的另一个用户。已对改用户赋权，请问是那里的错误？

使用db2inst1用户登录数据库，做了如下操作：
connect to db2
db2 grant dataaccess on database to user tempuser
db2 grant dbadm on database to user tempuser
db2 grant secadm on database to user tempuser

Answer 1

帮一下包试试？
db2 terminate
db2 CONNECT TO dbname user USERID using PASSWORD
db2 BIND path\db2schema.bnd BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUE
db2 BIND path\@db2ubind.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
db2 BIND path\@db2cli.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
db2 terminate

where dbname represents the name of a database to which the files should be bound, and where path is the full path name of the directory where the bind files are located, such as INSTHOME\sqllib\bnd where INSTHOME represents the home directory of the DB2 instance. db2ubind.lst and db2cli.lst contain lists of required bind files used by DB2 database products. Packages that are already bound will return an SQL0719N error. This is expected.