Unix Technical Forum

During BackUp of db2 database v 7.2 I get the error

This is a discussion on During BackUp of db2 database v 7.2 I get the error within the DB2 forums, part of the Database Server Software category; --> During BackUp of db2 database v 7.2 I get the error: SQL0980C A disk error occurred. Subsequent SQL statements ...


Go Back   Unix Technical Forum > Database Server Software > DB2

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-26-2008, 02:32 PM
Behrens
 
Posts: n/a
Default During BackUp of db2 database v 7.2 I get the error

During BackUp of db2 database v 7.2 I get the error:

SQL0980C A disk error occurred. Subsequent SQL statements cannot be
processed


A chkdsk of the hard is ok. A db2dart of the database is also ok.

What could I do??

Can anyone please help me out?
Thanks!


PS:

This is a part of the db2adiag.log
A bad page was encountered.
What should I do?

Dump File:C:\PROGRAMME\SQLLIB\DB2\210286.000 Data:SQLB_PAGE

2003-08-14-08.20.53.296000 InstanceB2 Node:000
PID:210(db2syscs.exe) TID:286 Appid:none
buffer_pool_services sqlbReadPage Probe:73

** Second read was also unsucessful ** 01e1 ffff
...áÿÿ

Dump File:C:\PROGRAMME\SQLLIB\DB2\210286.000 Data:SQLB_PAGE2

2003-08-14-08.20.53.437000 InstanceB2 Node:000
PID:210(db2syscs.exe) TID:286 Appid:none
buffer_pool_services sqlbReadPage Probe:74

** Page off disk *****0000 0000 .....

Dump File:C:\PROGRAMME\SQLLIB\DB2\210286.000 Data:SQLB_PAGE3

2003-08-14-08.20.53.609000 InstanceB2 Node:000
PID:210(db2syscs.exe) TID:286 Appid:none
buffer_pool_services sqlbReadPage Probe:1140
DIA3700C A bad page was encountered.

ZRC=0xFFFFE101

2003-08-14-08.20.53.765000 InstanceB2 Node:000
PID:210(db2syscs.exe) TID:286 Appid:none
database_utilities sqlubreadreg Probe:50

DiagData
01e1 ffff .áÿÿ


2003-08-14-08.20.54.031000 InstanceB2 Node:000
PID:210(db2syscs.exe) TID:286 Appid:none
database_utilities sqlubreadreg Probe:32

DiagData
0200 ..


2003-08-14-08.20.54.187000 InstanceB2 Node:000
PID:210(db2syscs.exe) TID:286 Appid:none
database_utilities sqlubreadreg Probe:29

DiagData
1b00 ..


2003-08-14-08.20.54.343000 InstanceB2 Node:000
PID:210(db2syscs.exe) TID:286 Appid:none
database_utilities sqlubreadreg Probe:30

DiagData
00 .


2003-08-14-08.20.54.515000 InstanceB2 Node:000
PID:210(db2syscs.exe) TID:286 Appid:none
database_utilities sqlubreadreg Probe:31

DiagData
ef00 0000 ï...


2003-08-14-08.20.54.671000 InstanceB2 Node:000
PID:210(db2syscs.exe) TID:286 Appid:none
database_utilities sqlubreadreg Probe:33

DiagData
0000 2100 ..!.


2003-08-14-08.20.54.890000 InstanceB2 Node:000
PID:210(db2syscs.exe) TID:286 Appid:none
database_utilities sqlubreadreg Probe:28

DiagData
01e1 ffff 0100 0000 .áÿÿ....


2003-08-14-08.20.55.093000 InstanceB2 Node:000
PID:210(db2syscs.exe) TID:286 Appid:none
database_utilities sqlubreadreg Probe:2228

01e1 ffff 0100 0000 .áÿÿ....


2003-08-14-08.20.55.687000 InstanceB2 Node:000
PID:210(db2syscs.exe) TID:533 Appid:*LOCAL.DB2.030808082604
oper_system_services sqlormdir Probe:37 Database:BO_REP

9100 0000 '...


2003-08-14-08.20.55.984000 InstanceB2 Node:000
PID:210(db2syscs.exe) TID:533 Appid:*LOCAL.DB2.030808082604
database_utilities sqlubcka Probe:0 Database:BO_REP

Backup terminated.












Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-26-2008, 02:33 PM
klh
 
Posts: n/a
Default Re: During BackUp of db2 database v 7.2 I get the error

You may want to check and make sure that there are no other utility
programs running on the server trying to grab the file. We had a
situation where the network admins were running a utility to backup
all the files on the machine. Then when we tried to run our DB2
backups they would crash. DB2 wants exclusive use of the files. If
there is some other network backup utility running, then exclude all
of the db2 directories from that backup. Then you should be okay.

HTH,
klh
>
> SQL0980C A disk error occurred. Subsequent SQL statements cannot be
> processed
>
>
>



>
> 2003-08-14-08.20.53.609000 InstanceB2 Node:000
> PID:210(db2syscs.exe) TID:286 Appid:none
> buffer_pool_services sqlbReadPage Probe:1140
> DIA3700C A bad page was encountered.
>
> ZRC=0xFFFFE101

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:49 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com