Backup to disk
Posted in 2000
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Logging & Checkpoints
I am trying to take the back up of logical logs to disk using ALARM program. Is there any script out there which does this. Any suggestion will be appreciated. Salai >>> Edward Rosenthal <edrosenthal@home.com> 06/13/00 01:30PM >>> there is an example of creating a udr based on a soundex algorithm on the informix web site. if i remember it was a simple version, but you could create your own. you would have to have the 9.x IDS series to implement it. Eduardo MORALES wrote: > This is a multi-part message in MIME format. > --------------0EFD4D92CC4B2A1EBB557DAF > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > Hi Gurus, > > I have a query. What is the counterpart of SOUNDEX() in Informix. > Were using Informix-SQL 7.20 UE1 and Informix-4GL 7.20 UE1 > > Thanks for the help. > > Regards, > Jojo > > --------------0EFD4D92CC4B2A1EBB557DAF > Content-Type: text/x-vcard; charset=us-ascii; > name="ejmorale.vcf" > Content-Transfer-Encoding: 7bit > Content-Description: Card for Jojo Morales > Content-Disposition: attachment; > filename="ejmorale.vcf" > > begin:vcard > n:Morales;Jojo > tel;work:830-58-40/42 > x-mozilla-html:FALSE > org:DHL Aviation Phils.;APME-OPS IT Development > version:2.1 > email;internet:ejmorale@apme-ops.dhl.com > title:IT Contractual Developer > note:/* These are my opinions, not my company's opinion */ > adr;quoted-printable:;;12/F Urban Bank Plaza=0D=0APasong Tamo cor. Buendia;Makati;;;Phils. > fn:Jojo Morales > end:vcard > > --------------0EFD4D92CC4B2A1EBB557DAF--
If you are using onbar for backups there is the sample script log_full.sh
in $INFORMIXDIR/etc. If you are using ontape get my package utils3_ak from
the IIUG Software Repository which contains a version of log_full.sh that
will work with ontape. It is a bit simpleminded but you can flesh it out.
That package also contains my executable ALARMPROGRAM, eventalarm.c, which
will also backup the logs to disk and is much smarter handling ontape
prompts and multiple volumes (though how they might be needed for a single
log backup I dunno), etc. I even can compress the log archive files. It
also handles most other ALARM events and can email a message to the
administrators and/or their text pagers or cell phones when the system is
in trouble. You can even configure it to only send one message per hour for
long-running repeated events like LOGS FULL, and LOCK TABLE OVERFLOW.
Art S. Kagel
Salai Champooranan wrote:
>
> I am trying to take the back up of logical logs to disk using ALARM program.
> Is there any script out there which does this. Any suggestion will be
> appreciated.
>
> Salai
>
> >>> Edward Rosenthal <edrosenthal@home.com> 06/13/00 01:30PM >>>
> there is an example of creating a udr based on a soundex algorithm
> on the informix web site.
> if i remember it was a simple version, but you could create your own.
> you would have to have the 9.x IDS series to implement it.
>
> Eduardo MORALES wrote:
>
> > This is a multi-part message in MIME format.
> > --------------0EFD4D92CC4B2A1EBB557DAF
> > Content-Type: text/plain; charset=us-ascii
> > Content-Transfer-Encoding: 7bit
> >
> > Hi Gurus,
> >
> > I have a query. What is the counterpart of SOUNDEX() in Informix.
> > Were using Informix-SQL 7.20 UE1 and Informix-4GL 7.20 UE1
> >
> > Thanks for the help.
> >
> > Regards,
> > Jojo
> >
> > --------------0EFD4D92CC4B2A1EBB557DAF
> > Content-Type: text/x-vcard; charset=us-ascii;
> > name="ejmorale.vcf"
> > Content-Transfer-Encoding: 7bit
> > Content-Description: Card for Jojo Morales
> > Content-Disposition: attachment;
> > filename="ejmorale.vcf"
> >
> > begin:vcard
> > n:Morales;Jojo
> > tel;work:830-58-40/42
> > x-mozilla-html:FALSE
> > org:DHL Aviation Phils.;APME-OPS IT Development
> > version:2.1
> > email;internet:ejmorale@apme-ops.dhl.com
> > title:IT Contractual Developer
> > note:/* These are my opinions, not my company's opinion */
> > adr;quoted-printable:;;12/F Urban Bank Plaza=0D=0APasong Tamo cor. Buendia;Makati;;;Phils.
> > fn:Jojo Morales
> > end:vcard
> >
> > --------------0EFD4D92CC4B2A1EBB557DAF--