Deployment Guide

Notice: Offline reorganization of a table can take several hours. However, table level
reorganizations are not needed very often.
14.2.3Scheduling reorganizations
Reorganizations should be done regularly. Probably the easiest way to schedule reorganizations is to use
cron.
Important: Use crontab of “db7sign” user.
Example reorganizations schedule
Use “crontab -e” to edit the crontab of the “db7sign”user.
# Reorganization every Sunday at 3 am. Redirect output to /var/log/reorg.log
0 3 * * 0 /opt/7signal/dbms/scripts/7Reorg.sh >> /var/log/reorg.log 2>&1
7signal Solutions Inc., 6155 Rockside Road, Suite 110, Independence, Ohio 44131, USA,
216-777-2900, info@7signal.com, www.7signal.com