Deployment Guide

14.4 Collecting statistics
Collecting statistics (“RUNSTATS”) about the data in regular basis is important in order to keep database
query optimizer up to date, and it makes possible for the optimizer to always select the best access path
for the data. The 7Runstats.sh tool, located in directory /opt/7signal/dbms/scripts, collects statistics
on all measurement data tables.
14.4.1Executing statistics collection
Step 1: Switch to “db7sign” user
Step 2: Execute the utility.
$ /opt/7signal/dbms/scripts/7Runstats.sh
Example output:
Start time: Wed Aug 22 11:41:17 EEST 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