db2 restore db databaseName from Directory如果目录是 nfs 挂载目录，则对我来说不起作用（挂在那里，不执行任何操作，没有错误，没有超时）。有什么想法可以让它工作吗？
- db2 版本 9.7
- 从/到 SuSe 安装
更新一
db2 restore database RATIONAL from /var/lib/edumate/backup2/ TAKEN AT 20110523123431 into RATIO33当我从未安装的状态恢复时，大约需要 1-2 分钟才能成功恢复相同的数据库。
恢复命令永远不会完成。我的意思是它不会给我命令行提示符。但是日志文件......
2011-06-06-12.06.24.567599+600 E4116E482 LEVEL: Info
PID : 1125 TID : 140594982676224PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : RATIO33
APPHDL : 0-18 APPID: *LOCAL.db2inst1.110606020625
AUTHID : DB2INST1
EDUID : 286 EDUNAME: db2agent (RATIO33)
FUNCTION: DB2 UDB, database utilities, sqluxGetDegreeParallelism, probe:816
DATA #1 : <preformatted>
Autonomic BAR - using parallelism = 2.
2011-06-06-12.08.18.594032+600 I4599E427 LEVEL: Severe
PID : 1125 TID : 140597138548480PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-19 APPID: *LOCAL.db2inst1.110606020818
AUTHID : DB2INST1
EDUID : 26 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, buffer pool services, sqlb_counts, probe:90
MESSAGE : max pool id is less than 0 at -1
2011-06-06-12.08.18.599571+600 E5027E638 LEVEL: Error
PID : 1144 TID : 140584019629840PROC : db2acd
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, Health Monitor, HealthIndicator::update, probe:500
MESSAGE : ADM10500E Health indicator "Database Heap Utilization"
("db.db_heap_util") breached the "upper" alarm threshold of "95 %"
with value "101 %" on "database" "db2inst1.RATIO33 ". Calculation:
"((db.db_heap_cur_size/db.db_heap_max_size)*100);" = "((31981568 /
31522816) * 100)" = "101 %". History (Timestamp, Value, Formula):
"()"
2011-06-06-12.18.18.801386+600 I5666E427 LEVEL: Severe
PID : 1125 TID : 140597138548480PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-32 APPID: *LOCAL.db2inst1.110606021818
AUTHID : DB2INST1
EDUID : 26 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, buffer pool services, sqlb_counts, probe:90
MESSAGE : max pool id is less than 0 at -1
2011-06-06-12.18.22.146592+600 I6094E433 LEVEL: Warning
PID : 1125 TID : 140596941416192PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2sysc
FUNCTION: DB2 UDB, fast comm manager, sqkfDynamicResourceMgr::AdjustResources, probe:100
MESSAGE : FCM Automatic/Dynamic Resource Adjustment (Channel): 1280 will be
released; new total will be 3840
2011-06-06-12.28.18.088276+600 I6528E427 LEVEL: Severe
PID : 1125 TID : 140597138548480PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-46 APPID: *LOCAL.db2inst1.110606022818
AUTHID : DB2INST1
EDUID : 26 EDUNAME: db2agent (instance)
FUNCTION: DB2 UDB, buffer pool services, sqlb_counts, probe:90
MESSAGE : max pool id is less than 0 at -1
当我按下 CTRL+CI 时，得到了。有趣的是，我没有得到命令行提示符。
2011-06-06-12.36.06.245883+600 E7510E922 LEVEL: Severe
PID : 1125 TID : 140594982676224PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : RATIO33
APPHDL : 0-18 APPID: *LOCAL.db2inst1.110606020625
AUTHID : DB2INST1
EDUID : 286 EDUNAME: db2agent (RATIO33)
FUNCTION: DB2 UDB, database utilities, sqludPollMsg, probe:119
MESSAGE : SQL2001N The utility was interrupted. The output data may be
incomplete.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2001 sqlerrml: 0
sqlerrmc:
sqlerrp : sqludPol
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
答案1
您是否尝试过查看 db2diag.log？您可以在 sqllib/db2dump/ 目录中找到它，或者只需在命令行中输入 db2diag 即可