Connecting Tech Pros Worldwide Forums | Help | Site Map

Where can I get the DB2 backup/restore errors?

Brice Avila
Guest
 
Posts: n/a
#1: Nov 12 '05
Hello,

IHAC running DB2 7.1.1.93 on Solaris 8. When he tried restoring this
instance from a different server (alternate client restore) he
encountered:

db2 => restore database dumbunny load
/usr/openv/netbackup/bin/nbdb2.so open
1 sessions taken at 20041022181323 buffer 1024 replace existing
without prompting
Returns the following Error:
SQL2025N An I/O error "515" occurred on media "VENDOR".
db2 =>

Where can I get a list of the DB2 backup/restore errors, like the
above? Poking around we may have found the problem, but a better idea
of what these errors are would assist. Any response (including flames,
but not wishing for them) appreciated. Thanks in advance.

Brice Avila

Ian
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Where can I get the DB2 backup/restore errors?


Brice Avila wrote:[color=blue]
> Hello,
>
> IHAC running DB2 7.1.1.93 on Solaris 8. When he tried restoring this
> instance from a different server (alternate client restore) he
> encountered:
>
> db2 => restore database dumbunny load
> /usr/openv/netbackup/bin/nbdb2.so open
> 1 sessions taken at 20041022181323 buffer 1024 replace existing
> without prompting
> Returns the following Error:
> SQL2025N An I/O error "515" occurred on media "VENDOR".
> db2 =>
>
> Where can I get a list of the DB2 backup/restore errors, like the
> above? Poking around we may have found the problem, but a better idea
> of what these errors are would assist. Any response (including flames,
> but not wishing for them) appreciated. Thanks in advance.[/color]

This means that the Veritas Netbackup library that you're using is
returning error code 515.

You can look up this error in the Netbackup manuals (or contact
Veritas).



----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---
Brice Avila
Guest
 
Posts: n/a
#3: Nov 12 '05

re: Where can I get the DB2 backup/restore errors?


Ian <ianbjor@mobileaudio.com> wrote in message news:<417fecd6$1_5@127.0.0.1>...[color=blue]
> Brice Avila wrote:[color=green]
> > Hello,
> >
> > IHAC running DB2 7.1.1.93 on Solaris 8. When he tried restoring this
> > instance from a different server (alternate client restore) he
> > encountered:
> >
> > db2 => restore database dumbunny load
> > /usr/openv/netbackup/bin/nbdb2.so open
> > 1 sessions taken at 20041022181323 buffer 1024 replace existing
> > without prompting
> > Returns the following Error:
> > SQL2025N An I/O error "515" occurred on media "VENDOR".
> > db2 =>
> >
> > Where can I get a list of the DB2 backup/restore errors, like the
> > above? Poking around we may have found the problem, but a better idea
> > of what these errors are would assist. Any response (including flames,
> > but not wishing for them) appreciated. Thanks in advance.[/color]
>
> This means that the Veritas Netbackup library that you're using is
> returning error code 515.
>
> You can look up this error in the Netbackup manuals (or contact
> Veritas).
>
>
>
> ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
> http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
> ---= East/West-Coast Server Farms - Total Privacy via Encryption =---[/color]

Ian,

Thanks for your response.

Well, . . . I searched through all the NetBackup 4.5 and 5.0 manuals
as pdf files, searching for "515" and only found page numbers and DLT
tape types. Veritas support also is stumped. We solved the problem by
matching the file directory structure on the target system to match
the source system, which really isn't a NetBackup area of control.

Any other thoughts? Again, thanks.

Brice Avila
Ian
Guest
 
Posts: n/a
#4: Nov 12 '05

re: Where can I get the DB2 backup/restore errors?


Brice Avila wrote:[color=blue]
> Ian <ianbjor@mobileaudio.com> wrote in message news:<417fecd6$1_5@127.0.0.1>...
>[color=green]
>>Brice Avila wrote:
>>[color=darkred]
>>>Hello,
>>>
>>>IHAC running DB2 7.1.1.93 on Solaris 8. When he tried restoring this
>>>instance from a different server (alternate client restore) he
>>>encountered:
>>>
>>>db2 => restore database dumbunny load
>>>/usr/openv/netbackup/bin/nbdb2.so open
>>>1 sessions taken at 20041022181323 buffer 1024 replace existing
>>>without prompting
>>>Returns the following Error:
>>>SQL2025N An I/O error "515" occurred on media "VENDOR".
>>>db2 =>
>>>
>>>Where can I get a list of the DB2 backup/restore errors, like the
>>>above? Poking around we may have found the problem, but a better idea
>>>of what these errors are would assist. Any response (including flames,
>>>but not wishing for them) appreciated. Thanks in advance.[/color]
>>
>>This means that the Veritas Netbackup library that you're using is
>>returning error code 515.
>>
>>You can look up this error in the Netbackup manuals (or contact
>>Veritas).
>>
>>
>>
>>----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
>>http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
>>---= East/West-Coast Server Farms - Total Privacy via Encryption =---[/color]
>
>
> Ian,
>
> Thanks for your response.
>
> Well, . . . I searched through all the NetBackup 4.5 and 5.0 manuals
> as pdf files, searching for "515" and only found page numbers and DLT
> tape types. Veritas support also is stumped. We solved the problem by
> matching the file directory structure on the target system to match
> the source system, which really isn't a NetBackup area of control.
>
> Any other thoughts? Again, thanks.[/color]

Sorry, maybe I wasn't clear about which manual, but in the "NetBackup
5.1 for DB2 System Administrator's Guide", and it documents (on page 139):

515
Message: NetBackup Get Image Failed
Cause: NetBackup encountered errors when attempting to access
a backup image.


I'm not a NetBackup expert, so I can't comment on what exactly this
means, but I would assume that this would clue someone in on what is
causing the problem.





----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---
Brice Avila
Guest
 
Posts: n/a
#5: Nov 12 '05

re: Where can I get the DB2 backup/restore errors?


Ian <ianbjor@mobileaudio.com> wrote in message news:<4182a721$1_4@127.0.0.1>...[color=blue]
> Brice Avila wrote:[color=green]
> > Ian <ianbjor@mobileaudio.com> wrote in message news:<417fecd6$1_5@127.0.0.1>...
> >[color=darkred]
> >>Brice Avila wrote:
> >>
> >>>Hello,
> >>>
> >>>IHAC running DB2 7.1.1.93 on Solaris 8. When he tried restoring this
> >>>instance from a different server (alternate client restore) he
> >>>encountered:
> >>>
> >>>db2 => restore database dumbunny load
> >>>/usr/openv/netbackup/bin/nbdb2.so open
> >>>1 sessions taken at 20041022181323 buffer 1024 replace existing
> >>>without prompting
> >>>Returns the following Error:
> >>>SQL2025N An I/O error "515" occurred on media "VENDOR".
> >>>db2 =>
> >>>
> >>>Where can I get a list of the DB2 backup/restore errors, like the
> >>>above? Poking around we may have found the problem, but a better idea
> >>>of what these errors are would assist. Any response (including flames,
> >>>but not wishing for them) appreciated. Thanks in advance.
> >>
> >>This means that the Veritas Netbackup library that you're using is
> >>returning error code 515.
> >>
> >>You can look up this error in the Netbackup manuals (or contact
> >>Veritas).
> >>
> >>
> >>
> >>----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
> >>http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
> >>---= East/West-Coast Server Farms - Total Privacy via Encryption =---[/color]
> >
> >
> > Ian,
> >
> > Thanks for your response.
> >
> > Well, . . . I searched through all the NetBackup 4.5 and 5.0 manuals
> > as pdf files, searching for "515" and only found page numbers and DLT
> > tape types. Veritas support also is stumped. We solved the problem by
> > matching the file directory structure on the target system to match
> > the source system, which really isn't a NetBackup area of control.
> >
> > Any other thoughts? Again, thanks.[/color]
>
> Sorry, maybe I wasn't clear about which manual, but in the "NetBackup
> 5.1 for DB2 System Administrator's Guide", and it documents (on page 139):
>
> 515
> Message: NetBackup Get Image Failed
> Cause: NetBackup encountered errors when attempting to access
> a backup image.
>
>
> I'm not a NetBackup expert, so I can't comment on what exactly this
> means, but I would assume that this would clue someone in on what is
> causing the problem.
>
>
>
>
>
> ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
> http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
> ---= East/West-Coast Server Farms - Total Privacy via Encryption =---[/color]


You are correct and my apologies for doubting you. I found the same
information in the 4.5 NBU for DB2 guide. I should've looked further
into the documentation. Thanks for your help.

Brice
Closed Thread


Similar DB2 Database bytes