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.
另外我贴上脚本里面的内容 帮忙看看 谢谢
drop database sample
@
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
@
收起楼主把问题再明确一下,是drop数据库报错 ?
收起你把你sql里的drop database sample 拿出来单独执行呢,另外我删库前先停掉db2服务,我习惯先停服务,然后再删库,建库,没出现过这个问题,你可以试试
收起drop databse,create database 不需要连接任何数据库,切换到实例用户就可以执行。
收起