Deployment Guide

The 7Reorg.sh tool, located in directory /opt/7signal/dbms/scripts, checks if tables or indexes need
a reorganization, and executes the online reorganization if necessary. Depending on DB2 license, the tool
can either reorganize tables and indexes, or indexes only:
● DB2 Express-C (default license): Reorganizes indexes only. The tool outputs a warning if it
detects a table that would need reorganization. Offline reorganization is needed for the tables.
● DB2 Express/Workgroup etc.: Reorganizes tables and indexes
14.2.1Executing online reorganization
Step 1: Switch to “db7sign” user
Step 2: Execute the utility.
$ /opt/7signal/dbms/scripts/7Reorg.sh
Example output on a system with DB2 Express-C database
Reorg start time Sun Aug 19 10:00:01 EDT 2018
Database Connection Information
Database server = DB2/LINUXX8664 10.5.5
SQL authorization ID = DB7SIGN
7signal Solutions Inc., 6155 Rockside Road, Suite 110, Independence, Ohio 44131, USA,
216-777-2900, [e-mail], www.7signal.com