Redirected restore - SQL2038N A database system error "127" occurred during processing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

P. Adhia - 09 Jan 2006 01:53 GMT

Hello All,

I am trying to redirect-restore a backup of a DB2 V6.x system (AIX 4.x)
on DB2 V8.2 system (AIX 5.2). I get the above error with no other
details. db2diag.log has a series of error messages, starting with
following message -

2006-01-07-14.24.57.173819-300 I4955C325 LEVEL: Error
PID : 34928 TID : 1 PROC : db2med.30074.0
0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, database utilities, sqluMCInitRestoreMC, probe:55
MESSAGE : Media controller -- device initialization error (zrc =
0x8300007f)

Has anyone encountered this before?

TIA

P Adhia

Reply to this Message

Mark A - 09 Jan 2006 02:43 GMT

> Hello All,
>
[quoted text clipped - 16 lines]
>
> P Adhia

I believe that V8 restore only supports backups as far back as V7 (but not
100% sure). You could restore first on V7 and then backup again and restore
to V8, or do a db2look/db2move.

Reply to this Message

P. Adhia - 13 Jan 2006 23:04 GMT

restore supports backups from up to two previous version, so that's not
it -- but thanks for the suggestion.

It seems, there is a bug in db2 restore command, and it didn't like the
"from <absolute file path>" clause for some reason. DB2 support
suggested a work around to cd to the backup directory and issue the
restore command without the "from" clause and it worked.

Reply to this Message