如何删除list db directory命令列出的条目

wangzhonnew

doubt if it's the correct way just uncatalog it.... if you didn't use "drop db" command instead just delete the data file, the db information still exist in local sqldbdir, so if you do "db2 list db directory on <database path>", the information will still be there.... "uncatalog db" just remove the entry in ~/sqllib/sqldbdir/sqldbdir, not remove the entry in local sqldbdir file....

diablo2

原帖由 wangzhonnew 于 2008-4-17 19:21 发表
doubt if it's the correct way just uncatalog it.... if you didn't use "drop db" command instead just delete the data file, the db information still exist in local sqldbdir, so if you do "db2 list db directory on ", the information will still be there.... "uncatalog db" just remove the entry in ~/sqllib/sqldbdir/sqldbdir, not remove the entry in local sqldbdir file....

lovelyman_gold

study it

gulangduhu

wangzhonnew 发表于 2008-4-17 19:21
doubt if it's the correct way just uncatalog it.... if you didn't use "drop db" command instead just ...

if so, how to remove the entry? drop the db?

gulangduhu

wangzhonnew 发表于 2008-4-17 19:21
doubt if it's the correct way just uncatalog it.... if you didn't use "drop db" command instead just ...

if we drop the wrong entry by drop database dbname, it will return error as below:

SQL1036C  An I/O error occurred while accessing the database.  SQLSTATE=58030

Any idea?

wangzhonnew

gulangduhu 发表于 2012-1-12 16:11
if we drop the wrong entry by drop database dbname, it will return error as below:

SQL1036C  An ...

can you show some screenshot about the scenario that you are talking about?
include all input/output/list db dir/ls -laR stuff

ab5669

db2 uncatalog database <database name>

omoko

GOOD