tabprune.8¶
NAME¶
tabprune - Deletes records from the eventlog,auditlog,isnm_perf,isnm_perf_sum tables.
SYNOPSIS¶
tabprune eventlog | auditlog [-V] -i recid |-n number of records | -p percentage | -d number of days | -a
tabprune tablename -a
tabprune [-h | --help] [-v | --version]
DESCRIPTION¶
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. The all records options (-a) can be used on any xCAT table.
OPTIONS¶
-h|--help
Display usage message.
-V
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.
-a
Remove all records from the input table name. This option can be used on any xCAT table.
-i recid number
Remove the records whose recid is less than the input recid number.
-n number
Remove the number of records input.
-p percent
Remove the number of records input.
-d number of days
Remove all records that occurred >= than number of days ago.
EXAMPLES¶
*
To remove all the records in the eventlog table:
tabprune eventlog -a
*
To remove all the records in the eventlog table saving the deleted records in eventlog.csv:
tabprune eventlog -V -a > eventlog.csv
*
To remove all the records before recid=200 in the auditlog table:
tabprune auditlog -i 200
*
To remove 400 records from the auditlog table and display the remove records:
tabprune auditlog -V -n 400
*
To remove 50% of the eventlog table:
tabprune eventlog -p 50
*
To remove all records that occurred >= 5 days ago in the eventlog:
tabprune eventlog -d 5
FILES¶
/opt/xcat/sbin/tabprune
SEE ALSO¶
tabrestore(8)|tabrestore.8, tabedit(8)|tabedit.8,tabdump(8)|tabdump.8