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:[EMAIL PROTECTED] Behalf Of David McClelland Sent: Wednesday, July 21, 2004 4:16 PM To: [EMAIL PROTECTED] 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.
