By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,557 Members | 1,067 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,557 IT Pros & Developers. It's quick & easy.

migrating databases from v8.2 to v9: gives a nasty SQL0970N

P: n/a
Group,

as subject line says: I'm trying to migrate databases from v8.2 to v9.1

db2 migrate database blabla
SQL0970N The system attempted to write to a read-only file. SQLSTATE=55009

any clues?
H.

Feb 5 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
In article <Fd******************************@comcast.com>, hannes@
2horns.com says...
Group,

as subject line says: I'm trying to migrate databases from v8.2 to v9.1

db2 migrate database blabla
SQL0970N The system attempted to write to a read-only file. SQLSTATE=55009

any clues?
H.
Can you find more messages in the db2diag.log?
Feb 5 '07 #2

P: n/a
This is a file permission problem. Did you recreate your db2 users or
change file permission on your directories? Perhaps the db2diag.log
can tell you which file/directory is giving you a problem.

Feb 5 '07 #3

P: n/a
What I found doesn't tell me much:
'Access denied for resource "", operating system return code was "".'
Here's a full log entry:
2007-02-05-06.54.46.125000-480 I3624H268 LEVEL: Warning
PID : 1284 TID : 3604 PROC : db2bp.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqlemgdb, probe:10
MESSAGE : Begin engn migration

2007-02-05-06.54.46.171000-480 I3894H729 LEVEL: Severe
PID : 1664 TID : 4068 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7 APPID: *LOCAL.DB2.070205145446
AUTHID : HANSHORN
FUNCTION: DB2 UDB, data protection services, sqlpMigrate, probe:10
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return
code
was "".
DATA #1 : String, 35 bytes
Unable to migrate LFH and MFH files
DATA #2 : unsigned integer, 4 bytes
16
DATA #3 : unsigned integer, 4 bytes
4294967295
DATA #4 : Pointer, 4 bytes
0x00000000
DATA #5 : Pointer, 4 bytes
0x00000000

"Otto Carl Marte" wrote in message
news:11**********************@a34g2000cwb.googlegr oups.com...
This is a file permission problem. Did you recreate your db2 users or
change file permission on your directories? Perhaps the db2diag.log
can tell you which file/directory is giving you a problem.

Feb 5 '07 #4

P: n/a
Hans Horn wrote:
What I found doesn't tell me much:
'Access denied for resource "", operating system return code was "".'
Here's a full log entry:
2007-02-05-06.54.46.125000-480 I3624H268 LEVEL: Warning
PID : 1284 TID : 3604 PROC : db2bp.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqlemgdb, probe:10
MESSAGE : Begin engn migration

2007-02-05-06.54.46.171000-480 I3894H729 LEVEL: Severe
PID : 1664 TID : 4068 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7 APPID: *LOCAL.DB2.070205145446
AUTHID : HANSHORN
FUNCTION: DB2 UDB, data protection services, sqlpMigrate, probe:10
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return
code
was "".
DATA #1 : String, 35 bytes
Unable to migrate LFH and MFH files
DATA #2 : unsigned integer, 4 bytes
16
DATA #3 : unsigned integer, 4 bytes
4294967295
DATA #4 : Pointer, 4 bytes
0x00000000
DATA #5 : Pointer, 4 bytes
0x00000000

"Otto Carl Marte" wrote in message
news:11**********************@a34g2000cwb.googlegr oups.com...
>This is a file permission problem. Did you recreate your db2 users or
change file permission on your directories? Perhaps the db2diag.log
can tell you which file/directory is giving you a problem.

Well that's actually limits the scope of the problem by quite a bit...
"Unable to migrate LFH and MFH files"
http://publib.boulder.ibm.com/infoce...c/c0005420.htm

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Feb 5 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.