Viewing DB2 system statistics settings

You can view the reports of all the system statistic settings in a database. You can use the database statistics to compare with any other database that has better performance and to updates values based on your database usage.

Procedure

1. Log in with the database instance owner credentials.
2. Run the db2look command with the -m parameter to produce a report that contains the DB2® commands to reproduce the current system statistic settings.

   db2look -m -d ldapdb2 -u ldapdb2 -o output_file