we have cdc on linux and aix between db2 luw databases
we have different data centers communicating with the central datastore
we would like to generate some reports, indicating
nbr rows/bytes inserted/updated for each day
I know that you can collect performance statistics, but these are more related to performance issues
is there a tool/possibility to collect/create some data about these operatoions
is there any doc that could help us creating/collecting this data/info



------------------------------
Thanks for all answers
Best Regards,
Guy Przytula
------------------------------


#DataIntegration
#DataReplication

Guy, you can create a CHCCLP script to capture this information.
A basic script
chcclp session set to cdc;
connect server username user1 password secret;
connect datastore name src_ds context source;
connect datastore name tgt_ds context source;
select subscription SUB1;
monitor subscription activity;
select subscription SUB2;
monitor subscription activity;
..
disconnect datastore name src_ds;
disconnect datastore name tgt_ds;
disconnect server;
exit;

The output would be by default to standard output, so you would have to redirect the output to a file, and then strip out header information and command echoing, and then parse it to get the data.

The stats are cumulative since the subscription started so if a subscription remains active over several days you would have to subtract the previous day's values from the current day's values to get today's values. Of course if the subscription is restarted the stats start again from zero.  If the subscription is not active, the chcclp script will through an error.

Another option is to use Java (MC APIs) which avoids having to parse output files but obviously involves supporting Java, You will find various samples at IIDR Samples 

Regards

Robert

------------------------------
Robert Philo
------------------------------