OGG-30082
The DBOPTIONS _rollbacktransactiononerror is enabled. This causes the transaction to get rolled back in case of any error. The CDR, HANDLECOLLISIONS and REPERROR features will not work in presence of this parameter.
Cause
ODBC DSN attribute TransactionErrorBehavior is internally set to 2 for supporting CDR, HANDLECOLLISIONS and REPERROR features. This setting will have an impact on performance. If the user is not interested in any of these features, user can specify the DBOPTIONS _rollbacktransactiononerror in the parameter file to avoid unnecessary performance degradation.
Action
Remove the DBOPTIONS _rollbacktransactiononerror parameter from the REPLICAT parameter file if the user is interested in any of the CDR, HANDLECOLLISIONS and REPERROR features.
OGG-30082
The DBOPTIONS _rollbacktransactiononerror is enabled. This causes the transaction to get rolled back in case of any error. The CDR, HANDLECOLLISIONS and REPERROR features will not work in presence of this parameter.
Cause
ODBC DSN attribute TransactionErrorBehavior is internally set to 2 for supporting CDR, HANDLECOLLISIONS and REPERROR features. This setting will have an impact on performance. If the user is not interested in any of these features, user can specify the DBOPTIONS _rollbacktransactiononerror in the parameter file to avoid unnecessary performance degradation.
Action
Remove the DBOPTIONS _rollbacktransactiononerror parameter from the REPLICAT parameter file if the user is interested in any of the CDR, HANDLECOLLISIONS and REPERROR features.