|
我这里正好也有一个restore on EEE的问题百思不得其解,既然有人抛砖了我也就顺便问一下:
script:
#! /bin/ksh
# db restore script
db2_all '<<+000< db2 restore db edmu01 use tsm OPEN 2 SESSIONS taken at 20060228090413 with 4 buffers buffer 4096 parallelism 4'
db2_all '<<-000< db2 restore db edmu01 Use tsm taken at 20060228090916 with 4 buffers buffer 4096 parallelism 4'
echo Wait for all background processes to complete
wait
可是不知道为什么第一步可以执行成功(restore node 0),第二步的时候就hang了。(确认TSM中有backup image)
db2diag.log没有任何错误信息,tsm log里没有错误信息,使用list utilites察看进度发现一直停留在completed work=4096(也就是buffer大小),本身数据库不大,等了好几个小时也没有动静。
有没有人见过类似的情况。
===================
已经做过的测试:recycle instance, ipclean+kill -9 on all db2 processes
===================
DB2 Release Info
Server is running MPP/EEE.
DB21085I Instance "dminstu1" uses "32" bits and DB2 code release "SQL08023"
with level identifier "03040106".
Informational tokens are "DB2 v8.1.1.96", "s050811", "U803920", and FixPak
"10".
Product is installed at "/usr/opt/db2_08_01".
--------------
Operating system and level
Operating system is: AIX 5.3.0.0
OSS reports operating system level as: 5.3.
--------------------
EEE node configuration
Number of nodes in db2nodes.cfg is: 5
Current node number is: 0
Node information from the db2nodes.cfg file:
0 rsuedw03 0
1 rsuedw03 1
2 rsuedw03 2
3 rsuedw03 3
4 rsuedw03 4
--------------------
List database directory
LIST DB DIRECTORY
System Database Directory
Number of entries in the directory = 1
Database 1 entry:
Database alias = EDMU01
Database name = EDMU01
Local database directory = /dminstu1/edmu01/dbmgmt
Database release level = a.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL08023
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 00000
----------------------
2006-03-02-12.49.21.809137-300 I1C1186 LEVEL: Event
PID : 233620 TID : 1 PROC : db2agent (EDMU01) 0
INSTANCE: dminstu1 NODE : 000 DB : EDMU01
APPHDL : 0-54 APPID: *N0.dminstu1.060302174745
FUNCTION: DB2 UDB, RAS/PD component, _pdlogInt, probe:120
START : New db2diag.log file
DATA #1 : Build Level, 124 bytes
Instance "dminstu1" uses "32" bits and DB2 code release "SQL08023"
with level identifier "03040106".
Informational tokens are "DB2 v8.1.1.96", "s050811", "U803920", FixPak "10".
DATA #2 : System Info, 220 bytes
System: AIX rsuedw03 3 5 00CA86BE4C00
CPU: total:24 online:6 Threading degree per core:2
Physical Memory(MB): total:11264 free:3919
Virtual Memory(MB): total:17920 free:10565
Swap Memory(MB): total:6656 free:6646
Kernel Params: msgMaxMessageSize:4194304 msgMaxQueueSize:4194304
shmMax:2147483648 shmMin:1 shmIDs:131072 shmSegments:16
semIDs:131072 semNumPerID:65535 semOps:1024 semMaxVal:32767
semAdjustOnExit:16384
Information in this record is only valid at the time when this file was
created (see this record's time stamp)
2006-03-02-12.49.21.806879-300 I1188C419 LEVEL: Warning
PID : 233620 TID : 1 PROC : db2agent (EDMU01) 0
INSTANCE: dminstu1 NODE : 000 DB : EDMU01
APPHDL : 0-54 APPID: *N0.dminstu1.060302174745
FUNCTION: DB2 UDB, database utilities, sqludPrintStartingMsg, probe:1
DATA #1 : String, 52 bytes
Starting a full database restore.
Agent PID: 233620
2006-03-02-12.49.21.822294-300 I1608C439 LEVEL: Severe
PID : 233620 TID : 1 PROC : db2agent (EDMU01) 0
INSTANCE: dminstu1 NODE : 000 DB : EDMU01
APPHDL : 0-54 APPID: *N0.dminstu1.060302174745
FUNCTION: DB2 UDB, database utilities, sqluCompareDB, probe:45
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x405D0CB8 : 0000 09EB ....
2006-03-02-12.53.53.916457-300 I2048C377 LEVEL: Severe
PID : 647428 TID : 1 PROC : db2agent (instance) 0
INSTANCE: dminstu1 NODE : 000 DB : EDMU01
APPHDL : 0-63 APPID: *N0.dminstu1.060302175353
FUNCTION: DB2 UDB, buffer pool services, sqlb_counts, probe:90
MESSAGE : max pool id is less than 0 at -1
------------------
0x000009EB=sql2539
SQL2539W Warning! Restoring to an existing database that is the
same as the backup image database. The database files
will be deleted.
相信不是问题,因为cust已经在restore出现覆盖提示的时候选择了yes |
|