5,888
社区成员
发帖
与我相关
我的任务
分享使用db2look导出ddl时用户不正确
我现在想将IBM rs6000 (AIX系统) 下的db2数据库迁移到windows平台上。我要迁移的实例名称为：db2cred, 实例用户名也是db2cred，但是数据库用户为stat。 我使用下面的方式导出DDL时不知道为什么总是自动切换到了db2cred用户名下，但是我想导出的是和用户stat相关的数据库ddl。下面是具体的操作过程和提示信息，请问我在哪里出错了？谢谢
db2cred:/db2home/db2cred>db2 connect to credit user stat using vbnmn
Database Connection Information
Database server = DB2/6000 7.1.0
SQL authorization ID = STAT
Local database alias = CREDIT
db2cred:/db2home/db2cred>db2look -d credit -e -o ddlfile -i stat -w vbnmn
% No userid was specified, db2look tries to use Environment variable USER
% USER is: DB2CRED
% Creating DDL for table(s)
% Output is sent to file: ddlfile.sql
db2cred:/db2home/db2cred>db2 connect to credit user stat using vbnmn
Database Connection Information
Database server = DB2/6000 7.1.0
SQL authorization ID = STAT
Local database alias = CREDIT
db2cred:/db2home/db2cred>db2look -d credit -e -o ddlfile -i stat -w vbnmn
% No userid was specified, db2look tries to use Environment variable USER
% USER is: DB2CRED
% Creating DDL for table(s)
% Output is sent to file: ddlfile.sql
...全文
请发表友善的回复…
发表回复
zhaojianmi1 2011-03-22
- 打赏
- 举报
加上-u 用户名
chenshl11 2011-03-22
- 打赏
- 举报
请问为什么会有% No userid was specified, db2look tries to use Environment variable USER
