ADSM-L

Re: configuring TSM with HACMP and informix : help needed

2001-10-31 10:36:51
Subject: Re: configuring TSM with HACMP and informix : help needed
From: Jeff Bach <jdbach AT WAL-MART DOT COM>
Date: Wed, 31 Oct 2001 09:34:08 -0600
You don't.

Run a level 0 backup after the fail over.  Restore this to the secondary
system.  (You WILL in most every instance need to restore the Informix
database on the secondary system.  And this must be completed prior to the
roll-over of the Informix logs to allow easy synchronization of the
databases between primary and secondary.

ADSM will give onbar back any object it asks for accociated with the
nodename, filespace, and ADSM server requested.

Onbar on the other hand will have difficulties pausing after half of the
logical logs are restore, switching any one of these parameters and
restarting the restore.

You would need to be able to run an Informix restore to a certain log
number, stop the restore(bring down onbar to re-read the dsm.sys file
again), change the dsm.sys file and onconfig(engine bounce) then continue to
roll forward of logs.

I have not found that Informix can accomplish this.  If you would like to
pursue further, I would suggest verifying that Informix cannot continue a
restore under the conditions above.

Jeff Bach

> -----Original Message-----
> From: PAC Brion Arnaud [SMTP:arnaud.brion AT PANALPINA DOT COM]
> Sent: Wednesday, October 31, 2001 4:54 AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      configuring TSM with HACMP and informix : help needed
>
> Hi *'SM Gurus !
>
> A probably easy question for anybody involved in this kind of
> installation : we are planing to  install HACMP between two AIX boxes,
> let's call them A and B.
> The A box is hosting an informix db, wich is doing it's online backups
> thru onbar, using it's own dsm.sys with hostname A.
> The B box is also hosting an informix db, wich also has it's own online
> backup, using it's own dsm.sys, hostname B.
> Imagine the A box fails : machine B will automatically relay it, and
> temporarily host the A informix db.
> Problem is as follows : what about a restoration of my informix db back
> to sytem A ?
> Probably a full level 0 backup was made at the time the db was on server
> A, but all intermediary logs (logical logs) have been made as my
> informix db was hosted on system B : how do I do a restore of my db if
> part of the files belong hostname A and other part hostname B ? Do I
> need to install two different instances of tsm on each node, to be able
> to do my restore ?  Lots of questions in fact, and absolutely no idea
> how to do it ! :-((
> I'm not an informix specialist nor HACMP, so please, if you give me some
> infos, try to be as basical as possible ;-)
> Many many thanks in advance to any informix-hacmp god(esss) willing to
> help me !
> Arnaud
>
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> | Arnaud Brion, Panalpina Management Ltd., IT Group     |
> | Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland |
> | Phone: +41 61 226 19 78    /    Fax: +41 61 226 17 01 |
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


**********************************************************************
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.
**********************************************************************
<Prev in Thread] Current Thread [Next in Thread>