On the sybase-l mailing list,
Sybase
Jeff Tallman replied to a question on how to avoid unnecessary reorgs. He graciously agreed to let me post his response here 
You can avoid most (if not all) of the reorgs by doing:
- setting the exp_row_size to something that covers about 90% of the space each row takes up
- changing enable housekeeper GC to a 4 or 5
Both of these are a *MUST* do for DOL (datapages or datarows). See manuals on ‘enable housekeeper GC’ for correct setting of 4 or 5 (refers to whether deletes are batch or OLTP).
You can also watch for housekeeper overflows in monEngine/monOpenObjectActivity……and if you see any HKGC pending – wait a few before shutting down.
Jeff wrote up an excellent article, Locking Redux – APL vs. DOL and Tuning, that goes into detail why this is the case.
Hi Jason,
This is slightly off the topic of your post, but would you happen to know where I can find the Techwave presentations for 2006, 2007, 2008, and 2009? The official link to http://www.sybase.com/techwave/conference_content only contains presentations through 2005. No help from the forums at all.
Thanks!
2008 – http://www.sybase.com/detail?id=1069518&siteId=1
For 2009 & 2007, you need to get it from ISUG (http://my.isug.com).
Hi Jason,
How are you and very long time, hope you remember me , am your ex mate in UBS
hope your doing good and i would like to access the below docs. please help me to get this, due have tried to click on the above link but i can’t get it
Ref :
Jeff wrote up an excellent article, Locking Redux – APL vs. DOL and Tuning, that goes into detail why this is the case.
cheers,
Gopal
Locking Redux – APL vs. DOL and Tuning