Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    63

    Unanswered: 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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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

  3. #3
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •