прошло более суток - восстановление идет. в db2diag.log идет только вот это -
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
2008 - 01 - 08 - 18 . 32 . 16 . 432633 + 360 I1849543A373 LEVEL: Warning
PID : 27813 TID : 2199111613952PROC : db2agent (ZRNION61) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0 - 458 APPID: *LOCAL.db2inst1. 080108123219
AUTHID : DB2INST1
FUNCTION: DB2 UDB, base sys utilities, sqleCheckForRestore, probe: 10
RETCODE : ZRC=0xFFFFFBA1=- 1119
2008 - 01 - 08 - 18 . 32 . 16 . 432746 + 360 I1849917A381 LEVEL: Warning
PID : 27813 TID : 2199111613952PROC : db2agent (ZRNION61) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0 - 458 APPID: *LOCAL.db2inst1. 080108123219
AUTHID : DB2INST1
FUNCTION: DB2 UDB, base sys utilities, sqlePrepareForSerialization, probe: 20
RETCODE : ZRC=0xFFFFFBA1=- 1119
2008 - 01 - 08 - 18 . 32 . 16 . 432834 + 360 I1850299A361 LEVEL: Severe
PID : 27813 TID : 2199111613952PROC : db2agent (ZRNION61) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0 - 458 APPID: *LOCAL.db2inst1. 080108123219
AUTHID : DB2INST1
FUNCTION: DB2 UDB, base sys utilities, sqleserl, probe: 10
RETCODE : ZRC=0xFFFFFBA1=- 1119
при снапшоте работающих приложений (в данном случае ресторинга) показывает вот такую вот информацию :
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
Application Snapshot
Application handle = 30
Application status = Restoring Database
Status change time = 01 / 07 / 2008 17 : 30 : 44 . 030194
Application code page = 1208
Application country/region code = 0
DUOW correlation token = *LOCAL.db2inst1. 080107113044
Application name = db2bp
Application ID = *LOCAL.db2inst1. 080107113044
Sequence number = 00001
TP Monitor client user ID =
TP Monitor client workstation name =
TP Monitor client application name =
TP Monitor client accounting string =
Connection request start timestamp = 01 / 07 / 2008 17 : 30 : 43 . 991420
Connect request completion timestamp = 01 / 07 / 2008 17 : 30 : 44 . 029562
Application idle time = 1 day 1 hour 6 minutes 26 seconds
CONNECT Authorization ID = DB2INST1
Client login ID = db2inst1
Configuration NNAME of client = db2- 9
Client database manager product ID = SQL09013
Process ID of client application = 26756
Platform of client application = LINUXZ64
Communication protocol of client = Local Client
Inbound communication address = *LOCAL.db2inst1
Database name = ZRNION61
Database path = /home/db2inst1/db2inst1/NODE0000/SQL00002/
Client database alias = ZRNION61
Input database alias = ZRNION61
Last reset timestamp =
Snapshot timestamp = 01 / 08 / 2008 18 : 37 : 10 . 536059
The highest authority level granted =
Coordinating database partition number = 0
Current database partition number = 0
Coordinator agent process or thread ID = 27804
Agents stolen = 0
Agents waiting on locks = 0
Maximum associated agents = 1
Priority at which application agents work = 0
Priority type = Dynamic
Lock timeout (seconds) = - 1
Locks held by application = 0
Lock waits since connect = 0
Time application waited on locks (ms) = 0
Deadlocks detected = 0
Lock escalations = 0
Exclusive lock escalations = 0
Number of Lock Timeouts since connected = 0
Total time UOW waited on locks (ms) = 0
Total sorts = 0
Total sort time (ms) = 0
Total sort overflows = 0
Buffer pool data logical reads = 0
Buffer pool data physical reads = 0
Buffer pool temporary data logical reads = 0
Buffer pool temporary data physical reads = 0
Buffer pool data writes = 0
Buffer pool index logical reads = 0
Buffer pool index physical reads = 0
Buffer pool temporary index logical reads = 0
Buffer pool temporary index physical reads = 0
Buffer pool index writes = 0
Buffer pool xda logical reads = 0
Buffer pool xda physical reads = 0
Buffer pool temporary xda logical reads = 0
Buffer pool temporary xda physical reads = 0
Buffer pool xda writes = 0
Total buffer pool read time (milliseconds) = 0
Total buffer pool write time (milliseconds)= 0
Time waited for prefetch (ms) = 0
Unread prefetch pages = 0
Direct reads = 0
Direct writes = 0
Direct read requests = 0
Direct write requests = 0
Direct reads elapsed time (ms) = 0
Direct write elapsed time (ms) = 0
Number of SQL requests since last commit = 0
Commit statements = 0
Rollback statements = 0
Dynamic SQL statements attempted = 0
Static SQL statements attempted = 0
Failed statement operations = 0
Select SQL statements executed = 0
Xquery statements executed = 0
Update/Insert/Delete statements executed = 0
DDL statements executed = 0
Inactive stmt history memory usage (bytes) = 0
Internal automatic rebinds = 0
Internal rows deleted = 0
Internal rows inserted = 0
Internal rows updated = 0
Internal commits = 0
Internal rollbacks = 0
Internal rollbacks due to deadlock = 0
Binds/precompiles attempted = 0
Rows deleted = 0
Rows inserted = 0
Rows updated = 0
Rows selected = 0
Rows read = 0
Rows written = 0
UOW log space used (Bytes) = 0
Previous UOW completion timestamp = 01 / 07 / 2008 17 : 30 : 44 . 029562
Elapsed time of last completed uow (sec.ms)= 0 . 000000
UOW start timestamp = 01 / 07 / 2008 17 : 30 : 44 . 029562
UOW stop timestamp = 01 / 07 / 2008 17 : 30 : 44 . 029562
UOW completion status =
Open remote cursors = 0
Open remote cursors with blocking = 0
Rejected Block Remote Cursor requests = 0
Accepted Block Remote Cursor requests = 0
Open local cursors = 0
Open local cursors with blocking = 0
Total User CPU Time used by agent (s) = 0 . 000000
Total System CPU Time used by agent (s) = 0 . 010000
Host execution elapsed time = 0 . 000000
Package cache lookups = 0
Package cache inserts = 0
Application section lookups = 0
Application section inserts = 0
Catalog cache lookups = 0
Catalog cache inserts = 0
Catalog cache overflows = 0
Catalog cache high water mark = 0
Workspace Information
Shared high water mark = 0
Total shared overflows = 0
Total shared section inserts = 0
Total shared section lookups = 0
Private high water mark = 0
Total private overflows = 0
Total private section inserts = 0
Total private section lookups = 0
Most recent operation = None
Most recent operation start timestamp =
Most recent operation stop timestamp =
Agents associated with the application = 1
Number of hash joins = 0
Number of hash loops = 0
Number of hash join overflows = 0
Number of small hash join overflows = 0
Statement type =
Statement = Unknown
Section number = 0
Application creator =
Package name =
Consistency Token =
Cursor name =
Statement database partition number = 0
Statement start timestamp =
Statement stop timestamp =
Elapsed time of last completed stmt(sec.ms)= 0 . 000000
Total Statement user CPU time = 0 . 000000
Total Statement system CPU time = 0 . 000000
SQL compiler cost estimate in timerons = 0
SQL compiler cardinality estimate = 0
Degree of parallelism requested = 0
Number of agents working on statement = 0
Number of subagents created for statement = 0
Statement sorts = 0
Total sort time = 0
Sort overflows = 0
Rows read = 0
Rows written = 0
Rows deleted = 0
Rows updated = 0
Rows inserted = 0
Rows fetched = 0
Buffer pool data logical reads = 0
Buffer pool data physical reads = 0
Buffer pool temporary data logical reads = 0
Buffer pool temporary data physical reads = 0
Buffer pool index logical reads = 0
Buffer pool index physical reads = 0
Buffer pool temporary index logical reads = 0
Buffer pool temporary index physical reads = 0
Buffer pool xda logical reads = 0
Buffer pool xda physical reads = 0
Buffer pool temporary xda logical reads = 0
Buffer pool temporary xda physical reads = 0
Blocking cursor = NO
Agent process/thread ID = 27804
Agent Lock timeout (seconds) = - 1
Memory usage for agent:
Memory Pool Type = Application Heap
Current size (bytes) = 65536
High water mark (bytes) = 65536
Configured size (bytes) = 1245184
Бэкап делался в 8.1 FixPack 7. Рестор идет на 9.1.0.3 FixPack 3.
Подскажите пожалуйста, в чем может быть причина долгого восстановления?
