Tivoli (TSM) / Onbar Imported Restore, how to?
All,
I'm searching for information on the procedure to copy an entire instance of Informix Online from one machine to another for testing/development purposes. Here's the specifics of the system(s)
IBM RS/6000 AIX 5.1.0
Informix Online 7.31.FD6
TSM Server: Version 4, Release 2, Level 4.1
TSM Backup Clients: Version 4, Release 2, Level 2.7
We routinely copy the data from the production system to the development system (two separate machines) by using ontape, and this method works quite well, but is very time consuming. I would like to use Tivoli/Onbar to achieve the same goal. What do you need to do in order to tell Tivoli/Onbar to grab the backup data for the production server and load it into the development server on the other box? I've searched through the documentation that I have, but cannot find anything helpful.
We are just now starting to implement TSM at our facility. I have successfully backed up and recovered the data on my test server using TSM, and now I would like to tell the system to grab the information from the production system backup. Any and all help is greatly appreciated.
Regards,
Christopher Cale
Job Corps Data Center
San Marcos, Tx
sending to informix-list
Contact TSM's tech support and ask them for these steps. I know that
Legato and Veritas' technical support organizations have similar
technical articles that walk one through how to do this. Hope this
suggestion helps.
Brice Avila
Minneapolis, Minnesota
"Chris Cale" <CaleC@jcdc.jobcorps.org> wrote in message news:<bh0con$4bs$1@terabinaries.xmission.com>...
> All,
>
> I'm searching for information on the procedure to copy an entire instance of Informix Online from one machine to another for testing/development purposes. Here's the specifics of the system(s)
>
> IBM RS/6000 AIX 5.1.0
> Informix Online 7.31.FD6
> TSM Server: Version 4, Release 2, Level 4.1
> TSM Backup Clients: Version 4, Release 2, Level 2.7
>
> We routinely copy the data from the production system to the
development system (two separate machines) by using ontape, and this
method works quite well, but is very time consuming. I would like to
use Tivoli/Onbar to achieve the same goal. What do you need to do in
order to tell Tivoli/Onbar to grab the backup data for the production
server and load it into the development server on the other box? I've
searched through the documentation that I have, but cannot find
anything helpful.
>
> We are just now starting to implement TSM at our facility. I have successfully backed up and recovered the data on my test server using TSM, and now I would like to tell the system to grab the information from the production system backup. Any and all help is greatly appreciated.
>
> Regards,
>
> Christopher Cale
> Job Corps Data Center
> San Marcos, Tx
>
>
> sending to informix-list
All kidding aside - you just have to fake it!
We do this all the time. In a condensed version, this is what the
environment would look like for the procedure.
Production server: PRODSRVR
Instance: PRODINFMX
Test Server: TESTSRVR
Instance: TESTINFMX
First of all, you need to build the TESTINFMX instance to look just
like PRODINFMX, but I’ll assume you know that since you’ve
been using optape for this.
Second, make sure that Tivoli actually works on TESTSRVR (and
TESTINFMX). Even a simple backup will test this – and since
Tivoli’s error messages are VERY cryptic (and non revealing)
it’s better to validate before the restore.
When the server (client) actually communicates with the TSM server,
the client identifies itself through the dsm.sys configuration file.
This will be in a path like:
/usr/tivoli/tsm/client/ba/bin/dsm.sys
The entries include the following (of interest):
SERVERNAME tsmserver <-- your tsm backup
server
COMMMETHOD TCPip
TCPPORT 1500
TCPSERVERADDRESS 192.168.96.14 <-- address of backup server
NODENAME TESTSRVR <-- the client server identification
So, assuming you want to get the contents of PRODINFMX over to
TESTINFMX, here are the steps.
1. You copy the $INFORMIXDIR/etc/ ixbar.x file from the PRODINFMX
server to the TESTINFMX server (where x is the server number from
onconfig. This is how onbar knows what to request.
2. You copy the onnconfig from PROD to TEST so that both Informix
servers are named PRODINFMX. You need to change the environment
variables as well.
3. You change the NODENAME entry in the TESTSRVR dsm.sys file to
PRODSRVR
4. During this time, until you change the dsm.sys entry back, no TSM
backups should run!
5. Cold restore. When done, shut the instance down and bring back the
original onconfig file and environment variables so that the instance
once again thinks it’s TESTINFMX.
6. Bring up TESTINFMX
7. Change the entries back in dsm.sys
Changing the instance name by making changes to the onconfig file and
the environment variables is not required if your production instance
and your test instance are the same name.
fprose at supreme dot sp dot state dot az dot us