For database backups using TDP Informix, you're in luck. Informix uses a
fixed object name for the database full level-0 backup, so you can configure
it for normal TSM retentions. The archive logs are a different matter. They
are unique. A sequential number incremented for each log. So TSM versioning
won't work on that.
For the logs you can do a couple things....One is write some code (either
shell script or Perl) that gets the list of the backup objects by using the
TSM B/A client command line interface with the -SERVERNAME= of your TDPI
stanza. This will connect you to the server as the TDPI nodename. Then issue
a QUERY BACKUP <filespec> to get a list of the backup obejcts. You can then
decide which to EXPIRE using the DSMC.
Another way is to manipulate the SYSUTILS table for the Informix instance.
This table is a lot like the Oralcle RMAN catalog. If you remove entries in
there and then run the ONMSYNC (I think that's the Informix utility) this
will syncronize the SYSUTILS table with TSM.
It would be nice if Informix had a 'DELETE OBSOLETE" command like Oracle
RMAN.
Good Luck!
Bill Boyer
DSS, Inc.
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
David McClelland
Sent: Wednesday, July 21, 2004 4:16 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: TDP Informix - copygroup retention values on Server?
Guys & especially Del Hoobler ;o),
New to Informix backups. One of our internal customers has an Informix
consultant in who has never used TSM before, and is looking to try out
some TDPI/ONBAR backups to our TSM servers. Looking at what (little)
documentation there is for TDPI on IBM.COM, I'm a little in the dark as
how to register these nodes best at the TSM server side.
I've created a new domain for these backups, but when it comes to
retver, reto etc in the backup and archive copygroups, I can't find any
guidance at all in the docs. From my understanding of I have been able
to discover, expiration is managed at the Informix end, so am I looking
at a similar setup to the retention settings I've used in the past for
DB2/Oracle backups?
Any guidance most welcome!
TSM Server Solaris 5.1.6.2, clients at 5.1.6.2 (Solaris probably 8 but
could be 9), don't know which version of TDP for Informix they might be
using, but I presume a latest version.
Rgds,
David McClelland
Reuters Ltd, London
--------------------------------------------------------------- -
Visit our Internet site at http://www.reuters.com
Get closer to the financial markets with Reuters Messaging - for more
information and to register, visit http://www.reuters.com/messaging
Any views expressed in this message are those of the individual
sender, except where the sender specifically states them to be
the views of Reuters Ltd.
|
