i am completely new to DB admin tasks as well as sybase.
we have some tables which grow freuquently in size.
i wanted to know how we can purge the data from these tables which are
say like older than 2 months.
can we identify whats the size of each table ? can we purge few
records once the size of the table grows than specified limit say 1
are there any utils ? are there common pitfalls like db file growing
instead of reducing ?
One way of easily identifying and purging old data in a table would be to add a column like date_inserted which will be populated with the system date during inserts / updates, using this column you may easily identify those rows that are older than your criteria and delete them (perhaps a cron job running may be once a day depending on the table usage)