如果目录是一个nfs挂载的目录, db2 restore db databaseName from Directory不起作用(在那里挂起,什么也不做,没有错误,没有时间)。 任何想法如何使其工作?
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:
你有没有试图查看db2diag.log? 你可以在sqllib / db2dump /目录下find它,或者在命令行inputdb2diag