Deployment Guide
7Reorg.sh output may indicate that reorganizing some of the tables offline would be beneficial. For
example:
“WARNING: CARAT7.SCAN_RADIO needs OFFLINE REORG”
In order to execute offline reorganization of tables:
Step 1: Stop Carat and Application servers
# 7carat stop
# 7analyzer stop
Step 2: Switch to “db7sign” user
Step 3: Connect to measurement database
$ db2 connect to meas7
Step 4: Execute reorganization command for each table that required offline reorganization
$ db2 reorg table CARAT7.SCAN_RADIO
Step 5: Switch back to root user and start Carat and Application servers
$ exit
# 7carat start
# 7analyzer start
7signal Solutions Inc., 6155 Rockside Road, Suite 110, Independence, Ohio 44131, USA,
216-777-2900, info@7signal.com, www.7signal.com