Re: How to back up multiple instances of DB2 of Windows

I'm doing this on an AIX DB2 install. There are 4-instances, but in the case
of AIX, each instance has its own startup script where I can specify a
different DSM.OPT file for each. I use the format of <hostname>_<instance>
as the nodename. For Windows, I would imaging you could code up a script
file (.BAT or .CMD) that would set the DSMI_* variables accordingly for the
instance you want to run the CLP against. My Windows DB2 server only has 1
instance, so I set them as part of the system environment. You could also
set the TSM_* database configuration options for each DB using the
appropriate nodename. (GET DB CFG FOR <db>) Do you have the redbook "Backing
up DB2 using TSM"? They suggest that the TSM_* db attributes are for restore
only and shouldn't be used for backups, but it doesn't say you CAN'T use
them.

What I'm still trying to figure out is the difference in ONLINE vs. OFFLINE
backups. If I run ONLINE backups do I really need to do OFFLINE backups,
too????

Bill Boyer
DSS, Inc.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
StorageGroupAdmin StorageGroupAdmin
Sent: Tuesday, August 20, 2002 1:18 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: How to back up multiple instances of DB2 of Windows


I am interested in finding out if anyone is using the supplied TSM API
to back up multiple instances of DB2 on a single Windows platform -
specifically how you manage the association between the instance and the
backup images.

The problem we have is when a restore is invoked thereturned  list of
backups does not differentiate between  the DB2 instances. This
therefore leads to the risk of a backup for one instance can overwriting
another.

We are considering modifying the API so that it will set the TSM client
(one client per instance) base upon the DB2 environmental variable
LOGFILE PATH (a sub-string of the setting contains the instance name
which will be set to the TSM client name)

Any comment or suggestions (other than move it off of Windows - it is
not up to me) would be appreciated


Peter Griffin
Sydney Water


-----------------------------------------------------------
This e-mail is solely for the use of the intended recipient
and may contain information which is confidential or
privileged. Unauthorised use of its contents is prohibited.
If you have received this e-mail in error, please notify
the sender immediately via e-mail and then delete the
original e-mail.
-----------------------------------------------------------