I have a 1.8GB Sybase 7 SQL Anywhere database on Windows 2000 and I am trying to find a way to shrink the database as well as speed it up a little. I have a rather big table that contains Audit data and I thought of exporting these data from the database and keep them off-line (they are not needed on-line) and then delete them from the database.
I didn't see though any difference in db space after deleting them. Any ideas of how to shrink the database ?
ASA is slightly different and as part of your regular(maybe once every 3-6 months) maintenance activity needs to be rebuild.
This so that you can shrink the database. ASA through its lfetime only keeps growing and for a very active database would needs rebuilding using the dbunload -ar. This is one step unload and reload and very user interactive.
Rather than trying to do it all in one step (which I've never gotten to work), do the unload, database re-creation, and reload as 3 separate steps, each triggered manually from Sybase Central, and saving off the .db and .log files after re-creating the database, but before reloading it. Then if it (for example) fails on the reload, you don't have to re-do the unload and the database re-creation.
As to your specific problem, did you make sure you have your view nesting depth set correctly? If it's too shallow, the reload will probably fail.