Arnaud,
Your solution certainly sounds good. Would it be possible to share the shell
script you've written? That would be a great help.
thanks a lot anyway,
Kuret
------------------------
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote:
------------------------
>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
>
>
>
>
|
