Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2001
    Location
    Bangalore, India
    Posts
    28

    Red face Unanswered: Restore on WinXP

    Hi,
    I have taken a backup of a database (DB2 UDB 8.1 on NT) and have transfered the BU image on to a WinXP m/c with DB2 UDB 8.1. While resotring, I am getting an error message saying "SQL0970N The system attempted to write to a read-only file. SQLSTATE=55009".
    I gave full permission to all on this file, but still I get the same error.
    Can some one help me out to sort out his issue?
    Thanks in advance
    Ravi

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Restore on WinXP

    I'll look at the db2diag.log (and alert log) file first and increase the DIAGLEVEL to 4 ...

    Cheers

    Sathyaram

  3. #3
    Join Date
    Jul 2001
    Location
    Bangalore, India
    Posts
    28
    Hi Sathya,
    thanks for your reply. I checked the db2diag.olg file after setting the diaglevel to 4 and here is the error code,
    ----
    DIA0001E An internal error occurred. Report the following error code :

    "ZRC=0x8037006D".
    ----
    Infact this is just part of the error code. The error actually starts when DB2 starts the Bufferpool service with the error description as follows;

    ----
    DIA8701C Access denied for resource "", operating system return code was "".

    ZRC=0x840F0001
    ----

    Can you plz help me out to sort this?

    thanks
    Ravi

  4. #4
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170
    I dont think you can restore the backup you have taken on NT to XP.

  5. #5
    Join Date
    Jul 2001
    Location
    Bangalore, India
    Posts
    28
    Hi koganti,
    have you faced similar problems or you are guessing?
    Ravi

  6. #6
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170
    Ravi

    Backup taken on one Operating system cannot be restored on other operating system.

    Backup taken on AIX 4.3 will only work on othere machine where it is AIX 4.3 and wont even work on AIX 5.

    Backup taken on NT will only work on NT.

    Export all the tables from the database and import them back in the destination database.

    or

    use db2move utility in export mode and import mode

Posting Permissions

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