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

[P. Adhia]

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

[Mark A]

"P. Adhia" <pa****@yahoo.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

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

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.

[P. Adhia]

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.