Hi,

happy new year. :-)

Due to upgrade reasons I tried to restore our prod db to our test environment.
The backup ist about 700 GB large and is backup via TSM.

I created a db on our test server similar to the prod db. The restore works fine till 390 GB then I get errors and the restore is stopped.

The Version is DB 7.2 with Fix 7 or Fix 9 on a 4.3.2 AIX.

Below you see the diag log from the part where the errors begin.
---------------------
2004-12-29-12.25.40.633288 Instance:sws1213 Node:000
PID:16066(db2pfchr) Appid:none
oper_system_services sqlowrite Probe:110

errno: 0000 000c ....


2004-12-29-12.25.40.764022 Instance:sws1213 Node:000
PID:16066(db2pfchr) Appid:none
buffer_pool_services sqlbSMSDirectWrite Probe:825
DIA3833C The system memory limit was reached.

ZRC=0xFFFFF624

2004-12-29-12.25.40.937160 Instance:sws1213 Node:000
PID:16066(db2pfchr) Appid:none
buffer_pool_services sqlbSMSDirectWrite Probe:825

Obj={pool:1278;obj:2;type:1} State=x0 Page=49376 Cont=15 Offset=1088 BlkSize=12

Data TitleQLB_OBJECT_DESC PID:16066 Node:000
04fe 0002 0000 0000 0100 0000 0000 0000 .þ..............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0001 0000 0000 0000 0000 ................
0000 1000 0000 0020 0000 0000 0000 0000 ....... ........
0000 0000 0000 0000 ........


2004-12-29-12.25.41.164488 Instance:sws1213 Node:000
PID:40754(db2pfchr) Appid:none
oper_system_services sqlowrite Probe:110

errno: 0000 000c ....


2004-12-29-12.25.41.271992 Instance:sws1213 Node:000
PID:40754(db2pfchr) Appid:none
buffer_pool_services sqlbSMSDirectWrite Probe:825
DIA3833C The system memory limit was reached.

ZRC=0xFFFFF624

2004-12-29-12.25.41.343625 Instance:sws1213 Node:000
PID:40754(db2pfchr) Appid:none
buffer_pool_services sqlbSMSDirectWrite Probe:825

Obj={pool:1278;obj:2;type:1} State=x0 Page=49440 Cont=17 Offset=1088 BlkSize=12

Data TitleQLB_OBJECT_DESC PID:40754 Node:000
04fe 0002 0000 0000 0100 0000 0000 0000 .þ..............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0001 0000 0000 0000 0000 ................
0000 1000 0000 0020 0000 0000 0000 0000 ....... ........
0000 0000 0000 0000 ........


2004-12-29-12.25.41.564657 Instance:sws1213 Node:000
PID:40754(db2pfchr) Appid:none
buffer_pool_services sqlbDirectWrite Probe:830
DIA3833C The system memory limit was reached.

ZRC=0xFFFFF624

2004-12-29-12.25.41.654425 Instance:sws1213 Node:000
PID:40754(db2pfchr) Appid:none
buffer_pool_services sqlbDirectWrite Probe:830

Obj={pool:1278;obj:2;type:1} State=x0

2004-12-29-12.25.41.726108 Instance:sws1213 Node:000
PID:16066(db2pfchr) Appid:none
buffer_pool_services sqlbDirectWrite Probe:830
DIA3833C The system memory limit was reached.

ZRC=0xFFFFF624

Data TitleQLB_OBJECT_DESC PID:40754 Node:000
04fe 0002 0000 0000 0100 0000 0000 0000 .þ..............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0001 0000 0000 0000 0000 ................
0000 1000 0000 0020 0000 0000 0000 0000 ....... ........
0000 0000 0000 0000 ........


2004-12-29-12.25.41.935214 Instance:sws1213 Node:000
PID:40754(db2pfchr) Appid:none
buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0

Prefetcher Error rc = -2524 IGNORED ... err loc 0
. Request follows...

2004-12-29-12.25.42.006968 Instance:sws1213 Node:000
PID:40754(db2pfchr) Appid:none
buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0

type = DIRECTWRITE
numpages = 1
SQLB_OBJECT_DESC: objID: 2 PlId: 1278 objTyp: 1 Ext Anch: 0 plFlgs: 1
pario_cb: 402c6e20 access method: 1 address scheme: 0
read/write flag: 1 flush option: 0 sms file open mode: 0
IO descriptor list:
0 start unit: 49440 number unit: 32 buffer: 409d6200
global flag 16


2004-12-29-12.25.42.303990 Instance:sws1213 Node:000
PID:25556(db2pfchr) Appid:none
oper_system_services sqlowrite Probe:110

errno: 0000 000c ....


2004-12-29-12.25.42.395273 Instance:sws1213 Node:000
PID:16066(db2pfchr) Appid:none
buffer_pool_services sqlbDirectWrite Probe:830

Obj={pool:1278;obj:2;type:1} State=x0

2004-12-29-12.25.42.466982 Instance:sws1213 Node:000
PID:25556(db2pfchr) Appid:none
buffer_pool_services sqlbSMSDirectWrite Probe:825
DIA3833C The system memory limit was reached.

ZRC=0xFFFFF624

2004-12-29-12.25.42.538819 Instance:sws1213 Node:000
PID:25556(db2pfchr) Appid:none
buffer_pool_services sqlbSMSDirectWrite Probe:825

Obj={pool:1278;obj:2;type:1} State=x0 Page=49312 Cont=13 Offset=1088 BlkSize=12

Data TitleQLB_OBJECT_DESC PID:25556 Node:000
04fe 0002 0000 0000 0100 0000 0000 0000 .þ..............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0001 0000 0000 0000 0000 ................
0000 1000 0000 0020 0000 0000 0000 0000 ....... ........
0000 0000 0000 0000 ........


2004-12-29-12.25.42.753972 Instance:sws1213 Node:000
PID:25556(db2pfchr) Appid:none
buffer_pool_services sqlbDirectWrite Probe:830
DIA3833C The system memory limit was reached.

ZRC=0xFFFFF624

2004-12-29-12.25.42.825682 Instance:sws1213 Node:000
PID:25556(db2pfchr) Appid:none
buffer_pool_services sqlbDirectWrite Probe:830

Obj={pool:1278;obj:2;type:1} State=x0

Data TitleQLB_OBJECT_DESC PID:25556 Node:000
04fe 0002 0000 0000 0100 0000 0000 0000 .þ..............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0001 0000 0000 0000 0000 ................
0000 1000 0000 0020 0000 0000 0000 0000 ....... ........
0000 0000 0000 0000 ........


Data TitleQLB_OBJECT_DESC PID:16066 Node:000
04fe 0002 0000 0000 0100 0000 0000 0000 .þ..............
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0001 0000 0000 0000 0000 ................
0000 1000 0000 0020 0000 0000 0000 0000 ....... ........
0000 0000 0000 0000 ........


2004-12-29-12.25.43.160582 Instance:sws1213 Node:000
PID:50430(db2bm.25132.0) Appid:none
database_utilities sqluwritereg Probe:30

DiagData
ffff f817 ffff f624 524f 4f54 5f42 5842 ÿÿø.ÿÿö$ROOT_BXB
3100 1.


2004-12-29-12.25.43.268008 Instance:sws1213 Node:000
PID:50430(db2bm.25132.0) Appid:none
database_utilities sqluwritereg Probe:1230

ffff f817 ffff f624 524f 4f54 5f42 5842 ÿÿø.ÿÿö$ROOT_BXB
3100 1.


2004-12-29-12.25.43.588780 Instance:sws1213 Node:000
PID:25556(db2pfchr) Appid:none
buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0

Prefetcher Error rc = -2524 IGNORED ... err loc 0
. Request follows...

2004-12-29-12.25.43.668523 Instance:sws1213 Node:000
PID:25556(db2pfchr) Appid:none
buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0

type = DIRECTWRITE
numpages = 1
SQLB_OBJECT_DESC: objID: 2 PlId: 1278 objTyp: 1 Ext Anch: 0 plFlgs: 1
pario_cb: 402c6e20 access method: 1 address scheme: 0
read/write flag: 1 flush option: 0 sms file open mode: 0
IO descriptor list:
0 start unit: 49312 number unit: 32 buffer: 40956200
global flag 16


2004-12-29-13.15.28.510615 Instance:sws1213 Node:000
PID:25132(db2agent (ARS01)) Appid:*LOCAL.sws1213.041229080121
oper_system_services sqlowrite Probe:110 Database:ARS01

errno: 0000 000c ....


2004-12-29-13.15.28.609849 Instance:sws1213 Node:000
PID:25132(db2agent (ARS01)) Appid:*LOCAL.sws1213.041229080121
database_utilities sqludrsa Probe:58 Database:ARS01

DiagData


2004-12-29-13.15.28.681535 Instance:sws1213 Node:000
PID:25132(db2agent (ARS01)) Appid:*LOCAL.sws1213.041229080121
database_utilities sqludrsa Probe:0 Database:ARS01

Restore terminated.
---------------------

The environment of the user with whom I restore is unlimited.
Our OS admin and TSM admin haven't found any clue on system side.

I would be glad for any help. Thanks in advance.


Regards,

Oktay

F624 error saying bad configuration file; does your test db config same as or very close to the prod db config? try to make them the same if possible(when it comes to buffersizes etc