DB2 数据库编目问题反复出现
DB2 数据库在连接时,C:\db2\db2prd\db2_software\BIN>db2 connect to prd
提示:
SQL1031N The database directory cannot be found on the indicated file system.
SQLSTATE=58031
经查询,是编目的问题,处理办法:
C:\db2\db2prd\db2_software\BIN>db2 catalog db prd on e:\db2\prd
SQL6028N Catalog database failed because database "prd" was not found in the
local database directory.
用catalog命令,但是执行这条命令要好几个小时才能完成,有时还不能完成,完成之后,编目问题时不时的出现,无法根除。请问有人碰到过类似的问题吗?