This dialog can be used to run several SQL scripts to gather statistics reports from the SQDR control database.
The scripts can be invoked by right-clicking on the server and name selecting Query... from the drop-down menu.
Additional usage information is documented in the scripts themselves.
IR_Keylog.sql - analyze ir_keylog contents. See the technical documents Using SQDR Key Logging Data and SQDR ir_keylog Table for more information.
TargetChecker.sql - reports discrepancy results of TargetChecker. See TargetChecker for more information.
IR_Group.sql - Illustrates ir_group name control table, providing decoding of I/R Group default options.
IR_GroupStats.sql - reports I/R Group activity.
IR_Subscription.sql - display incremental subscriptions, providing decoding of I/R Subscription options.
IR_SubscriptionStats.sql - reports ranked I/R Subscription activity.
Schedule.sql - displays the contents of the "schedule" control table listing scheduled groups and subscriptions
Statistics.sql - reports replication baseline results.
In addition, the scripts can be copied and used as templates for any additional customization that you may require.
For a control database residing in Db2 for LUW, use the scripts in Scripts\db2luw. You will need to first connect to the database SQDRC. The scripts assume that the control tables are in the schema SQDR. The scripts can be run in IBM Data Studio or another tool, including the DB2 command line processor.
For a control database residing in Microsoft SQL Server, use the scripts in Scripts\mssql. All scripts assume that the control database is named ControlDB; you will need to modify the scripts if your control database has another name. The scripts can be run in SQL Server management Studio or another tool, including command line tools such as sqlcmd.