ONTAPE vs ONBAR - copying a single DBSPACE
A user on IDS 7.23 (HP-UX) wanted to back up a single dbspace to tape, but ontape can't do dbspace-level archives and he had no third-party storage manager for onbar. Replies suggested unloading the tables in that dbspace to flat files and writing them to tape with tar/cpio, or shutting down the instance and dd-ing the chunks. Art Kagel advised upgrading to 7.31 or 9.40, which bundle a storage manager for onbar; 9.40 also adds onmode -c block for external archives. Later posts question whether a third-party manager is really required for onbar, and that question goes unanswered.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Bottom Line: I want to copy a single DBSPACE to tape. I don't have a third party data manager so I can't use ONBAR. ONTAPE doesn't support archiving a single DBSPACE to tape. Any ideas? INFORMIX-OnLine Version 7.23.UC11 HPUX B.11.00 HP9000/L2000 Rob
Unload the tables within the space to flat files and back them up to tape using cpio or tar. Take care. Clifton "Konikoff, R...." <konikoffr@BRAGG.ARMY.MIL> wrote: Bottom Line: I want to copy a single DBSPACE to tape. I don't have a third party data manager so I can't use ONBAR. ONTAPE doesn't support archiving a single DBSPACE to tape. Any ideas? INFORMIX-OnLine Version 7.23.UC11 HPUX B.11.00 HP9000/L2000 Rob
First, it's WAY past time to upgrade to 7.31 or even 9.40 (both of which come
with a storage manager for onbar BTW). The release you have is probably not
even Y2K compliant! IDS 7.23 had many problems fixed in later releases and
there have been 5 speed improvements between 7.23 and 9.40.
Having said that, and given the release you have, there's nothing you can do
unless you can shutdown the instance while the dbspace chunks are being dd
copied to backup tape. IDS 9.40 has an external archive mode (onmode -c block)
which blocks updates to the server and performs a checkpoint so that dbspace
chunks can be copied to archives external to the database. &.2x doesnot support
this mode.
And as noted 7.31 or 9.40 would let you use onbar with the delivered storage
manager.
Art S. Kagel
----- Original Message -----
From: R.... Konikoff <konikoffr@BRAGG.ARMY.MIL>
At: 9/23 16:07
> Bottom Line: I want to copy a single DBSPACE to tape.
>
> I don't have a third party data manager so I can't use ONBAR.
>
> ONTAPE doesn't support archiving a single DBSPACE to tape.
>
> Any ideas?
>
> INFORMIX-OnLine Version 7.23.UC11
> HPUX B.11.00 HP9000/L2000
> Rob
Rob- If you're using Unix or Linux, you could stop the instance and dd each of the chunks to tape. --EEM > -----Original Message----- > From: Konikoff, R.... [mailto:konikoffr@BRAGG.ARMY.MIL] > Sent: Thursday, September 23, 2004 2:52 PM > To: ids@iiug.org > Subject: ONTAPE vs ONBAR - copying a single DBSPACE [3465] > > Bottom Line: I want to copy a single DBSPACE to tape. > > > > I don't have a third party data manager so I can't use ONBAR. > > > > ONTAPE doesn't support archiving a single DBSPACE to tape. > > > > Any ideas? > > > > INFORMIX-OnLine Version 7.23.UC11 > > HPUX B.11.00 HP9000/L2000 > > > > Rob > > > >
I
didn't think a 3rd party data manager was required for use with onbar.
Shouldn't you be able to do everything from the command line?
-----Original Message-----
From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf
Of Konikoff, R....
Sent: Thursday, September 23, 2004 12:52 PM
To: ids@iiug.org
Subject: ONTAPE vs ONBAR - copying a single DBSPACE [3465]
Bottom Line: I want to copy a single DBSPACE to tape.
I don't have a third party data manager so I can't use ONBAR.
ONTAPE doesn't support archiving a single DBSPACE to tape.
Any ideas?
INFORMIX-OnLine Version 7.23.UC11
HPUX B.11.00 HP9000/L2000
Rob
--0__=09BBE58ADFCA69828f9e8a93df938690918c09BBE58ADFCA6982
Content-type: multipart/alternative;
Boundary="1__=09BBE58ADFCA69828f9e8a93df938690918c09BBE58ADFCA6982"
--1__=09BBE58ADFCA69828f9e8a93df938690918c09BBE58ADFCA6982
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable
Is it true that a media mgt layer (3rd party data mgr) is only required=
for
ONBAR if writing to tape, not disk?
Jim Spalla
Anexsys
Database Administrator
312/441-4036 phone
312/441-4099 fax
815/483-9234 cell phone
=
"Danny Wright" =
<dwright@sherwood =
foods.com> =
To
Sent by: ids@iiug.org =
forum.subscriber@ =
cc
iiug.org =
Subj=
ect
RE: ONTAPE vs ONBAR - copying a =
09/24/2004 10:56 single DBSPACE [3477] =
AM =
=
=
=
=
=
I didn't think a 3rd party data manager was required for use with onbar=
.
Shouldn't you be able to do everything from the command line?
-----Original Message-----
From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On
Behalf
Of Konikoff, R....
Sent: Thursday, September 23, 2004 12:52 PM
To: ids@iiug.org
Subject: ONTAPE vs ONBAR - copying a single DBSPACE [3465]
Bottom Line: I want to copy a single DBSPACE to tape.
I don't have a third party data manager so I can't use ONBAR.
ONTAPE doesn't support archiving a single DBSPACE to tape.
Any ideas?
INFORMIX-OnLine Version 7.23.UC11
HPUX B.11.00 HP9000/L2000
Rob
This transmission may contain information that is privileged, confident=
ial
and/or exempt from disclosure under applicable law. If you are not the
intended recipient, you are hereby notified that any disclosure, copyin=
g,
distribution, or use of the information contained herein (including any=
reliance thereon) is STRICTLY PROHIBITED. If you received this transmis=
sion
in error, please immediately contact the sender and destroy the materia=
l in
its entirety, whether in electronic or hard copy format.=
--1__=09BBE58ADFCA69828f9e8a93df938690918c09BBE58ADFCA6982
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>Is it true that a media mgt layer (3rd party data mgr) is only requi=
red for ONBAR if writing to tape, not disk?<br>
<br>
Jim Spalla<br>
Anexsys<br>
Database Administrator<br>
312/441-4036 phone<br>
312/441-4099 fax<br>
815/483-9234 cell phone<br>
<img src=3D"cid:10__=3D09BBE58ADFCA69828f9e8a93df93@anexsys.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for "Danny Wright&=
quot; <dwright@sherwoodfoods.com>">"Danny Wright" <d=
wright@sherwoodfoods.com><br>
<br>
<br>
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D09BBE58=
ADFCA69828f9e8a93df93@anexsys.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">"Danny Wright" <dwright@sherwoodfo=
ods.com></font></b><font size=3D"2"> </font><br>
<font size=3D"2">Sent by: forum.subscriber@iiug.org</font>
<p><font size=3D"2">09/24/2004 10:56 AM</font></ul>
</ul>
</ul>
</ul>
</td><td width=3D"60%">
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D09BBE58ADFCA69828f9e8a93df93@anexsys.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D09BBE58ADFCA69828f9e8a93df93@anexsys.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">ids@iiug.org</font></td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D09BBE58ADFCA69828f9e8a93df93@anexsys.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D09BBE58ADFCA69828f9e8a93df93@anexsys.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
</td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D09BBE58ADFCA69828f9e8a93df93@anexsys.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt=
h=3D"100%"><img src=3D"cid:30__=3D09BBE58ADFCA69828f9e8a93df93@anexsys.=
com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">RE: ONTAPE vs ONBAR - copying a single DBSPACE [3477=
]</font></td></tr>
</table>
<table border=3D"0" cellspacing=3D"0" cellpadding=3D"0">
<tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D09BBE58ADFCA=
69828f9e8a93df93@anexsys.com" border=3D"0" height=3D"1" width=3D"1" alt=
=3D""></td><td width=3D"336"><img src=3D"cid:30__=3D09BBE58ADFCA69828f9=
e8a93df93@anexsys.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><=
/td></tr>
</table>
</td></tr>
</table>
<br>
<tt>I didn't think a 3rd party data manager was required for use with o=
nbar.<br>
<br>
Shouldn't you be able to do everything from the command line?<br>
<br>
-----Original Message-----<br>
From: forum.subscriber@iiug.org [<a href=3D"mailto:forum.subscriber@iiu=
g.org">mailto:forum.subscriber@iiug.org</a>] On Behalf<br>
Of Konikoff, R....<br>
Sent: Thursday, September 23, 2004 12:52 PM<br>
To: ids@iiug.org<br>
Subject: ONTAPE vs ONBAR - copying a single DBSPACE [3465] <br>
<br>
Bottom Line: I want to copy a single DBSPACE to tape.<br>
<br>
<br>
<br>
I don't have a third party data manager so I can't use ONBAR.<br>
<br>
<br>
<br>
ONTAPE doesn't support archiving a single DBSPACE to tape.<br>
<br>
<br>
<br>
Any ideas?<br>
<br>
<br>
<br>
INFORMIX-OnLine Version 7.23.UC11<br>
<br>
HPUX B.11.00 HP9000/L2000<br>
<br>
<br>
<br>
Rob <br>
<br>
<br>
<br>
<br>
<br>
<br>
</tt><br>
<br>
<br>
This transmission may contain information that is privileged, confident=
ial and/or exempt from disclosure under applicable law. If you are not =
the