Author: Jerzy Wachowiak; Version: 1.1; Last update: 2005-05-20.
==========================================
Hints for administrative tools usage
==========================================
@ The idea behind administrative tools is to have 2 sets of utilities.
The first one deals with messages and statistcs belonging to one single thread,
the second one deals on statistics without distinction of thread for the whole
archive. The admin can check the state of the integration looking at the
statistics of all threads and than look closer at single threads,
where something went wrong.
@ Utilities acting on a one choosen thread:
[1] xdshow
USAGE:
./xdshow -d database [-u user] [-p password] -t thread [-ms]
DESCRIPTION:
xdshow displays messages and statistics belonging to a thread from the database:
-m shows only messages belonging to the thread (option);
-s shows only statistic belonging to the thread (option);
-t thread the message thread to act on;
-d name PostgreSQL database name;
-u user username, if no switch, root assumed;
-p password password, if no switch, root password assumed.
OUTPUT:
[1] -m switch (messages):
thread varchar( 250 );
entrytime timestamp;
fromuser varchar( 257 );
server varchar( 342 );
resource varchar( 250 );
type varchar( 20 );
subject varchar( 500 );
body text;
errorcode int;
errordescription varchar( 500 )
[2] -s switch (statistics):
thread varchar( 250 ) not null;
lastupdate timestamp;
starttime timestamp;
deltatime interval default '0 second';
sender1_occurence int not null default '0';
...
senderX_occurence int not null default '0';
receiver1_occurence int not null default '0';
receiver1_result int not null default '0';
...
receiverX_occurence int not null default '0';
receiverX_result int not null default '0';
error_counter int not null default '0'
[2] xddelete
USAGE:
./xddelete -d database [-u user] [-p password] -t thread [-ms]
DESCRIPTION:
xddelete removes messages and statistics belonging to a thread from the
database and returns number of deleted messages and statistics:
-m deletes only messages belonging to the thread (option);
-s deletes only statistics belonging to the thread (option);
-t thread the message thread to act on;
-d name PostgreSQL database name;
-u user username, if no switch, root assumed;
-p password user password, if no switch, root password assumed.
OUTPUT:
number of removed messages;
number of removed statistics
@ Utilties acting on all messages and statisctics fulfilling the conditions:
[1] xdlist
USAGE:
./xdlist -d database [-u user] [-p password] [-gbrfwt] [-o time]
DESCRIPTION:
xdlist displays message statistics from the database:
-g good jobs, jobs done by receiver without errors (option);
-b bad jobs, some errors reported by receiver (option);
-r running job, sender or receiver message still missing (option);
-f finished jobs, both sender and receiver sent a message (option);
-w warning, messages with the same thread arrived several times
from sender or receiver (option);
-o time at least delta time in seconds between sender and receiver
message arrival (option);
-t lists only threads, no other information (option);
-d name PostgreSQL database name;
-u user username, if no switch, root assumed;
-p password user password, if no switch, root password assumed.
OUTPUT:
thread varchar( 250 ) not null;
lastupdate timestamp;
starttime timestamp;
deltatime interval default '0 second';
sender1_occurence int not null default '0';
...
senderX_occurence int not null default '0';
receiver1_occurence int not null default '0';
receiver1_result int not null default '0';
...
receiverX_occurence int not null default '0';
receiverX_result int not null default '0';
error_counter int not null default '0'
[2] xdpurge
USAGE:
./xdpurge -d database [-u user] [-p password] [-gbrfw] [-o time]
DESCRIPTION:
xdpurge deletes all messages and statistics fulfilling the conditions
from the database and returns number of deleted messages and statistics:
-g good jobs, jobs done without errors by receiver (option);
-b bad jobs, some errors reported by receiver (option);
-r running job, sender or receiver message still missing (option);
-f finished jobs, both sender and receiver sent a message (option);
-w warning, messages with the same thread arrived several times
from sender or receiver (option);
-o time at least delta time in seconds between sender and receiver
message arrival (option);
-d name PostgreSQL database name;
-u user username, if no switch, root assumed;
-p password user password, if no switch, root password assumed.
OUTPUT:
number of removed messages;
number of removed statistics
@ Auxiliary scripts
[1] chmod-xd
USAGE:
./chmod-xd options
DESCRIPTION:
chmod-xd changes permissions for files listed in the chmod-xd script.
See chmod man pages for option details!