RE: Backup Failure

RE: Backup Failure

 

  

Hi,

"ZRC=0x83000024" tells us that some Unexpected Operating System error
has occurred, little difficult to say what is root cause.

Backup db2diag.log, create fresh copy.
Run that scheduled job again after re-bouncing DB2 instance.

Let us know if you get same error again.

Cheers
Durgesh

-----Original Message-----
From: Harish Reddy V.
[mailto:db2udbdba-ezmlmshield-x35438910.[Email address protected]
Sent: Friday, September 29, 2006 10:33 AM
To: LazyDBA Discussion
Subject: Backup Failure

Hi All,



Today morning I have observed that my instance is down because of a
backup failure on my development database (DEVDB). We have scheduled a
backup script which runs overnight everyday to backup DEVDB database and
I have not come across this kind of failure before. We are currently
using DB2 UDB 8.1.6 on Solaris. Please find the error message below from
db2diag.log

************************************************************************
*



2006-09-28-17.02.28.100662 Instance:db2inst1 Node:000

PID:11470(db2agent (DEVDB) 0) TID:1
Appid:*LOCAL.db2inst1.030C18160213

database utilities sqlubcka Probe:0 Database:DEVDB



Starting a full database backup.



2006-09-28-17.03.48.969835 Instance:db2inst1 Node:000

PID:19720(db2bp) TID:1 Appid:none

database utilities sqlubckp Probe:26



DiagData

0x000000010023E440 : FFFF 8A7E 3137 FF55 4E53 5550 504F 5254
...~17.UNSUPPORT

0x000000010023E450 : 4544 2046 554E 4354 494F 4EFF 00 ED
FUNCTION..



2006-09-28-17.11.55.955883 Instance:db2inst1 Node:000

PID:11470(db2agent (DEVDB) 0) TID:1
Appid:*LOCAL.db2inst1.030C18160213

database utilities sqlubPollMsg Probe:1 Database:DEVDB



DiagData

0x00000002311509E8 : 0xFFFFFB38 ...8



2006-09-28-17.11.56.062547 Instance:db2inst1 Node:000

PID:11470(db2agent (DEVDB) 0) TID:1
Appid:*LOCAL.db2inst1.030C18160213

database utilities sqlubPollMsg Probe:1 Database:DEVDB



0x00000002311509E8 : 0xFFFFFB38 ...8



2006-09-28-17.11.57.076463 Instance:db2inst1 Node:000

PID:11470(db2agent (DEVDB) 0) TID:1
Appid:*LOCAL.db2inst1.030C18160213

database utilities sqlubcka Probe:140 Database:DEVDB



Backup Terminated.



2006-09-28-17.14.12.369817 Instance:db2inst1 Node:000

PID:23595(db2sysc 0) TID:1 Appid:none

routine_infrastructure sqlerKillAllFmps Probe:5



Bringing down all db2fmp processes as part of db2stop

0xFFFFFFFF7FFFE45C : 0x00000000 ....



2006-09-28-17.14.12.462591 Instance:db2inst1 Node:000

PID:20235(db2fmp (idle) 0) TID:1 Appid:none

common communication sqlccipcdarihandshake Probe:3



DIA0001E An internal error occurred. Report the following error code :

"ZRC=0x83000024".



2006-09-28-17.14.12.464937 Instance:db2inst1 Node:000

PID:3009(db2fmp (idle) 0) TID:1 Appid:none

common communication sqlccipcdarihandshake Probe:3



DIA0001E An internal error occurred. Report the following error code :

"ZRC=0x83000024".



2006-09-28-17.14.13.071702 Instance:db2inst1 Node:000

PID:10168(db2stop2) TID:1 Appid:none

base sys utilities DB2StopMain Probe:911



ADM7514W Database manager has stopped.





Can someone let me know what could be the possible reason for my backup
failure?



Appreciate any kind of inputs on this. Thanks in advance.



Regards,

Harish Reddy. V







---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DISCLAIMER:
This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.

DB2 & UDB email list listserv db2-l LazyDBA home page