Individual table restores work using Informix and 3.1.0.7 ADSM.  Not tested
on new code, but it looks like the entire dbspace restores and the table is
filtered out and restores (this is according to the amount of data sent to
ADSM)

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

WAL-MART CONFIDENTIAL


        -----Original Message-----
        From:   Hagen Finley [SMTP:hfinley AT LONGS DOT COM]
        Sent:   Monday, April 30, 2001 2:18 PM
        To:     ADSM-L AT VM.MARIST DOT EDU
        Subject:        Re: Onbar to TSM whitout TDP

        Dear George,

            Our Senior DBA provided the following clarification:


        I plagiarized some of the Informix On-Bar Training manual to answer
the
        questions as accurately and concisely.


        1) How does onbar know where to store the data?

        Onbar relies on the storage manager (TSM, ADSM, Omniback, etc) to
determine
        where and what media to store the archive and backups. Where the
storage
        manager places the data is only limited by the configurable
resources of the
        storage manager.

        2) When you do a restore, how does onbar know which tapes to have
TSM mount?

        Every time a backup is performed, On-Bar updates both the sysutils
database
        and the "emergency boot file" (a file which resides in
        $INFORMIXDIR/etc/ixbar.<SERVERNUM>).  It's the information in the
sysutils
        and/or emergency boot file that is used to communicate the storage
manager
        for which dbspaces or log files needing to be retrieved for the
restore.

        3) Do you do table by table backups?

        As a general rule, we do not backup individual tables.

        4) Can you then restore individual tables?

        No. On-Bar provides all the capabilities of on-tape with
enhancements of
        parallel backup and restore of dbspaces, unattended operations,
automatic
        backup of logical logs, point in time recovery, etc. It does not
allow you to
        restore an individual table.  If you need to restore an individual
table, you
        would need to restore the entire database instance to the server (or
like
        server) and unload the table before the unloaded table could be used
to
        restore the individual table.


        George Lesho wrote:

        > Hagen, I am a bit confused. How does onbar know where to store the
data? When
        > you do a restore, how does onbar know which tapes to have TSM
mount? Do you do
        > table by table backups? Can you then restore individual tables?
        >
        > George Lesho
        > Storage/System Admin
        > AFC Enterprises
        >
        > Hagen Finley <hfinley AT LONGS DOT COM> on 04/30/2001 11:26:33 AM
        >
        > Please respond to "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:  Re: Onbar to TSM whitout TDP
        >
        > We run onbar against TSM 4.1 without a TDP here at Longs Drugs,
but we have
        > found we must use the ADSM 3.7 client on the DB server for it to
work. We
        > would actually be more comfortable using the TDP, but we run
Informix on
        > HPUX, and, remarkably,  there is no TDP for Informix on HPUX.
        >
        > Hagen Finley
        >
        > Manuel Devesa wrote:
        >
        > > Hello somebody uses Onbar of Informix 7.3 with TSM 3.7 or 4.1
without
        > > using the TDP for Informix, in affirmative case, That
configuration has
        > > used?
        > >
        > > thanks.
         << File: Card for Hagen Finley >>


**********************************************************************
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.
**********************************************************************