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 ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 Instance 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 Instance 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 Instance 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 Instance PID:210(db2syscs.exe) TID:286 Appid:none database_utilities sqlubreadreg Probe:50 DiagData 01e1 ffff .áÿÿ 2003-08-14-08.20.54.031000 Instance PID:210(db2syscs.exe) TID:286 Appid:none database_utilities sqlubreadreg Probe:32 DiagData 0200 .. 2003-08-14-08.20.54.187000 Instance PID:210(db2syscs.exe) TID:286 Appid:none database_utilities sqlubreadreg Probe:29 DiagData 1b00 .. 2003-08-14-08.20.54.343000 Instance PID:210(db2syscs.exe) TID:286 Appid:none database_utilities sqlubreadreg Probe:30 DiagData 00 . 2003-08-14-08.20.54.515000 Instance PID:210(db2syscs.exe) TID:286 Appid:none database_utilities sqlubreadreg Probe:31 DiagData ef00 0000 ï... 2003-08-14-08.20.54.671000 Instance PID:210(db2syscs.exe) TID:286 Appid:none database_utilities sqlubreadreg Probe:33 DiagData 0000 2100 ..!. 2003-08-14-08.20.54.890000 Instance 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 Instance PID:210(db2syscs.exe) TID:286 Appid:none database_utilities sqlubreadreg Probe:2228 01e1 ffff 0100 0000 .áÿÿ.... 2003-08-14-08.20.55.687000 Instance 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 Instance PID:210(db2syscs.exe) TID:533 Appid:*LOCAL.DB2.030808082604 database_utilities sqlubcka Probe:0 Database:BO_REP Backup terminated. |
| ||||
| 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 Instance > PID:210(db2syscs.exe) TID:286 Appid:none > buffer_pool_services sqlbReadPage Probe:1140 > DIA3700C A bad page was encountered. > > ZRC=0xFFFFE101 |