The following tables list user-configurable properties that are specific to certain source DBMS types. See Configuration Reference for details.
Property |
Db2 for i |
Db2 LUW |
Oracle |
SQL Server Change Tracking |
SQL Server Change Data Capture |
Informix |
MySQL |
alwaysUseRowId |
X |
|
X |
|
|
|
|
archivedLogPath |
|
X |
|
|
|
|
|
autoGrant |
X |
|
X |
|
|
|
|
autoJournal |
X |
|
|
|
|
|
|
avoidActiveLog |
|
|
X |
|
|
|
|
batch |
X |
|
|
X |
X |
|
|
batchSize |
X |
|
|
X |
X |
|
|
compareChangeData |
X |
X |
X |
|
X |
X |
X |
continuousMining |
|
|
X |
|
|
|
|
deleteLogsWithoutSave |
|
X |
|
|
|
|
|
filterJobName |
X |
|
|
|
|
|
|
filterProgramName |
X |
|
|
|
|
|
|
filterUserID |
X |
X |
X |
|
|
|
|
jdbcProperties |
|
|
X |
|
|
|
|
managedLogs |
X |
X |
|
|
|
|
|
manageMsCdcCapture |
|
|
|
|
X |
|
|
minimumDelay |
|
|
|
X |
|
|
|
minimizeChangeData |
X |
X |
X |
|
X |
|
|
multiMember |
X |
|
|
|
|
|
|
numArchiveLogsPerSession |
|
|
X |
|
|
|
|
numArchiveSession |
|
|
X |
|
|
|
|
oracleDictionary |
|
|
X |
|
|
|
|
prefetchDepth |
|
|
X |
|
|
|
|
receiverLibrary |
X |
|
|
|
|
|
|
supplementalLogging |
|
|
X |
|
|
|
|
udbAuthentication |
|
X |
|
|
|
|
|
udbReadLogUsingSP |
|
X |
|
|
|
|
|
userSpaceSize |
X |
|
|
|
|
|
|
xstream |
|
|
X |
|
|
|
|
xstreamFilter |
|
|
X |
|
|
|
|
xstreamUser |
|
|
X |
|
|
|
|
xstreamPassword |
|
|
X |
|
|
|
|
xstreamServer |
|
|
X |
|
|
|
|
xstreamUrl |
|
|
X |
|
|
|
|
The following advanced properties should not be changed except under direction of StarQuest Support:
Property |
Db2 for i |
Db2 LUW |
Oracle |
SQL Server Change Tracking |
SQL Server Change Data Capture |
Informix |
MySQL |
alterOption |
X |
X |
X |
|
|
|
|
ifxBufferSize |
|
|
|
|
|
X |
|
ifxReadSize |
|
|
|
|
|
X |
|
maxNonTxTables |
X |
|
|
|
|
|
|
msSqlChangeTracking |
|
|
|
X |
X |
|
|
oracleFetchSize |
|
|
X |
|
|
|
|
oracleWhereClause |
|
|
X |
|
|
|
|
singleWorkerDefault |
X |
|
|
|
|
|
|