"Onbar -r " will restore the Informix database to the last log that was
backed up.

Jeff Bach
Home Office Open Systems Engineering
Wal-Mart Stores, Inc.

WAL-MART CONFIDENTIAL


        -----Original Message-----
        From:   George Lesho [SMTP:GLesho AT AFCE DOT COM]
        Sent:   Tuesday, November 20, 2001 12:50 PM
        To:     ADSM-L AT VM.MARIST DOT EDU
        Subject:        Re: Informix restore using TSM

        Theresa, I do Informix restores all the time. You are correct about
the old
        ADSM product... it did supply a shared library. TSM does not. The
shared
        library is a generic library that onbar talks to to make its tape
requests
        known to TSM. TSM merely keeps track of where the backups are that
are to
        be restored and onbar does most of the work. Backups are done in
several
        ways, depending on the arguements to the onbar command. Backups done
with a
        -L specify a "level" and you can think of these as more or less
incremental
        backups. I say that because Informix logical logs, which are
probably being
        backed up to allow you to restore to a "point in time". This point
in time
        is specified in the onbar restore arguements (hope you have an
Informix
        Onbar Backup and Restore Guide. The other way you can back up your
system
        is using the whole_system argument in the backups. Then, you can do
a
        whole_system restore. I think these work a tad better but either
method
        will work. How do you backup the database?  I would guess a script
is used
        which calls the onbar script that Informix provides along with
arguments.
        If you send me this info offline, we may be able to figure this out.
Drop
        me a note at:
        glesho AT afce DOT com

        George Lesho
        AFC Enterprises





        "Sarver, Theresa (Osky Unix Administrator)" <tsarver AT CLOWVALVE DOT 
COM>
        @VM.MARIST.EDU> on 11/20/2001 10:33:57 AM

        Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT 
EDU>

        Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


        To:   ADSM-L AT VM.MARIST DOT EDU
        cc:    (bcc: George Lesho/Partners/AFC)
        Fax to:
        Subject:  Informix restore using TSM


        Hello;

        We are in a 3-tier environment:
        Server1 - Informix Database 7.24 UC5 and TSM 4.1.1 server
        Server2 - Baan IVb3

        The TSM client on Server1 (that Informix connects with) is using an
old
        [ADSM] version...3.8 - I believe?  This was done because it was the
only
        way
        Informix would connect to TSM without having to purchase TDP for
Informix.
        (not my choice, nor was I part of that decision)

        Anyway...

        This morning Server1 crashed - we lost the I/O board.  While I await
IBM's
        arrival with the replacement part I am contemplating the
worst...having to
        restore Informix.  I am fairly new to this job and have never
restored
        Informix (or anything else for that matter) with TSM.  Three years
ago when
        Informix and ADSM were brought online a full database restore was
preformed
        and it was successful...but other than that I do not believe it has
been
        done since.  ????  The person who was incharge of TSM and Informix
        "abruptly" left the firm and I got "stuck" administering them.  ;)

        If anyone out there has ever preformed an Informix restore would you
be so
        kind and to provide me with some steps.  I'd welcome any help anyone
has to
        offer at this point.

        Thank you;
        Theresa


**********************************************************************
This email and any files transmitted with it are confidential
and intended solely for the individual or entity to
whom they are addressed.  If you have received this email
in error destroy it immediately.
**********************************************************************