If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > disk error during database backup

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-10-05, 15:40
toby25 toby25 is offline
Registered User
 
Join Date: Sep 2003
Posts: 63
disk error during database backup

Hi all,

This is version 8.1 fixpack 6 on solaris. I am trying to take full offline backup and getting following error :

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

Following entries are found in diaglog :

CCI Error:
0xFFBEE904 : 0x00000047 ...G

2005-10-10-15.38.19.403541 Instance:udbqs006 Node:000
PID:7701(db2bp) TID:1 Appid:none
DRDA Communication Manager sqljcSend Probe:10

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8136001C".

2005-10-10-15.38.19.407267 Instance:udbqs006 Node:000
PID:7701(db2bp) TID:1 Appid:none
DRDA Application Requester sqljrDrdaArDisconnect Probe:10

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8136001C".

PID:7701 TID:1 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -902 sqlerrml: 3
sqlerrmc: 28
sqlerrp : sqljrifc6
sqlerrd : (1) 0x8136001C (2) 0x0000001C (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

What could be the problem?

Thanks,
toby
Reply With Quote
  #2 (permalink)  
Old 10-10-05, 19:51
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
Try the Messages and Codes Volume 2 and look up -902 with reason code 3.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #3 (permalink)  
Old 10-11-05, 00:22
bala_e bala_e is offline
Registered User
 
Join Date: Jan 2004
Posts: 49
We also faced the same error but my db env is, AIX 5.x and udb 7.2. It seems the filesystem problems, so check the file system first.

Question: Are you using clone the original db and taking the backup on that clone? If so, pls check the fs configurations again.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On