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

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

P: n/a
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

Jan 9 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/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.
Jan 9 '06 #2

P: n/a
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.

Jan 13 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.