Personal tools
You are here: Home → DB2 → How To's → Script to Create a Runstats Script
Navigation
Log in


Forgot your password?
 
Document Actions

Script to Create a Runstats Script

Crating a little Runstats Script


db2 connect to <dbname>;

db2 -x "select 'runstats on
table',substr(rtrim(tabschema)||'.'||rtrim(tabname),1,40
),'and indexes all;'from syscat.tables where type = 'T'"
> runstats.sql

db2 connect reset;


Edit runstats.sql to add connect/ correct reset to your database.
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls