Hi,
I have a DB2 database (version 7) running on Windows 2000 server and
recently facing problem to backup my database. I got an error "Disk
was full" after half way running the backup. My database size is
about 10GB, I have tried to backup the database into a DDS tape (20GB)
or hardisk (100GB free space) but still getting the same error. So,
there is no possibility that the backup media is full. Anyway, here's
part of db2diag.log file that I captured during the time backup was
failed. You will notice that besides disk full error, there are
prefetcher and buffer pool error as well. Hope it will give some hints
what could be the real cause of this problem.
TQ!!
------------------------------------------------------------------------------------------------
Backing up tablespace TBLSPACE_3
2007-05-28-18.13.43.875000 Instance:DB2 Node:000
PID:1052(db2syscs.exe) TID:4028 Appid:none
database_utilities sqlubbmcont Probe:10
Backing up tablespace TBLSPACE_4
2007-05-28-18.16.50.281000 Instance:DB2 Node:000
PID:1052(db2syscs.exe) TID:1424 Appid:none
oper_system_services sqloread Probe:100
GetLastError: 7000 0000
p...
2007-05-28-18.16.50.484000 Instance:DB2 Node:000
PID:1052(db2syscs.exe) TID:1424 Appid:none
buffer_pool_services sqlbDMSDirectRead Probe:790
DiagData
b8f9 0a62 0200 0000 2000 0000 a07f 0000
¸ù.b.... ... ...
24f9 0a62 0000 0000 0100 0000 0000 0000
$ù.b............
0012 c862 a0cc 5421 ..Èb ÌT!
2007-05-28-18.16.50.750000 Instance:DB2 Node:000
PID:1052(db2syscs.exe) TID:1424 Appid:none
buffer_pool_services sqlbDMSDirectRead Probe:860
DIA3612C Disk was full.
ZRC=0xFFFFD60C
2007-05-28-18.16.50.890000 Instance:DB2 Node:000
PID:1052(db2syscs.exe) TID:1424 Appid:none
buffer_pool_services sqlbDMSDirectRead Probe:860
Obj={pool:6;obj:0;type:0} State=x0 Parent={0;0}, EM=0, PP0=0
Page=32672 Cont=0 Offset=32673 BlkSize=15
2007-05-28-18.16.52.109000 Instance:DB2 Node:000
PID:1052(db2syscs.exe) TID:3836 Appid:none
buffer_pool_services sqlbDirectRead Probe:820
Obj={pool:6;obj:0;type:0} State=x0 Parent={0;0}, EM=0, PP0=0
2007-05-28-18.16.52.171000 Instance:DB2 Node:000
PID:1052(db2syscs.exe) TID:1424 Appid:none
buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0
type = DIRECTREAD
numpages = 1
SQLB_OBJECT_DESC: objID: 0 PlId: 6 objTyp: 0 Ext Anch: 0 plFlgs:
2
pario_cb: 2B7438D0 access method: 2 address scheme: 0
read/write flag: 1 flush option: 0 sms file open mode: 0
IO descriptor list:
0 start unit: 32672 number unit: 32 buffer: 62C81200
global flag 0
2007-05-28-18.16.52.281000 Instance:DB2 Node:000
PID:1052(db2syscs.exe) TID:1776 Appid:none
buffer_pool_services sqlbDMSDirectRead Probe:790
2007-05-28-18.16.52.953000 Instance:DB2 Node:000
PID:1052(db2syscs.exe) TID:3836 Appid:none
buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0
Prefetcher Error rc = -10740 IGNORED ... err loc 0
. Request follows...
2007-05-28-18.16.53.015000 Instance:DB2 Node:000
PID:1052(db2syscs.exe) TID:3836 Appid:none
buffer_pool_services sqlbPFPrefetcherEntryPoint Probe:0
type = DIRECTREAD
numpages = 2
SQLB_OBJECT_DESC: objID: 0 PlId: 6 objTyp: 0 Ext Anch: 0 plFlgs:
2
pario_cb: 2B7438D0 access method: 2 address scheme: 0
read/write flag: 1 flush option: 0 sms file open mode: 0
IO descriptor list:
0 start unit: 32640 number unit: 32 buffer: 62B81200
1 start unit: 32736 number unit: 31 buffer: 62E81200
global flag 0
2007-05-28-18.16.55.109000 Instance:DB2 Node:000
PID:1052(db2syscs.exe) TID:2936 Appid:*LOCAL.DB2.070528070811
database_utilities sqlubcka Probe:172 Database:PANTONDB
Pool has BACKUP_IN_PROGRESS state already OFF:
5359 5343 4154 5350 4143 45
SYSCATSPACE
2007-05-28-18.16.55.265000 Instance:DB2 Node:000
PID:1052(db2syscs.exe) TID:2936 Appid:*LOCAL.DB2.070528070811
database_utilities sqlubcka Probe:172 Database:PANTONDB
Pool has BACKUP_IN_PROGRESS state already OFF:
5445 4d50 5350 4143 4531
TEMPSPACE1
-------------------------------------------------------------------------------------------------
Racerx - 30 May 2007 07:25 GMT
On May 30, 8:36 am, xeqis...@gmail.com wrote:
> Hi,
> I have a DB2 database (version 7) running on Windows 2000 server and
[quoted text clipped - 112 lines]
>
> -------------------------------------------------------------------------------------------------
Hi ,,
What is ur utility heap size??
Racerx - 30 May 2007 07:56 GMT
On May 30, 8:36 am, xeqis...@gmail.com wrote:
> Hi,
> I have a DB2 database (version 7) running on Windows 2000 server and
[quoted text clipped - 112 lines]
>
> -------------------------------------------------------------------------------------------------
also check if there are any ulimit restrictions..
xeqister@gmail.com - 30 May 2007 09:34 GMT
> On May 30, 8:36 am, xeqis...@gmail.com wrote:
>
[quoted text clipped - 118 lines]
>
> - Show quoted text -
Hi,
The setting for utility heap size (4kb) "UTIL_HEAP_SZ" is 79533. My
database is running on Windows 2000 server, should there be any ulimit
restriction? If YES, how do I check. Thanks for your feedback.