IBM® Security Verify Governance Version 10.0.1 Performance Tuning Guide 2nd Edition
This guide provides detailed instructions for tuning the middleware performance of IBM Security Verify Governance Version 10.0.1. It covers database statistics for DB2 and Oracle, tuning event queues and caches, task planning, concurrency, I/O optimization, and bulk load operations. It also includes sections on PostgreSQL, UI dashboards, access request modules, and monitoring tools like SNMP and Tcpdump. The guide is intended for administrators and DBAs to optimize performance for enterprise deployments.
The guide includes specific commands for enabling DB2 monitors, resetting statistics, running runstats and db2rbind, and using Oracle’s DBMS_STATS package for both automatic and manual statistics gathering. It also addresses performance improvements from tuning indexes, handling foreign key constraints, and managing large-scale campaigns. Best practices for database administration and tuning are emphasized throughout.
The database instance must be restarted.
Run db2 reset monitor all on the running database; this does not require an instance restart afterward.
It is suggested for tables significantly modified during the day and for objects that are targets of large bulk loads which add 10% or more to the object’s total size.
It updates the statistics for static SQL, improving query plan performance.