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 <[EMAIL PROTECTED]> on 04/30/2001 11:26:33 AM
>
> Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>
> To: [EMAIL PROTECTED]
> 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.
begin:vcard
n:Finley;Hagen
tel;cell:925-260-8538
tel;fax:925-210-6809
tel;work:925-210-6694
x-mozilla-html:FALSE
org:Longs Drugs;MIS
adr:;;141 North Civic Drive;Walnut Creek;CA;94596;USA
version:2.1
email;internet:[EMAIL PROTECTED]
title:Senior Unix Administrator
fn:Hagen Finley
end:vcard
