删除DB2数据库时出现问题 [英] Issue Removing DB2 Database
问题描述
所以我搞砸了.我试图释放一些磁盘空间,并意外删除了连接到数据库/启动数据库所需的日志DB2.之前我曾遇到过这种情况,所以我取消了数据库的目录并删除了磁盘上的文件,以便重新创建它.但是,当我重新创建数据库时,会得到:
So I screwed up. I was trying to free up some disk space and accidentally deleted logs DB2 needed to connect to/start my database. I'd run into this before, so I uncataloged the database and deleted the files on disk so I could recreate it. However, when I go to recreate the database, I get:
SQL1005N数据库别名"BGTRUNK"已存在于任一本地计算机中.数据库目录或系统数据库目录.
db2列表数据库目录显示该目录已消失.我看到的所有其他搜索内容都建议重新添加和删除数据库,但这显然不是现阶段的选择.
db2 list database directory shows that it's gone. Everything else I saw searching around suggests recatalogging and dropping the db, but that's obviously not an option at this stage.
如何释放此别名以供重用?
How can I free this alias up for reuse?
推荐答案
我终于能够找到解决方法.问题是我删除了包含数据库的SQL000 *文件夹,但是数据库别名仍在SQLDBDIR文件中进行了分类.我不能仅仅删除并重新开始,因为这样做会丢失其他几个数据库.通过重新编目数据库并运行
I was finally able to find a workaround. The issue was that I had deleted the SQL000* folder that contained the database, but the database alias was still cataloged in the SQLDBDIR file. I couldn't just delete and start fresh because I had several other databases that would be lost by doing so. I was able to see what it used to be called by re-cataloging the database and running
db2列出C:\上的db目录
db2 list db directory on C:\
其输出如下:
Database 3 entry:
Database alias = BGTRUNK
Database name = BGTRUNK
Database directory = SQL00002
Database release level = f.00
Comment =
Directory entry type = Home
Catalog database partition number = 0
Database member number = 0
SQL00002不再存在,但是我使用我拥有的一个数据库中的数据重新创建了它.足以说服db2该数据库存在,因此我可以成功删除该数据库.
SQL00002 didn't exist anymore, but I recreated it using data from one of the databases that I had. That was enough to convince db2 that the database existed so I could successfully drop.
这篇关于删除DB2数据库时出现问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!