Hi Kurt,
I understand your pain, as I've been living the same horror story as you
! What we did at the beginning was to use the C program, which worked
perfectly, allowing us to delete all or part of the logs on demand : a
real nice utility ! Concerning onsmsync : we found it that it was only
working after having been using expire.c program, to syncronize informix
DB with the real content of TSM.
Unfortunately, as we upgraded to the latest version of TSM API, to be in
a position to use latest Informix versions, we faced a problem : the C
program did not work anymore :(
Fortunately, I saw an option I never used before in the normal TSM
client itself : "expire" command ! Since, we wrote a little shell script
that regularly queries informix sysutils for finding obsoletes logs
numbers, and expire them using TSM client. Works as a charm !
Hope it helped ...
Cheers.
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 |
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-----Original Message-----
From: kurt.beyers AT pandora DOT be [mailto:kurt.beyers AT PANDORA DOT BE]
Sent: Tuesday, 29 April, 2003 12:42
To: ADSM-L AT VM.MARIST DOT EDU
Subject: expire logical logs Informix TSM
Hello everybody,
An old problem but I still don't know a good solution for it.
I'm backing up an Informix IDS 7.31 UD2X7 database on AIX 5.1 (32 bit)
using the TDP 4.1.3 for Informix. The BA client is 5.1.5.15 and the TSM
server (running on the same server as the Informix) is 5.1.6.4
How do the backup of the logical logs get expired in TSM?
The logical logs get a unique name so they never expire due to the
versioning limit in the management class.
I've been browsing the list a bit and possible solutions are:
-use the onsmsync tool of Informix to expire the logical logs in TSM
-use the C-program expire.c found on this list -use a specific
management class but what settings myst be applied (versions data
exists:1, versions data deleted:1, remain extra versions: 0 days, remain
only version: y days)?
So what is the elegant way to get rid of the no longer needed logical
logs in TSM? There isn't much (ie nothing) mentioned about it in the
install&user guide of the TDP or neither in the redbook 'Using ADSM to
backup databases'.
Thanks in advance for any hints / guidelines.
regards,
Kurt
|
