db2look用法
非实例用户执行时，无法导出表结构，请高人指点？
db2look -d wfisdb -u wfis -t wf_process -e -o wf_process.schema
[H111092:wfis:/home/wfis/log]db2look -d wfisdb -u wfis -t wf_process -e -o wf_process.schema
-- The db2look utility will consider only the specified tables
-- Creating DDL for table(s)
-- Output is sent to file: wf_process.schema
--An error has occured during Binding
Error Message =
SQL0551N "WFIS" does not have the required authorization or privilege to
perform operation "EXECUTE" on object "NULLID.DB2L0H00". SQLSTATE=42501
SQLCA
Size = 136
SQLCODE = -551
Tokens = WFIS ?EXECUTE ?NULLID.DB2L0H00
RDS fn = SQLRA138
RC = 0x801A006D = -2145779603
Reason = 0x0000 = 0
Reason2 = 0x0000 = 0
Line # = -20
Warning flags =
是该用户没有执行db2look权限？
db2look -d wfisdb -u wfis -t wf_process -e -o wf_process.schema
[H111092:wfis:/home/wfis/log]db2look -d wfisdb -u wfis -t wf_process -e -o wf_process.schema
-- The db2look utility will consider only the specified tables
-- Creating DDL for table(s)
-- Output is sent to file: wf_process.schema
--An error has occured during Binding
Error Message =
SQL0551N "WFIS" does not have the required authorization or privilege to
perform operation "EXECUTE" on object "NULLID.DB2L0H00". SQLSTATE=42501
SQLCA
Size = 136
SQLCODE = -551
Tokens = WFIS ?EXECUTE ?NULLID.DB2L0H00
RDS fn = SQLRA138
RC = 0x801A006D = -2145779603
Reason = 0x0000 = 0
Reason2 = 0x0000 = 0
Line # = -20
Warning flags =
是该用户没有执行db2look权限？
2同行回答
权限的问题！
DB2LOOK Authorization
SELECT privilege on the system catalog tables.
In some cases, such as generating table space container DDL, you will require one of the following authorities:
SYSADM
SYSCTRL
SYSMAINT
SYSMON
DBADM
EXECUTE privilege on the ADMIN_GET_STORAGE_PATHS table function收起
DB2LOOK Authorization
SELECT privilege on the system catalog tables.
In some cases, such as generating table space container DDL, you will require one of the following authorities:
SYSADM
SYSCTRL
SYSMAINT
SYSMON
DBADM
EXECUTE privilege on the ADMIN_GET_STORAGE_PATHS table function收起
浏览1596