2010-04-09 17:11:24 +00:00
=head1 NAME
2011-04-27 16:08:43 +00:00
B<tabprune> - Deletes records from the eventlog,auditlog,isnm_perf,isnm_perf_sum tables.
2010-04-09 17:11:24 +00:00
=head1 SYNOPSIS
2011-09-14 14:01:52 +00:00
B<tabprune> B<eventlog | auditlog> [B<-V>] B<-i> I<recid> |B<-n> I<number of records> | B<-p> I<percentage> | B<-d> I<number of days> | B<-a>
2010-04-09 17:11:24 +00:00
B<tabprune> [B<-h>|B<--help>] [B<-v>|B<--version>]
=head1 DESCRIPTION
2011-04-27 16:08:43 +00:00
The tabprune command is used to delete records from the auditlog,eventlog,isnm_perf,isnm_perf_sum tables. As an option, the table header and all the rows pruned from the specified table will be displayed in CSV (comma separated values) format.
2010-04-09 17:11:24 +00:00
=head1 OPTIONS
=over 10
=item B<-h|--help>
Display usage message.
2012-12-04 15:32:56 +00:00
=item B<-V>
2012-12-04 22:40:42 +00:00
Verbose mode. This will cause tabprune to display the records that are being deleted from the table, in case
you want to redirect them to a file to archive them.
2012-12-04 15:32:56 +00:00
2010-04-09 17:11:24 +00:00
=item B<-a>
Remove all records.
=item B<-i> I<recid number>
Remove the records whose recid is less than the input recid number.
=item B<-n> I<number>
Remove the number of records input.
=item B<-p> I<percent>
2012-12-04 15:32:56 +00:00
Remove the number of records input.
2010-04-09 17:11:24 +00:00
2011-09-14 14:01:52 +00:00
=item B<-d> I<number of days>
Remove all records that occurred >= than number of days ago.
2010-04-09 17:11:24 +00:00
=back
=head1 RETURN VALUE
=over 3
=item 0
The command completed successfully.
=item 1
An error has occurred.
=back
=head1 EXAMPLES
=over 2
=item *
To remove all the records in the eventlog table:
B<tabprune> I<eventlog> -a
=item *
To remove all the records in the eventlog table saving the deleted records in eventlog.csv:
B<tabprune> I<eventlog> -V -a > eventlog.csv
=item *
To remove all the records before recid=200 in the auditlog table:
B<tabprune> I<auditlog> -i 200
=item *
To remove 400 records from the auditlog table and display the remove records:
B<tabprune> I<auditlog> -V -n 400
=item *
To remove 50% of the eventlog table:
B<tabprune> I<eventlog> -p 50
2011-09-14 14:01:52 +00:00
=item *
To remove all records that occurred >= 5 days ago in the eventlog:
B<tabprune> I<eventlog> -d 5
2010-04-09 17:11:24 +00:00
=back
=head1 FILES
/opt/xcat/sbin/tabprune
=head1 SEE ALSO
L<tabrestore(8)|tabrestore.8>, L<tabedit(8)|tabedit.8>,L<tabdump(8)|tabdump.8>
