RE: ontape -s to disk
This is a multi-part message in MIME format.
------_=_NextPart_001_01C4E37B.56083EAA
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
=20
Gene,
I can't find my stuff/scripts we used back then.... probably
archived/deleted during "clean the system" time.
=20
I did a google on 'expect scripting' and found a lot.... this site
looks good: http://expect.nist.gov/
=20
have fun,
NJ
=20
________________________________
From: Gene Sais [mailto:Gsais@co.palm-beach.fl.us]=20
Sent: Wednesday, December 15, 2004 8:21 AM
To: MARTINFU@de.ibm.com; owner-informix-list@iiug.org; Sebastian, Norma
J=2E; dryburghj@yahoo.com
Cc: informix-list@iiug.org
Subject: RE: ontape -s to disk
I am in the same boat you were in years ago. I have run into the 2gb
file size limit. Could you please share your expect scripts?
=20
Thanks,
Gene
=20
OS: AIX 4.3.3
Informix: 7.23
=20
PS. Soon to be 7.32 AIX 5.2. Would be 9.4 but cost $18,000 :).
>>> "Sebastian, Norma J." <NormaJean.Sebastian@tellabs.com> 12/8/2004
10:42:10 AM >>>
I totally agree with Martin.... The attentive DBA should be making sure
the backups are successful. Should that happen to be the responsibility
of some overnight helpdesk, then the DBA should work with those folks to
educate them on the process.
But anyway... You might want to look into expect scripts....
If you fired off the backup inside an expect script, you could have the
expect script manage the response be it ""please insert the next tape
and press return" or something else. I know it works, we did it for
several years for our hotsite when we had onarchive.
Thanks,
NJ
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of Martin Fuerderer
Sent: Wednesday, December 08, 2004 4:04 AM
To: wcottishpoet
Cc: informix-list@iiug.org; owner-informix-list@iiug.org
Subject: Re: ontape -s to disk
Right.
BTW: the attentive Informix System Administrator would immediately
notice any problems with the archiving operation, because
he would see the messages about archives aborted or not
successfully completed in the server's message log file ...
[ soap box:
I once got a call from a consultant asking how a damaged IDS
(root dbspace overwritten) can be repaired. My answer was:
"restore", and his reply was that he knows.
The customer was changing archive tapes every evening for
the scripted archiving during the night. They set aside a weekly
archive tape, and they put into long-time storage a monthly tape.
So the customer was best prepared for restore.
The only problem was, that all tapes were empty. Further
investigation revealed, that despite all tape changing activity, the
ontape script never was run, as the IDS message log did not
contain any messages about archive activity. So this customer
had to "recover" from a dbexport that was done more than a
year ago ...
]
Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany Data Management Solutions
owner-informix-list@iiug.org wrote on 08.12.2004 01:12:03:
> Guys,
>=20
> I don't want to spoil the party here, but how do you all identify if=20
> the backup succeeded, or if Informix sent a message "please insert the
> next tape and press return".
>=20
> this will occur if you archive exceeds the size of your TAPEDEV as=20
> defined.
>=20
> this is why IBM informix general don't support archives taken using=20
> ontape and a script as there is little if any error handling done so=20
> some months - and archive after archive - later your restore fails=20
> with a message "Please insert the second tape" and you don't have one.
>=20
> oh and ....
> "I rather use onbar with ISM, but no $$$"
>=20
> both onbar and ISM are included with the 7 and 9 servers so I'm not=20
> sure you need $$$s.
>=20
sending to informix-list
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
sending to informix-list
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
------_=_NextPart_001_01C4E37B.56083EAA
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2743.600" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Arial">
<DIV dir=3Dltr align=3Dleft> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D064101314-16122004>Gene,</SPAN></=
DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D064101314-16122004>I can't find m=
y=20
stuff/scripts we used back then.... probably archived/deleted during "clean=
the=20
system" time.</SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D064101314-16122004></SPAN> <=
/DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D064101314-16122004>I did a google=
on 'expect=20
scripting' and found a lot.... this site looks good: <A=20
href=3D"http://expect.nist.gov/">http://expect.nist.gov/</A></SPAN></DIV>;
<DIV dir=3Dltr align=3Dleft><SPAN class=3D064101314-16122004>