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

DB2 Redirected Restore

P: n/a
Hello, all. Was hoping someone might be able to help us out with an
issue:

We're trying to perform a restore from a backup of one AIX 5.1 server,
we'll call it "AIX", to another AIX 5.1 server; we'll call this one
"DEV". We're using Netbackup 5.1 MP3 to do this. For some reason when
we try to restore from AIX's backup to DEV we recieve an error from
Netbackup that states:
____________________________________________
+ db2 restore database (instance) load
/usr/openv/netbackup/bin/nbdb2.sl64 OPEN 4 SESSIONS BUFFER 1024
SQL2025N An I/O error "515" occurred on media "VENDOR".
____________________________________________

Veritas people don't seem to know what's going on with this one, nor do
IBM. Any help would be terrific.

Mar 23 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Ian
ce*****@gmail.com wrote:
Hello, all. Was hoping someone might be able to help us out with an
issue:

We're trying to perform a restore from a backup of one AIX 5.1 server,
we'll call it "AIX", to another AIX 5.1 server; we'll call this one
"DEV". We're using Netbackup 5.1 MP3 to do this. For some reason when
we try to restore from AIX's backup to DEV we recieve an error from
Netbackup that states:
____________________________________________
+ db2 restore database (instance) load
/usr/openv/netbackup/bin/nbdb2.sl64 OPEN 4 SESSIONS BUFFER 1024
SQL2025N An I/O error "515" occurred on media "VENDOR".
____________________________________________


The NetBackup for DB2 agent does not have the ability to restore a
backup taken from server A and restore it on server B. We talked
to Veritas about this, and the engineers responded with, "why would
you need to do that?" There isn't even a way to extract the backup
image from NetBackup to a filesystem.

We tried to work around this by modifying the CLIENT_NAME in bp.conf
on the "target" machine, but were unable get anything to work because
the UID for the DB2 instance owners was different on the source/target
servers. Theoretically if you have the same UID for the instances on
both servers you might be able to fake out NetBackup.
FYI, error "515" in NetBackup means that it can't find the object to
restore.

Mar 23 '06 #2

P: n/a

Ian wrote:
ce*****@gmail.com wrote:
Hello, all. Was hoping someone might be able to help us out with an
issue:

We're trying to perform a restore from a backup of one AIX 5.1 server,
we'll call it "AIX", to another AIX 5.1 server; we'll call this one
"DEV". We're using Netbackup 5.1 MP3 to do this. For some reason when
we try to restore from AIX's backup to DEV we recieve an error from
Netbackup that states:
____________________________________________
+ db2 restore database (instance) load
/usr/openv/netbackup/bin/nbdb2.sl64 OPEN 4 SESSIONS BUFFER 1024
SQL2025N An I/O error "515" occurred on media "VENDOR".
____________________________________________


The NetBackup for DB2 agent does not have the ability to restore a
backup taken from server A and restore it on server B. We talked
to Veritas about this, and the engineers responded with, "why would
you need to do that?" There isn't even a way to extract the backup
image from NetBackup to a filesystem.

We tried to work around this by modifying the CLIENT_NAME in bp.conf
on the "target" machine, but were unable get anything to work because
the UID for the DB2 instance owners was different on the source/target
servers. Theoretically if you have the same UID for the instances on
both servers you might be able to fake out NetBackup.
FYI, error "515" in NetBackup means that it can't find the object to
restore.


We were able to get this working, but I was not around when they did
it, so I'll have to check and see how exactly they managed it. All I
caught in passing was that it had to do with editing the bp.conf file.
Seems strange to do something like this, but the basic reason was that
the server the data was backed up from was under repair and they needed
to access that data ASAP, so we decided just to put it on another
server. Thanks for the response, I may post what exactly they did when
I get a bit of time and find out, so maybe someone else can refrence it
later.

Mar 26 '06 #3

P: n/a
Hi,
My experience worth 2 cents:
For 2 servers to see each others backup / restore IS POSSIBLE.
It boils down to how competent your VERITAS guys are.

Well, I am a DB2 UDB DBA who had the good fortune to have worked with a
person with good hokd on VERITAS BACKUP config.
When we were facing similar problems, he created 2 files in directory
"/usr/openv/netbackup/db/altnames".

Specific to your scenario, these files would be named "aix.<full dns
name>" and "dev.<full dns name>".
"aix.<full dns name>" would contain a single line entry for "dev.<full
dns name>" and similarly for the other file.

I know I may not be very exact in providing the solution (BUT I AM NOT
A VERITAS PERSON :);
But - IF YOU HAVE A GOOD VERITAS GUY, THIS IS POSSIBLE.

..........Anurag

Mar 31 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.