Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    61

    Unanswered: Error to write to a read-only file When Restore DB

    Hi there,

    When a restore DB command is executed with a sysadmin user, the following error is occured:

    SQL0970N The system attempted to write to a read-only file. SQLSTATE=55009

    The restore command is:

    restore db DB2DB from /tempdb/bk

    The OS is AIX 5.2. The DB2 Verison is 7.2.9.

    What's the problem? Where is the read-only file?

    Thanks,

    In db2diag.log, the message is:

    2005-01-07-11.16.42.596174 Instance:itest Node:000
    PID:1904852(db2bm.1986676.0) Appid:none
    buffer_pool_services sqlbSMSDoContainerOp Probe:815
    DIA9999E An internal error occurred. Report the following error code :
    "0xFFFFC11E".

    2005-01-07-11.16.42.600338 Instance:itest Node:000
    PID:1904852(db2bm.1986676.0) Appid:none
    buffer_pool_services sqlbSMSDoContainerOp Probe:815

    Error checking container 0 (/db/dw/dwdb/syscat) for tbsp 0. Rc = FFFFF611

    2005-01-07-11.16.42.605366 Instance:itest Node:000
    PID:1904852(db2bm.1986676.0) Appid:none
    oper_system_services sqlomkdirp Probe:100

    errno: 0000 000d ....


    String Title:Path/Filename PID:1904852 Node:000
    /db

    2005-01-07-11.16.42.611630 Instance:itest Node:000
    PID:1904852(db2bm.1986676.0) Appid:none
    buffer_pool_services sqlbCreateAndLockParent Probe:920
    DIA3501C Access denied for resource "", operating system return code was "".

    ZRC=0xFFFFC601

    2005-01-07-11.16.42.616254 Instance:itest Node:000
    PID:1904852(db2bm.1986676.0) Appid:none
    buffer_pool_services sqlbCreateAndLockParent Probe:920

    Failed at directory /db.
    Last edited by hiolgc; 01-07-05 at 14:42.

  2. #2
    Join Date
    Sep 2003
    Posts
    237
    Instance owner must be able to WRITE to the destinations(files or directories for DMS and SMS tablespaces. AIX is complaining it cannot write to /db/dw/dwdb/syscat; check UNIX file permissions to make sure the instance owner has write permissions on these.HTH
    mota

  3. #3
    Join Date
    Mar 2004
    Posts
    61
    The problem is:

    The backup is doned in an environment, and restore is in another env. and the command does not include the redirection option. But why DB2 offered so confused error message? Even no any hint associated to the problem! That's the DB2?

    Thanks,

Posting Permissions

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