KB Article #66797

DB2 Database maintenance

Problem

-- DB2 database
-- Required steps after installing Interchange on new DB2 database
-- Required periodic maintenance for DB2 database



* following issues could arise if db2_runstats not run (after install, and as periodic maintenance)
-- CN or TE restarts due to database connection error
-- Poor performance
-- Unexplained issues related to slowness


Resolution

-- As part of installation of Interchange with DB2 database:
Read admin guide: "Set up DB2" section of "Configure external database".
Follow all steps in sections "DB2 tuning guidelines" and "Steps for DB2 database".




-- As part of periodic maintenance to maintain DB2 database and optimize performance:
1. Stop the server.
2. Run the db2_runstats command in the trading engine tools directory.  
You may need to make your current directory point to where you normally run DB2 commands, and fully path to the build\tools\db2_runstats command from there.
3. Start the server.