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.

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

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,