Description

CheckTSN is a tool monitoring the delta between the smallest and the larger TSN number.

If this delta reach a predefined threshold a mail is send to rdb_operator.

CheckTSN is written in PERL.

Example

$ @chktsn mybase
max tsn = +207008806
min tsn = +206659157
delta = +349649
    PID(min tsn) = 20E00C38 (R/O)
$
New mail on node TETHIS from PIERONNE_JF (TETHIS) 21/01/2000 08:57
$ mail
MAIL> 1
    #1          21/01/2000 08:57                                         NEWMAIL
From:   PIERONNE_JF (TETHIS) 21/01/2000 08:57
To:     RDB_OPERATOR
CC:     PIERONNE_JF
Subj:   Transaction(s) tres ancienne(s), base mabase

tsn la plus recente = +207008806
tsn la plus ancienne = +206659157
delta = +349649
pid des process ayant la plus ancienne tsn
    PID(min tsn) = 20E00C38 (R/O)

MAIL> exit
$

Download

chktsn.zip
© Tous droits réservés 2002 Jean-François PIÉRONNE