IT分销/经销Db2连接sql30082n

DB2数据库连接问题求助

db2inst1@linux-o2dw:~> db2 connect to sample user db2inst1 using db2inst1   Database Connection Information Database server        = DB2/LINUXX8664 10.5.5 SQL authorization ID   = DB2INST1 Local datab...显示全部

db2inst1@linux-o2dw:~> db2 connect to sample user db2inst1 using db2inst1

   Database Connection Information

Database server        = DB2/LINUXX8664 10.5.5

SQL authorization ID   = DB2INST1

Local database alias   = SAMPLE

db2inst1@linux-o2dw:~> db2 -td@ -vf /opt/db2/1.db2_database.sql

drop database sample

SQL30082N  Security processing failed with reason "3" ("PASSWORD MISSING").  

SQLSTATE=08001

CREATE DATABASE sample USING CODESET UTF-8 TERRITORY US CATALOG TABLESPACE MANAGED BY SYSTEM USING ( '/oradata/catlogspace'  ) EXTENTSIZE 32 PREFETCHSIZE 64 USER TABLESPACE MANAGED BY SYSTEM USING ('/oradata/usertablespace') EXTENTSIZE 32 PREFETCHSIZE 64 TEMPORARY TABLESPACE MANAGED BY SYSTEM USING ('/oradata/tempspace') EXTENTSIZE 32 PREFETCHSIZE 64

SQL1047N  The application is already connected to another database.

收起
参与36

查看其它 8 个回答wangyax的回答

wangyaxwangyax软件开发工程师金融机构

    drop db最好还是在实例用户下drop比较好,不建议通过客户端的方式进行操作。

互联网服务 · 2015-10-20
浏览1895

回答者

wangyax
软件开发工程师金融机构

wangyax 最近回答过的问题

回答状态

  • 发布时间:2015-10-20
  • 关注会员:8 人
  • 回答浏览:1895
  • X社区推广