Sean, Since you will be using onbar, you will be doing full backups (onbar Level Zero or whole_system) or Level One or Level Two backups. Look at an onbar backup / restore guide... they are available for download from the Informix web site... The Level One & Two backups are roughly the same as doing incremental backups... Make all your backups "archive" type backups and this will give them finite expiration days... You CAN NOT do incremental backups using TSM... Make up a management class with copy groups of only the type "archive" and point your logical logs into the one that has the longest retention because none of your backups will be worth anything without the logical logs to bring a restore back to a point in time. Thus you will have copy groups (archive) with 32 day retention for your weekly, the daily backups will go in there as well and will be some combination of Level Zero (or whole_system) and L1s and L2s (read the onbar backup/restore guide) and your monthly and quarterly backups will be whole_system and you will put them into management class / copy group (archive) for the desired retention. I would suggest if you are serious about actually restoring the 2 year backups, you might consider having your DBA unload the tables to flat files and also back up the database schema to the same directory and then tar the mess to a tape. If your work site is anything like mine, you will be on a different version of TSM & Informix in the next few months, let alone next couple years and if you change Informix versions, the TSM backup can likely be restored only to the same version of Informix... This means you have to have a spare server and the old software to be able to recreate the environment present when you did the backup. The DBA will then have to unload the db to flat files in order to be able to load it back to the production environment...
George Lesho AFC Enterprises "Ramnarayan, Sean A [EDS]" <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 02/05/2002 05:17:16 AM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: (bcc: George Lesho/Partners/AFC) Fax to: Subject: Management Class Setup Hi I need assistance in setting up a management class for a Informix database on a AIX server. We are currently running ADSM server Version 3. The ADSM/API client installed on the server is version 3.1.20.7. We are using the Onbar utility to backup the Informix database to ADSM. The scheduled Informix backups needs to be kept for the following periods : 1) A full backup to run once a week to be kept for 32 days 2) A incremental backup to run daily excluding when the full backup runs to be kept for 32 days. 3) A full backup once a month to be kept for 2 years. 4) A full backup every 3 months to be kept for 1 year. Please take in consideration the Informix logs must also be backed up. I also need to use the same NODE name as well as the same Storage pool when defining the management class. Your help in the above will be greatly appreciated. Thks Sean Ramnarayan TSM Administrator EDS (South Africa) "MMS <caltex.com>" made the following annotations on 02/05/2002 01:17:17 PM ------------------------------------------------------------------------------ DISCLAIMER This message may contain confidential information that is legally privileged and is intended only for the use of the parties to whom it is addressed. If you are not an intended recipient, you are hereby notified that any disclosure, copying, distribution or use of any information in this message is strictly prohibited. If you have received this message in error, please notify the sender immediately and delete the message. Thank you. ==============================================================================
