Tips to propagate the data using stageprop in a short amount of time.

The value for the batch size and transaction size parameters can help to propagate large amounts of data in a short amount of time in comparison to the OOB StagingProp utility from WCS 7 Fixpack 5 and prior.

However, we can make use of the STAGLOG.STGFILTER column to mark particular rows in the STAGLOG table to be propagated. When you run the StagingProp utility, you specify the filter parameter with the filter value and only records in the STAGLOG table with the associated filter value will be propagated to production.  Even the oracle streaming concept can be of much help with this approach. 

Another option is to use of the scope parameter. The parameter can be used to propagate changes for specific tables.