Hi Arnaud, I am now in the final testing phase before going production on
SQL-BackTrack for Informix V.3 (was on 2.1). This version has an "expiration"
feature built into its 'ibacktrack' program which will allow expiration of logs
via that utility and will also generate a script which you can run via the TSM
admin schedule or Maestro to expire old Informix logs. The 2.1 version we were
using before did not have any expiration and TSM couldn't expire this stuff so I
went through our filespaces once in a while and deleted old filespaces. The
problem with this (we have large databases) is that it would overload our
reclamation process. I have a 3575 L32 and must use an overflow location and
when the Informix filespaces were deleted, I would end up spending a few days in
front of the library shuffling tapes. Hopefully, the V.3 expiration capability
(by using scripts it generates) will fix this.
George Lesho
Storage / System Admin
AFC Enterprises
Arnaud Brion <Arnaud.Brion AT PAC.PANMAIL DOT COM> on 02/13/2001 10:01:42 AM
Please respond to "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: expiring Informix logs ...?
Hi everybody !
I come back on something that seems to be an old subject for *SM'ers : we're
using the Onbar API to ensure the backup of our informix logs, what works really
nicely, except we're facing a huge increasing of the number of tapes used for
this storagepool, due to the fact that TSM is unable to expire those logs.
We tried to install the onsmsync utility a few month ago, which was supposed to
give us a rid of this problem, but I just saw today that it isn't working at all
!
Does anybody know if Informix or Tivoli found a solution to this problem (new
version of onsmsync ?), or if there is any other way expiring those #@#@@...
logs ?
I saw there is a c programm existing but I have no idea of c language so if you
know something easier, just let me know !
Thanks in advance ! ;-)
Arnaud
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
| Arnaud Brion, Panalpina Management Ltd., IT Group |
| Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland |
| Phone: +41 61 226 19 78 / Fax: +41 61 226 17 01 |
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
|
