onload error
Hello list, i need help
I need migrate a database from IDS 7.31 ON SCO OPENSERVER 5.0.5 in a PROLIANT
1850 R to a IDS 7.31 on SCO OpenServer 5.0.5 in a IBM x-series 225.
The Proliant have a DAT 40 DDS 4 and the IBM have a DAT 72 DD5.
On the Proliant i execute onunload -b 1024 -s 12582912 -t /dev/rct0 database
On the IBM i execute onload -b 1024 -s 12582912 -t /dev/rct0 -d dbdat datase
and recive : "Error reading from tape device Erro No. = 0"
I verify de data on the tape with dd an i see all ok.
When i do a tar cv8 xx on the Proliant and tar xv8 xx on the IBM, it extrat
the data fine, then i think that is not problem with the format of DAT (DD4 vs
DDS 5).
I can do ontape and tar in the IBM.
I´ll apreciate any idea.
I need use onunload becose the dbexport produce a file grather than 2 gb and
the SCO no support this; and dbexport to tape demand 5 tapes.
Thanks
Susana
Try to do the unload directly to the remote device,
using onunload -b 1024
-s 12582912 -t <servername>:/dev/rct0 -d dbdat.
Saludos.
Gustavo.
>From: "Susana Barea" <sbarea@jus.mendoza.gov.ar>
>To: ids@iiug.org
>Subject: onload error [5042] Date: Fri, 27 May 2005 15:42:10 -0400 (EDT)
>
>Hello list, i need help
>
>I need migrate a database from IDS 7.31 ON SCO OPENSERVER 5.0.5 in a
>PROLIANT 1850 R to a IDS 7.31 on SCO OpenServer 5.0.5 in a IBM x-series
>225.
>
>The Proliant have a DAT 40 DDS 4 and the IBM have a DAT 72 DD5.
>
>On the Proliant i execute onunload -b 1024 -s 12582912 -t /dev/rct0
>database
>On the IBM i execute onload -b 1024 -s 12582912 -t /dev/rct0 -d dbdat
>datase and recive : "Error reading from tape device Erro No. = 0"
>
>I verify de data on the tape with dd an i see all ok.
>When i do a tar cv8 xx on the Proliant and tar xv8 xx on the IBM, it extrat
>the data fine, then i think that is not problem with the format of DAT (DD4
>vs DDS 5).
>
>I can do ontape and tar in the IBM.
>
>I´ll apreciate any idea.
>
>
>I need use onunload becose the dbexport produce a file grather than 2 gb
>and the SCO no support this; and dbexport to tape demand 5 tapes.
>
>Thanks
>
>Susana
>
>
--0__=88BBFA9DDFEB0C338f9e8a93df938690918c88BBFA9DDFEB0C33
Content-type: multipart/related;
Boundary="1__=88BBFA9DDFEB0C338f9e8a93df938690918c88BBFA9DDFEB0C33"
--1__=88BBFA9DDFEB0C338f9e8a93df938690918c88BBFA9DDFEB0C33
Content-type: multipart/alternative;
Boundary="2__=88BBFA9DDFEB0C338f9e8a93df938690918c88BBFA9DDFEB0C33"
--2__=88BBFA9DDFEB0C338f9e8a93df938690918c88BBFA9DDFEB0C33
Content-type: text/plain; charset=ISO-8859-1
Content-transfer-encoding: quoted-printable
Hi Susana,
We simply do a read() call on the device provided in the arguments .. s=
ince
its returning 0 which essentially means it couldn't read anything .. I'=
m
attaching a C program, which you can compile and check your tape device=
to
see if this program can seek into the tape. The logic in the program is=
kind of the logic within onload while loading from tape ..
HTH
(See attached file: checktape.c)
Thanx much,
Rajib Sarkar
Advisory Software Engineer
DB2/UDB Regional Advanced Support
IBM Data Management Group
From his neck down a man is worth a couple of dollars a day, from his n=
eck
up he is worth anything that his brain can produce. -- T. Edison
=
"Susana Barea" =
<sbarea@jus.mendo =
za.gov.ar> =
To
Sent by: ids@iiug.org =
forum.subscriber@ =
cc
iiug.org =
Subj=
ect
onload error [5042] =
05/27/2005 12:42 =
PM =
=
=
=
=
Hello list, i need help
I need migrate a database from IDS 7.31 ON SCO OPENSERVER 5.0.5 in a
PROLIANT 1850 R to a IDS 7.31 on SCO OpenServer 5.0.5 in a IBM x-series=
225.
The Proliant have a DAT 40 DDS 4 and the IBM have a DAT 72 DD5.
On the Proliant i execute onunload -b 1024 -s 12582912 -t /dev/rct0
database
On the IBM i execute onload -b 1024 -s 12582912 -t /dev/rct0 -d dbdat
datase and recive : "Error reading from tape device Erro No. =3D 0"
I verify de data on the tape with dd an i see all ok.
When i do a tar cv8 xx on the Proliant and tar xv8 xx on the IBM, it ex=
trat
the data fine, then i think that is not problem with the format of DAT =
(DD4
vs DDS 5).
I can do ontape and tar in the IBM.
I=B4ll apreciate any idea.
I need use onunload becose the dbexport produce a file grather than 2 g=
b
and the SCO no support this; and dbexport to tape demand 5 tapes.
Thanks
Susana
=
--2__=88BBFA9DDFEB0C338f9e8a93df938690918c88BBFA9DDFEB0C33
Content-type: text/html; charset=ISO-8859-1
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>Hi Susana,<br>
We simply do a read() call on the device provided in the arguments .. s=
ince its returning 0 which essentially means it couldn't read anything =
.. I'm attaching a C program, which you can compile and check your tape=
device to see if this program can seek into the tape. The logic in the=
program is kind of the logic within onload while loading from tape .. =
<br>
<br>
HTH<br>
<i>(See attached file: checktape.c)</i><br>
<br>
Thanx much,<br>
<br>
Rajib Sarkar<br>
Advisory Software Engineer<br>
DB2/UDB Regional Advanced Support<br>
IBM Data Management Group<br>
<br>
<br>
From his neck down a man is worth a couple of dollars a day, from his n=
eck up he is worth anything that his brain can produce. -- T. Edison<br=
>
<br>
<img src=3D"cid:20__=3D88BBFA9DDFEB0C338f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for "Susana Barea&=
quot; <sbarea@jus.mendoza.gov.ar>">"Susana Barea" <s=
barea@jus.mendoza.gov.ar><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:30__=3D88BBFA9=
DDFEB0C338f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">"Susana Barea" <sbarea@jus.mendoza=
.gov.ar></font></b><font size=3D"2"> </font><br>
<font size=3D"2">Sent by: forum.subscriber@iiug.org</font>
<p><font size=3D"2">05/27/2005 12:42 PM</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:4=
0__=3D88BBFA9DDFEB0C338f9e8a93df938@us.ibm.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:40__=3D88BBFA9DDFEB0C338f9e8a93df938@us.ibm.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:4=
0__=3D88BBFA9DDFEB0C338f9e8a93df938@us.ibm.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:40__=3D88BBFA9DDFEB0C338f9e8a93df938@us.ibm.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:4=
0__=3D88BBFA9DDFEB0C338f9e8a93df938@us.ibm.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:40__=3D88BBFA9DDFEB0C338f9e8a93df938@us.ibm.=
com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">onload error [5042]</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:40__=3D88BBFA9DDFEB=
0C338f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=
=3D""></td><td width=3D"336"><img src=3D"cid:40__=3D88BBFA9DDFEB0C338f9=
e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><=
/td></tr>
</table>
</td></tr>
</table>
<br>
<tt>Hello list, i need help<br>
<br>
I need migrate a database from IDS 7.31 ON SCO OPENSERVER 5.0.5 in a PR=
OLIANT 1850 R to a IDS 7.31 on SCO OpenServer 5.0.5 in a IBM x-series 2=
25.<br>
<br>
The Proliant have a DAT 40 DDS 4 and the IBM have a DAT 72 DD5.<br>
<br>
On the Proliant i execute onunload -b 1024 -s 1258291