lg-zsync

Synchronize DB2 z/OS Catalog Statistics between different DB2 subsystems.

DB2 Optimizer decisions about SQL access paths are based on catalog statistics.
For performance tuning and quality assurance processes on development and test systems it is sufficient to copy catalog statistics from production environments.
This is an easy and fast way to predict access paths in a development or test environment

The purpose of zSYNC is to synchronize DB2 catalog statistics that are relevant for the DB2 optimizer's access path decisions between two or more DB2 systems.
The tool can also be used to backup and restore DB2 catalog statistics on any DB2 subsystem.

graphic