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]" <SARamnarayan AT CALTEX DOT COM>@VM.MARIST.EDU> on
02/05/2002 05:17:16 AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
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
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.

 =============================================================================