B Oracle GoldenGate Commands and Parameters that you can use with the Properties Inspector
See Oracle GoldenGate Commands and Oracle GoldenGate Parameter .
Note:
Deprecated Oracle GoldenGate parameters are not displayed or supported in Oracle GoldenGate Studio. You can review deprecated parameters in Release Notes for Oracle GoldenGate for Windows and UNIX
Commands with Options
The Oracle GoldenGate commands with the specified options are listed in the following sections.
ADD EXTRACT Commands
For an explanation of the command, see the ADD EXTRACT
command.
ADD EXTRACT Command | Oracle GoldenGate Studio Label |
---|---|
ADD EXTRACT |
Add Extract |
SOURCEISTABLE |
Table |
TRANLOG |
Transaction Log |
INTEGRATED TRANLOG |
Integrated Capture Mode |
VAM |
Vendor Access Module |
EXTFILESOURCE |
Source File Name |
EXTTRAILSOURCE |
Source Trail Name |
VAMTRAILSOURCE |
VAM Trail Name |
BEGINNOW |
Now |
EXTSEQNO |
At Sequence Number |
EXTRBA |
Relative Byte Address |
EOF |
End of Log File |
LSN |
LSN |
EXTRBA |
Relative Byte Address |
PAGE |
Page |
ROw |
ROW |
SEQNO |
Sequence Number |
SCN |
System Change Number |
THREADS |
Threads |
PASSIVE |
Passive |
PARAMS |
Parameter File |
REPORT |
Report File |
DESC |
Description |
ADD REPLICAT Commands
For an explanation of the command, see the ADD REPLICAT
command.
ADD REPLICAT Options | Oracle GoldenGate Studio Label |
---|---|
ADD REPLICAT |
Add Replicat |
INTEGRATED |
Integrated |
COORDINATED |
Coordinated |
MAXTHREADS |
Max Threads |
SPECIALRUN |
Special Run |
EXTFILE |
Extract File |
EXTTRAIL |
Extract Trail |
BEGIN |
Begin |
NOW |
Now |
EXTSEQNO |
Sequence Number |
EXTRBA |
Relative Byte Address |
CHECKPOINTTABLE |
Checkpoint Table |
NODBCHECKPOINT |
No Checkpoint Table |
PARAMS |
Parameter File |
REPORT |
Report File |
DESC |
Description |
ADD EXTTRAIL Command
For an explanation of the command, see the ADD EXTRAIL
command.
ADD EXTTRAIL Options | Oracle GoldenGate Studio Label |
---|---|
ADD EXT TRAIL |
Add Extract Trail |
EXTRACT |
Extract |
MEGABYTES |
Megabytes |
SEQNO |
Sequence Number |
ADD RMTTRAIL Command
For an explanation of the command, see the ADD RMTTRAIL
command.
ADD RMTTRAIL Options | Oracle GoldenGate Studio Label |
---|---|
ADD RMTTRAIL |
Add Remote Trail |
EXTRACT |
Extract |
MEGABYTES |
Megabytes |
SEQNO |
Sequence Number |
REGISTER EXTRACT Command
For an explanation of the command, see the REGISTER EXTRACT
command.
REGISTER EXTRACT Options | Oracle GoldenGate Studio Label |
---|---|
REGISTER EXTRACT |
Register Extract |
DATABASE |
Database |
CONTAINER |
Container |
ADD CONTAINER |
Add Container |
DROP CONTAINER |
Drop Container |
LOGRETENTION |
Log Retention |
SCN |
System Change Number |
START EXTRACT Command
For an explanation of the command, see the START EXTRACT
command.
Start Extract Command | Oracle GoldenGate Studio Label |
---|---|
START EXTRACT |
Start Extract |
ATCSN |
At CSN |
AFTERCSN |
After CSN |
START REPLICAT Command
For an explanation of the command, see the START REPLICAT
command.
Start Replicat Command | Oracle GoldenGate Studio Label |
---|---|
START REPLICAT |
Start Replicat |
SKIPTRANSACTION |
Skip Transaction |
ATCSN |
At CSN |
AFTERCSN |
After CSN |
FILTERDUPTRANSACTIONS |
Filter Duplicate Transactions |
THREADS |
Threads |
ADD TRANDATA Command
For an explanation of the command, see the ADD TRANDATA command.
Add Supplemental Logging Command | Oracle GoldenGate Studio Label |
---|---|
ADD SCHEMATRANDATA |
Enable Schema Supplemental Logging |
ALLCOLS |
Logging Columns |
ALLOWNONVALIDATEDKEYS |
Allow Non-Validated Keys |
ADD TRANDATA |
Enable Table Supplemental Logging |
COLS |
Logging Columns |
NOKEY |
Suppress Primary Key Columns |
INCLUDELONG |
Include LONGVAR Columns |
EXCLUDELONG |
Exclude LONGVAR columns |
Parameter Category Names
This section lists the parameter category names available for Oracle GoldenGate Studio.
-
Add Extract Options
-
Add Replicat Options
-
Extract Registration
-
Globals
-
General
-
Environment Variables
-
Include
-
Port Management
-
Process Management
-
Event Management
-
Maintenance
-
Processing Method
-
Selection, Converting, and Mapping Data
-
Routing Data
-
Formatting Data
-
Custom Processing
-
Reporting
-
Tuning
-
Error Handling
-
Rep Error
-
Security
-
Other
-
Advanced
-
Start Extract Options
-
Start Replicat Options
-
Supplemental Logging
For more information on parameter categories, see Oracle GoldenGate Parameters.
Units of Measure
This section describes the units of measure available for Oracle GoldenGate Studio.
Unit | Option |
---|---|
MS |
Millisecond |
CS |
Centisecond |
CSEC |
Centisecond |
CSECS |
Centiseconds |
S |
Second |
SEC |
Second |
SECOND |
Second |
SECS |
Seconds |
SECONDS |
Seconds |
M |
Minute |
MIN |
Minute |
MINUTE |
Minute |
MINS |
Minutes |
MINUTES |
Minutes |
H |
Hour |
HR |
Hour |
HOUR |
Hour |
HOURS |
Hours |
D |
Day |
DAY |
Day |
DAYS |
Days |
WEEK |
Week |
WEEKS |
Weeks |
K |
Kilobyte |
KB |
Kilobyte |
MB |
Megabyte |
G |
Gigabyte |
GB |
Gigabyte |
Opposites
This section describes the opposites between Oracle GoldenGate parameters or options and Oracle GoldenGate Studio labels.
Oracle GoldenGate Parameters/Options | Oracle GoldenGate Studio Label |
---|---|
batchsql.nobatcherrormode |
No Batch Error Mode |
batchsql.nobypasspkcheck |
Do not Bypass PK Check |
batchsql.nocheckuniquekeys |
Do not Check Unique Keys |
batchsql.noerrorhandling |
No Error Handling |
bulkload.nologging |
Disable Redo Logging |
bulkload.noparallel |
Disable Parallel Loading |
dboptions.noallowlobdatatruncate |
Disallow LOB Truncation |
dboptions.noallowunusedcolumn |
Disallow Unused Columns |
dboptions.nocatalogconnect |
No Separate Catalog Connection |
dboptions.nofetchlobs |
Disallow LOB Fetching |
dboptions.nolimitrows |
Do not Limit Rows |
dboptions.noreparselobsql |
Do not Reparse LOB SQL |
dboptions.noshowwarnings |
Do not Log Warnings |
dboptions.noskiptemplob |
Do not Skip Temp LOB |
dboptions.nospthread |
No Separate Connection For Stored Procedures |
dboptions.nosuppresstriggers |
Do not Suppress Triggers |
ddloptions.CROSSRENAME |
Cross Rename |
ddloptions.ignoreapplops |
Ignore Application Operations |
ddloptions.ignorereplicates |
Ignore Replicat Transactions |
ddloptions.nomapderived |
Disallow Derived Name Mapping |
ddloptions.noreplicatepassword |
Do not Replicate Password |
ddloptions.noreport |
Do not Log DDL Operations To Report File |
disableheartbeat |
Disable Heartbeat |
disableheartbeattable |
Disable Heartbeat Table |
disablenewmanager |
Disable New Manager |
extfile.no_objectdefs |
No Object Definitions |
exttrail.no_objectdefs |
No Object Definitions |
fetchoptions.nodetaileddiagnostics |
No Detailed Diagnostics |
fetchoptions.nodiagnosticsonall |
No Diagnostics On All |
fetchoptions.nousediagnostics |
Do not Use Diagnostics |
fetchoptions.nousekey |
Do not Use Key |
fetchoptions.nouselatestversion |
Do not Use Latest Version |
fetchoptions.nouserowid |
Do not Use Row ID |
fetchoptions.nousesnapshot |
Do not Use Snapshot |
fetchoptions.suppressduplicates |
Suppress Duplicates |
formatascii._noind |
No Ind |
formatascii._noop |
No Op |
formatascii._nots |
No TS |
formatascii.nonames |
Exclude Column Names |
formatxml.noinlineproperties |
Write Properties Outside XML Tab |
formatxml.notrans |
Exclude Commit Markers |
ignorealters |
Ignore Alters |
ignoreapplops |
Ignore Application Operations |
ignorecreates |
Ignore Creates |
ignoredeletes |
Ignore Deletes |
ignoredrops |
Ignore Drops |
ignoreinserts |
Ignore Inserts |
ignorereplicates |
Ignore Replicat Transactions |
ignoretruncates |
Ignore Truncates |
ignoreupdateafters |
Ignore Update After Images |
ignoreupdatebefores |
Ignore Update Before Images |
ignoreupdates |
Ignore Updates |
map.nohandlecollisions |
Do not Handle Collisions |
map.noinsertappend |
Do not Insert Append |
map.noinsertmissingupdates |
Do not Insert Missing Updates |
map.nomapinvisiblecolumns |
Do not Map Invisible Columns |
map.notrimspaces |
Do not Trim CHAR to VARCHAR Trailing Spaces |
map.notrimvarspaces |
Do not Trim VARCHAR to CHAR Trailing Spaces |
no_use_traildefs |
Do not Use Trail Definitions |
noallowduptargetmap |
Do not Allow Duplicate Target Map |
noallowlargefloat |
Do not Allow Large Float |
noallownoopupdates |
Do not Allow No-Operation Updates |
noapplynoopupdates |
Do not Apply No-Operation Updates |
noassumetargetdefs |
Do not Assume Target Definitions |
noauditreps |
Do not Audit Replicats |
nobinarychars |
Do not Use Binary Characters |
nocachenullablecols |
Do not Cache Nullable Columns |
nocharsetconversion |
Disable Character Set Conversion |
nochecksequencevalue |
Do not Check Sequence Values |
nocomplexnullcond |
No Complex Null Conditions |
nocompressdeletes |
No Compress Deletes |
nocompressupdates |
No Compress Updates |
nodeletelogrecs |
Do not Delete Log Records |
nodynamicresolution |
No Dynamic Resolution |
nodynsql |
No Dynamic SQL |
nofilterdups |
Do not Filter Duplicates |
nohandlecollisions |
Do not Handle Collisions |
noinsertappend |
No Insert Append |
noinsertdeletes |
Do not Insert Deletes |
noinsertmissingupdates |
Do not Convert Failed Updates To Inserts |
noinsertupdates |
Do not Insert Updates |
nolist |
Do not List Parameters in Report File |
nologallsupcols |
Do not Capture All Supplementally Logged Columns |
nomapinvisiblecolumns |
Do not Map Invisible Columns |
nooverridedups |
Do not Override Duplicates |
nopassthru |
Disable PassThru |
nopassthrumessages |
Disable PassThru Messages |
norestartcollisions |
Don't Restart Collisions |
nospacestonull |
Do not Convert Spaces to Null |
notcpsourcetimer |
Do Not Compensate For System Clock Differences |
notrimspaces |
Do not Trim CHAR to VARCHAR Spaces |
notrimvarspaces |
Do not Trim VARCHAR to CHAR Spaces |
noupdatedeletes |
Do not Convert Deletes To Updates |
noupdateinserts |
Do not Convert Inserts To Deletes |
nouseansisqlquotes |
Do not Use ANSI SQL Quotes |
nousededicatedcoordinationthread |
Do not Use Dedicated Coordination Thread |
novarwidthnchar |
Do not Treat NCHAR, NVARCHAR2, NCLOB As UTF-16 |
purgeoldextracts.no_use_checkpoints |
Do not Use Checkpoints |
reportcount.norate |
Do not Report Rate |
rmtfile.no_objectdefs |
No Object Definitions |
rmttrail.no_objectdefs |
No Object Definitions |
showsyntax.apply |
Apply |
statoptions.noreportdetail |
No Operation Statistics |
statoptions.noreportfetch |
Do not Fetch Statistics |
statoptions.noresetreportstats |
Do not Reset Report Statistics |
table.notrimspaces |
Do not Trim CHAR to VARCHAR Spaces |
table.notrimvarspaces |
Do not Trim VARCHAR to CHAR Spaces |
trail_seqlen_6d |
Trail Sequence Length 6 digits |
tranlogoptions._noarchivedlogonly |
Do not Read Only From Archived Logs |
tranlogoptions.ignoremetadatafromvam |
Ignore Metadata From VAM |
tranlogoptions.noapifilter |
No API Filter |
tranlogoptions.nocompletearchivedlogonly |
No Complete Archived Log |
tranlogoptions.nogetctasdml |
Do not Get CTAS DML |
tranlogoptions.nomanagesecondarytruncationpoint |
Manage Secondary Truncation Point |
tranlogoptions.nominefromactivedg |
Do not Mine From Active Data Guard |
tranlogoptions.nominefromsnapshotstby |
Do not Mine From Standby Snapshots |
tranlogoptions.noprepareforupgradetoie |
Do not Prepare For Upgrade To Integrated Extract |
tranlogoptions.nopurgeorphanedtransactions |
Do not Purge Orphaned Transactions |
tranlogoptions.nousenativeobjsupport |
Do not Use Native Object Support |
tranlogoptions.nouseprevresetlogsid |
Do not Use Previous Reset Log SID |
tranlogoptions.nouserexit |
No User Exit |
Other Oracle GoldenGate Parameters/Options
This section describes additional commands and parameter options for Oracle GoldenGate Studio.
Oracle GoldenGate Parameter/Option | Oracle GoldenGate Studio Label |
---|---|
a2e |
ASCII to EBCDIC |
accessrule |
Access Rule |
allocfiles |
Allocate Memory Structures |
allowduptargetmap |
Allow Duplicate Target Map |
allowinvisibleindexkeys |
Allow Invisible Index Keys |
allowlargefloat |
Allow Large Float |
allownonvalidatedkeys |
Allow Non-Validated Keys |
allownoopupdates |
Allow No-Operation Updates |
allowoutputdir |
Allow Output Directory |
applynoopupdates |
Apply No-Operation Updates |
asciimixedccsid |
ASCII Mixed CCSID |
asciitoebcdic |
ASCII to EBCDIC |
assumetargetdefs |
Assume Target Definitions |
assumetargetdefs.override |
Override Target Defs |
auditreps |
Audit Replicats |
autorestart |
Auto Restart |
autorestart.er |
Extract/Replicat |
autorestart.extract |
Extract |
autorestart.replicat |
Replicat |
autorestart.resetminutes |
Reset Time (mins) |
autorestart.retries |
Retries |
autorestart.waitminutes |
Wait Time (mins) |
autorestartinterval |
Auto Restart Interval |
autorestartmintime |
Auto Restart Minimum Time |
autostart |
AutoStart |
autostart.er |
Extract/Replicat |
autostart.extract |
Extract |
autostart.replicat |
Replicat |
batchsql |
BatchSQL |
batchsql.batcherrormode |
Batch Error Mode |
batchsql.batchesperqueue |
Batches Per Queue |
batchsql.batchtransops |
Operations Per Transaction |
batchsql.bypasspkcheck |
Bypass PK Check |
batchsql.bytesperqueue |
Bytes Per Queue |
batchsql.checkuniquekeys |
Check Unique Keys |
batchsql.errorhandling |
Error Handling |
batchsql.maxthreadqueuedepth |
Max Thread Queue Depth |
batchsql.numthreads |
Number of Threads |
batchsql.opsperbatch |
Operations Per Batch |
batchsql.opsperqueue |
Operations Per Queue |
batchsql.thread |
Thread |
batchsql.trace |
Trace |
begin |
Begin |
binarychars |
Binary Characters |
bootdelayminutes |
Boot Delay (min) |
bootdelayseconds |
Boot Delay (secs) |
br |
Bounded Recovery |
br.brdir |
Directory |
br.brfsoption |
FS Option |
br.brinterval |
Interval |
br.brkeepstalefiles |
Keep Stale Files |
br.broff |
Off |
br.broffonfailure |
Off On Failure |
bulkload |
Bulk Load |
bulkload.logging |
Log To Redo |
bulkload.noskipallindexes |
Enable Index Maintenance |
bulkload.parallel |
Enable Parallel Loading |
bulkload.skipallindexes |
Skips Index Maintenance |
bulkload.skipunusedindex |
Skip Unusable Indexes |
cachemgr |
Cache Manager |
cachemgr.cachebuffersize |
Cache Buffer Size |
cachemgr.cachedirectory |
Cache Directory |
cachemgr.cachefsoption |
Cache File Sync Option |
cachemgr.cachepageoutsize |
Cache Page Outsize |
cachemgr.cachesize |
Cache Size |
cachenullablecols |
Cache Nullable Columns |
catalogexclude |
Catalog Exclude |
catalogexclude.norename |
No Rename |
cdroptions |
CDR Options |
cdroptions.applymodcolonly |
Apply Modified Columns Only |
charmap |
Character Map Override |
charset |
Parameter File Character Set |
charsetconversion |
Enable Character Set Conversion |
checkminutes |
Maintenance Check Minutes |
checkparams |
Check Parameter Syntax |
checkpointsecs |
Checkpoint Seconds |
checkpointtable |
Checkpoint Table |
checksequencevalue |
Check Sequence Values |
cmdtrace |
Command Trace |
colmatch |
Column Match |
colmatch.names |
Names |
colmatch.prefix |
Prefix |
colmatch.reset |
Reset |
colmatch.suffix |
Suffix |
comment |
Comment |
complexnullcond |
Complex Null Condition |
compressdeletes |
Compress Deletes |
compressdeletes.fetchmissingcolumns |
Fetch Missing Columns |
compressupdates |
Compress Updates |
coordstatinterval |
Coordinate Statistic Interval |
coordtimer |
Coordinate Timer |
credentialstorelocation |
Credential Store Location |
cuserexit |
C User Exit |
cuserexit.includeupdatebefores |
Include Update Before Images |
cuserexit.params |
Params |
cuserexit.passthru |
PassThru |
dboptions |
Database Options |
dboptions.allowlobdatatruncate |
Allow LOB Truncation |
dboptions.allowunusedcolumn |
Allow Unused Columns |
dboptions.bindcharforbitaschar |
Encode CCSID Data |
dboptions.catalogconnect |
Use Separate Catalog Connection |
dboptions.catalogur |
Catalog Uncommit Read |
dboptions.connectionport |
Connection Port |
dboptions.decryptpassword |
Decrypt Password |
dboptions.decryptpassword.algorithm |
Algorithm |
dboptions.decryptpassword.aes128 |
AES128 |
dboptions.decryptpassword.aes192 |
AES192 |
dboptions.decryptpassword.aes256 |
AES256 |
dboptions.decryptpassword.blowfish |
Blowfish |
dboptions.decryptpassword.encryptkey |
Encryption Key |
dboptions.deferrefconst |
Defer Referential Integrity Constraint |
dboptions.disablecommitnowait |
Disable Asynchronous Commits |
dboptions.disablelobcaching |
Disable LOB Caching |
dboptions.emptylobstring |
Empty LOB String |
dboptions.enableinstantiationfiltering |
Enable InstantiationCSN Filtering |
dboptions.fetchbatchsize |
Fetch Batch Size |
dboptions.fetchcheckfreq |
Fetch Check Freq |
dboptions.fetchlobs |
Fetch LOBs |
dboptions.fetchretrycount |
Fetch Retry Count |
dboptions.fetchtimeout |
Fetch Timeout |
dboptions.host |
Host |
dboptions.integratedparams |
Integrated Parameters |
dboptions.integratedparams.ALLOW_DUPLICATE_ROWS |
Allow Duplicate Rows |
dboptions.integratedparams.APPLY_SEQUENCE_NEXTVAL |
Apply Sequence Next Value |
dboptions.integratedparams.BATCHSQL_MODE |
Batch SQL Mode |
dboptions.integratedparams.CDGRANULARITY |
Conflict Detection Granularity |
dboptions.integratedparams.COMMIT_SERIALIZATION |
Commit Serialization |
dboptions.integratedparams.COMPARE_KEY_ONLY |
Compare Key Only |
dboptions.integratedparams.COMPUTE_LCR_DEP_ON_ARRIVAL |
Compute LCR Dependency On Arrival |
dboptions.integratedparams.DISABLE_ON_ERROR |
Disable On Error |
dboptions.integratedparams.DISABLE_ON_LIMIT |
Disable On Limit |
dboptions.integratedparams.EAGER_SIZE |
Eager Size |
dboptions.integratedparams.ENABLE_XSTREAM_TABLE_STATS |
Enable Table Statistics |
dboptions.integratedparams.GROUPTRANSOPS |
Group Transaction Operations |
dboptions.integratedparams.HANDLECOLLISIONS |
Handle Collisions |
dboptions.integratedparams.IGNORE_TRANSACTION |
Ignore Transaction |
dboptions.integratedparams.MAXIMUM_SCN |
Max SCN |
dboptions.integratedparams.MAX_PARALLELISM |
Max Parallelism |
dboptions.integratedparams.MAX_SGA_SIZE |
Max SGA Size |
dboptions.integratedparams.MESSAGE_TRACKING_FREQUENCY |
Message Tracking Frequency |
dboptions.integratedparams.OPTIMIZE_PROGRESS_TABLE |
Optimize Progress Table |
dboptions.integratedparams.OPTIMIZE_SELF_UPDATES |
Optimize Self Updates |
dboptions.integratedparams.PARALLELISM |
Parallelism |
dboptions.integratedparams.PARALLELISM_INTERVAL |
Parallelism Interval |
dboptions.integratedparams.PRESERVE_ENCRYPTION |
Preserve Encryption |
dboptions.integratedparams.RTRIM_ON_IMPLICIT_CONVERSION |
RTRIM On Implicit Conversion |
dboptions.integratedparams.STARTUP_SECONDS |
Startup Seconds |
dboptions.integratedparams.SUPPRESSTRIGGERS |
Suppress Triggers |
dboptions.integratedparams.TIME_LIMIT |
Time Limit |
dboptions.integratedparams.TRACE_LEVEL |
Trace Level |
dboptions.integratedparams.TRANSACTION_LIMIT |
Transaction Limit |
dboptions.integratedparams.WRITE_ALERT_LOG |
Write Alert Log |
dboptions.legacylobreplication |
Legacy LOB Replication |
dboptions.limitrows |
Limit Rows |
dboptions.lobbufsize |
LOB Buffer Size |
dboptions.lobwritesize |
LOB Write Size |
dboptions.nofetchtimeout |
No Fetch Timeout |
dboptions.reparselobsql |
Reparse LOB SQL |
dboptions.sessionpoolincr |
Session Pool Increase |
dboptions.sessionpoolmax |
Session Pool Max |
dboptions.sessionpoolmin |
Session Pool Min |
dboptions.settag |
Set Tag |
dboptions.showinfomessages |
Show Info Messages |
dboptions.showwarnings |
Show Warnings |
dboptions.skiptemplob |
Skip Temp LOB |
dboptions.sourcedbname |
Source DB Name |
dboptions.sourcerootname |
Source CDB Root Name |
dboptions.spthread |
SP Thread |
dboptions.suppresstemporalupdates |
Edit Temporal Updates |
dboptions.suppresstriggers |
Suppress Triggers |
dboptions.tdspacketsize |
TDS Packet Size |
dboptions.trustedconnection |
Trusted Connection |
dboptions.useodbc |
Use ODBC |
dboptions.usereplicationuser |
Use Replication User |
dboptions.xmlbufsize |
XML Buffer Size |
ddl |
DDL Operations |
ddl.exclude |
Exclude |
ddl.exclude.all |
All |
ddl.exclude.allcatalogs |
All Catalogs |
ddl.exclude.allowemptyobject |
Allow Empty Object |
ddl.exclude.allowemptyowner |
Allow Empty Owner |
ddl.exclude.eventactions |
EventActions |
ddl.exclude.instr |
Instring |
ddl.exclude.instrcomments |
Instring Comments |
ddl.exclude.instrcommentswords |
Instring Comments Words |
ddl.exclude.instrwords |
Instring Words |
ddl.exclude.mapped |
Mapped |
ddl.exclude.objname |
Object Name |
ddl.exclude.objtype |
Object Type |
ddl.exclude.optype |
Operation Type |
ddl.exclude.other |
Other |
ddl.exclude.sourcecatalog |
Source Catalog |
ddl.exclude.staymetadata |
Stay Metadata |
ddl.exclude.unmapped |
Unmapped |
ddl.include |
Include |
ddl.include.all |
All |
ddl.include.allcatalogs |
All Catalogs |
ddl.include.allowemptyobject |
Allow Empty Object |
ddl.include.allowemptyowner |
Allow Empty Owner |
ddl.include.eventactions |
EventActions |
ddl.include.instr |
Instring |
ddl.include.instrcomments |
Instring Comments |
ddl.include.instrcommentswords |
Instring Comment Words |
ddl.include.instrwords |
Instring Words |
ddl.include.mapped |
Mapped |
ddl.include.objname |
Object Name |
ddl.include.objtype |
Object Type |
ddl.include.optype |
Operation Type |
ddl.include.other |
Other |
ddl.include.sourcecatalog |
Source Catalog |
ddl.include.staymetadata |
Stay Metadata |
ddl.include.unmapped |
Unmapped |
ddlerror |
DDL Error |
ddlerror.abendmissingobjects |
Abend on Missing Objects |
ddlerror.abendmissingtables |
Abend on Missing Tables |
ddlerror.error_code |
Error Code |
ddlerror.error_code.abend |
Abend |
ddlerror.error_code.discard |
Discard |
ddlerror.error_code.exclude |
Exclude |
ddlerror.error_code.exclude.all |
All |
ddlerror.error_code.exclude.allcatalogs |
All Catalogs |
ddlerror.error_code.exclude.allowemptyobject |
Allow Empty Object |
ddlerror.error_code.exclude.allowemptyowner |
Allow Empty Owner |
ddlerror.error_code.exclude.eventactions |
Event Actions |
ddlerror.error_code.exclude.instr |
Instring |
ddlerror.error_code.exclude.instrcomments |
Instring Comments |
ddlerror.error_code.exclude.instrcommentswords |
Instruction Comments Words |
ddlerror.error_code.exclude.instrwords |
Instruction Words |
ddlerror.error_code.exclude.mapped |
Mapped |
ddlerror.error_code.exclude.objname |
Object Name |
ddlerror.error_code.exclude.objtype |
Object Type |
ddlerror.error_code.exclude.optype |
Operation Type |
ddlerror.error_code.exclude.other |
Other |
ddlerror.error_code.exclude.sourcecatalog |
Source Catalog |
ddlerror.error_code.exclude.staymetadata |
Stay Metadata |
ddlerror.error_code.exclude.unmapped |
Unmapped |
ddlerror.error_code.ignore |
Ignore |
ddlerror.error_code.include |
Include |
ddlerror.error_code.include.all |
All |
ddlerror.error_code.include.allcatalogs |
All Catalogs |
ddlerror.error_code.include.allowemptyobject |
Allow Empty Object |
ddlerror.error_code.include.allowemptyowner |
Allow Empty Owner |
ddlerror.error_code.include.eventactions |
Event Actions |
ddlerror.error_code.include.instr |
Instring |
ddlerror.error_code.include.instrcomments |
Instring Comments |
ddlerror.error_code.include.instrcommentswords |
Instruction Comments Words |
ddlerror.error_code.include.instrwords |
Instruction Words |
ddlerror.error_code.include.mapped |
Mapped |
ddlerror.error_code.include.objname |
Object Name |
ddlerror.error_code.include.objtype |
Object Type |
ddlerror.error_code.include.optype |
Operation Type |
ddlerror.error_code.include.other |
Other |
ddlerror.error_code.include.sourcecatalog |
Source Catalog |
ddlerror.error_code.include.staymetadata |
Stay Metadata |
ddlerror.error_code.include.unmapped |
Unmapped |
ddlerror.error_code.retryop |
Retry Operation |
ddlerror.error_code.retryop.maxretries |
Max Retries |
ddlerror.error_code.retryop.retrydelay |
Retry Delay |
ddlerror.ignoremissingobjects |
Ignore Missing Objects |
ddlerror.ignoremissingtables |
Ignore Missing Tables |
ddlerror.norestartcollisions |
Do Not Restart With HandleCollisions |
ddlerror.restartcollisions |
Restart With HandleCollisions |
ddlerror.restartskip |
Restart And Skip |
ddlerror.skiptriggererror |
Skip Trigger Error |
ddloptions |
DDL Options |
ddloptions.NOADDTRANDATA |
No Add Trandata |
ddloptions.NOCAPTUREGLOBALTEMPTABLE |
No Capture Global Temp Table |
ddloptions.NOCROSSRENAME |
No Cross Rename |
ddloptions.USEPASSWORDVERIFIERLEVEL |
Use Password Verifier Level |
ddloptions.addtrandata |
Add Trandata |
ddloptions.addtrandata.abend |
Abend |
ddloptions.addtrandata.retryop |
Retry Operation |
ddloptions.addtrandata.retryop.maxretries |
Max Retries |
ddloptions.addtrandata.retryop.retrydelay |
Retry Delay |
ddloptions.captureglobaltemptable |
Capture Global Template |
ddloptions.defaultuserpassword |
Default User Password |
ddloptions.defaultuserpassword.aes128 |
AES128 |
ddloptions.defaultuserpassword.aes192 |
AES192 |
ddloptions.defaultuserpassword.aes256 |
AES256 |
ddloptions.defaultuserpassword.blowfish |
Blowfish |
ddloptions.defaultuserpassword.encryptkey |
Encrypt Key |
ddloptions.defaultuserpasswordalias |
Default User Password Alias |
ddloptions.defaultuserpasswordalias.domain |
Domain |
ddloptions.getapplops |
Get Application Operations |
ddloptions.getreplicates |
Get Replicat Transactions |
ddloptions.ignoremapping |
Ignore Mapping |
ddloptions.mapderived |
Map Derived |
ddloptions.mapschemas |
Map Schemas |
ddloptions.mapsessionschema |
Map Session Schema |
ddloptions.noremovecomments |
Don't Remove Comments |
ddloptions.notag |
No Tag |
ddloptions.password |
Password |
ddloptions.password.aes128 |
AES128 |
ddloptions.password.aes192 |
AES192 |
ddloptions.password.aes256 |
AES256 |
ddloptions.password.blowfish |
Blowfish |
ddloptions.password.encryptkey |
Encryption Key |
ddloptions.removecomments |
Remove Comments |
ddloptions.replicatepassword |
Replicate Password |
ddloptions.report |
Log DDL Operations To Report File |
ddloptions.target |
Target |
ddloptions.updatemetadata |
Update Metadata |
ddloptions.useownerforsession |
Use Owner for Session |
ddlrulehint |
DDL Rule Hint |
ddlsubst |
DDL Substitution |
ddlsubst.allcatalogs |
All Catalogs |
ddlsubst.allowemptyobject |
Allow Empty Object |
ddlsubst.allowemptyowner |
Allow Empty Owner |
ddlsubst.eventactions |
Event Actions |
ddlsubst.exclude |
Exclude |
ddlsubst.exclude.all |
All |
ddlsubst.exclude.mapped |
Mapped |
ddlsubst.exclude.other |
Other |
ddlsubst.exclude.unmapped |
Unmapped |
ddlsubst.include |
Include |
ddlsubst.include.all |
All |
ddlsubst.include.mapped |
Mapped |
ddlsubst.include.other |
Other |
ddlsubst.include.unmapped |
Unmapped |
ddlsubst.instr |
Apply to String |
ddlsubst.instrcomments |
Comments |
ddlsubst.instrcommentswords |
Comment Words |
ddlsubst.instrwords |
Apply to Instructions |
ddlsubst.objname |
Object Name |
ddlsubst.objtype |
DB Object Type |
ddlsubst.optype |
DDL Operation Type |
ddlsubst.sourcecatalog |
Source Catalog |
ddlsubst.staymetadata |
Stay meta data |
ddlsubst.with |
With |
ddltable |
DDL Table Name Override |
decrypttrail |
Decrypt Trail |
decrypttrail.algorithm |
Algorithm |
decrypttrail.aes128 |
AES128 |
decrypttrail.aes192 |
AES192 |
decrypttrail.aes256 |
AES256 |
decrypttrail.keyname |
Key Name |
deferapplyinterval |
Defer Apply Interval |
defsfile |
DEFGEN Definition File |
defsfile.append |
Append |
defsfile.charset |
Character Set |
defsfile.format |
Format Release |
defsfile.format.level |
Level |
defsfile.format.release |
Release |
defsfile.purge |
Purge |
deletelogrecs |
Delete Log Records |
discardfile |
Discard File |
discardfile.append |
Append |
discardfile.maxbytes |
Max Bytes |
discardfile.megabytes |
Megabytes |
discardfile.purge |
Purge |
discardrollover |
Discard Rollover |
discardrollover.at |
At |
discardrollover.on |
On |
downcritical |
Down Critical |
downinfo |
Down Info |
downreporthours |
Down Report Hours |
downreportminutes |
Down Report Minutes |
dsoptions |
Teradata Data Server Options |
dsoptions.checkopcomplete |
Check Op Complete |
dsoptions.checktrandata |
Check Trandata |
dsoptions.committedtranlog |
Committed Tranlog |
dsoptions.createtranlog |
Create Tranlog |
dsoptions.excludetrans |
Exclude Tranlog |
dsoptions.excludeuser |
Exclude User |
dsoptions.excludeuserid |
Exclude User ID |
dsoptions.ignoremetadatafromvam |
Ignore VAM Metadata |
dsoptions.restartappend |
Restart Append |
dsoptions.sorttranlog |
Sort Tranlog |
dsoptions.vamcompatibility |
VAM Compatibility |
dumpddlcolumns |
Dump DDL Columns |
dumpddlloggroups |
Dump DDL Log Groups |
dumpddlobjects |
Dump DDL Objects |
dumpddlpartitions |
Dump DDL Partitions |
dumpddlprimarykeys |
Dump DDL Primary Keys |
dynamicportlist |
Dynamic Port List |
dynamicportreassigndelay |
Dynamic Port Reassign Delay |
dynamicresolution |
Dynamic Resolution |
dynsql |
Dynamic SQL |
ebcdicmixedccsid |
EBCDIC Mixed CCSID |
ebcdictoascii |
EBCDIC to ASCII |
enablecatalognames |
Enable Catalog Names |
enableheartbeat |
Enable Heartbeat |
enablemonitoring |
Enable Monitoring |
enablemonitoring.bdb |
BDB (Berkeley DB) |
enablemonitoring.lmdb |
LMDB (Lightning DB) |
enablemonitoring.shmid |
SHMID (Shared Memory ID) |
enablenewmanager |
Enable New Manager |
encrypttrail.0 |
Encrypt Trail |
encrypttrail.1 |
Algorithm |
encrypttrail.keyname |
Key Name |
end |
End |
eofdelay |
EOF Delay (seconds) |
eofdelaycsecs |
EOF Delay (centiseconds) |
etoldformat |
ET Old Format |
excludetag |
Exclude Tag |
excludewildcardobjectsonly |
Exclude Wildcard Objects Only |
extfile |
Extract File |
extfile.format |
Format Release |
extfile.level |
Format Level |
extfile.maxfiles |
Max Files |
extfile.megabytes |
Megabytes |
extfile.objectdefs |
Object Definitions |
extfile.purge |
Purge |
extfile.release |
Release |
extfile.trailbyteorder |
Trail Byte Order |
extract |
Extract |
exttrail |
Trail |
exttrail.format |
Format Release |
exttrail.level |
Format Level |
exttrail.objectdefs |
Object Definitions |
exttrail.release |
Format Release |
exttrail.trailbyteorder |
Trail Byte Order |
fetchoptions |
Fetch Options |
fetchoptions.detaileddiagnostics |
Detailed Diagnostics |
fetchoptions.diagnosticsonall |
Diagnostics On All |
fetchoptions.fetchpkupdatecols |
Fetch PK Updates Columns |
fetchoptions.inconsistentrow |
Inconsistent Row |
fetchoptions.maxfetchstatements |
Max Fetch Statements |
fetchoptions.missingrow |
Missing Row |
fetchoptions.nofetch |
No Fetch |
fetchoptions.nosuppressduplicates |
No Suppress Duplicates |
fetchoptions.usediagnostics |
Use Diagnostics |
fetchoptions.usekey |
Use Key |
fetchoptions.uselatestversion |
Use Latest Version |
fetchoptions.userowid |
Use Row ID |
fetchoptions.usesnapshot |
Use Snapshot |
fetchuserid |
Fetch User ID |
fetchuserid.algorithm |
Algorithm |
fetchuserid.encryptkey |
Encrypt Key |
fetchuserid.password |
Password |
fetchuserid.sysdba |
Sysdba |
filterdups |
Filter Duplicates |
flushcsecs |
Flush Memory Buffer (csecs) |
flushsecs |
Flush (secs) |
formatascii |
Format ASCII |
formatascii.bcp |
MSSQL Bulk Load |
formatascii.charset |
Character Set |
formatascii.date |
Date Time Format |
formatascii.delimiter |
Delimiter |
formatascii.extracols |
Extra Columns |
formatascii.ind |
Include Before and After Ind |
formatascii.names |
Include Columns Names |
formatascii.nohdrfields |
Suppress Header Fields |
formatascii.noquote |
Exclude Quotes |
formatascii.nullisspace |
Convert Null to Blank |
formatascii.op |
Include Operation Type |
formatascii.placeholders |
Placeholders |
formatascii.sqlloader |
Oracle SQL Loader |
formatascii.time |
Time |
formatascii.ts |
Timestamp |
formatsql |
Write SQL Format File |
formatsql.nonames |
Omit Column Names |
formatsql.nopkupdates |
No PK Updates |
formatsql.oracle |
Oracle Date-Times |
formatxml |
Format XML |
formatxml.encoding |
Encoding |
formatxml.inlineproperties |
Write Properties Inline With XML Tab |
formatxml.trans |
Include Commit Markers |
functionstacksize |
Function Stack Size |
genloadfiles |
Generate Load Files |
genloadfiles.charset |
Character Set |
getalters |
Get Alters |
getapplops |
Get Application Operations |
getcreates |
Get Creates |
getdeletes |
Get Deletes |
getdrops |
Get Drops |
getenv |
Get Environment |
getinserts |
Get Inserts |
getreplicates |
Get Replicat Transactions |
gettruncates |
Get Truncates |
getupdateafters |
Get Update After Images |
getupdatebefores |
Get Updates Before Images |
getupdates |
Get Updates |
ggschema |
Schema Name |
grouptransops |
Group Transaction Operations |
handlecollisions |
Handle Collisions |
handlecollisions.thread |
Threads |
handletpkupdate |
Handle Transient Primary-Key Update |
haveudtwithnchar |
User Data Type Contains NCHAR |
heartbeat_table |
Heartbeat Table |
ignore_unrecognized |
Ignore Unrecognized |
include |
Include |
initializeheap |
Initialize Heap |
insertallrecords |
Insert All Records |
insertappend |
Insert Append |
insertdeletes |
Insert Deletes |
insertmissingupdates |
Convert failed updates to inserts |
insertupdates |
Insert Updates |
jvmadditionalopts |
JVM Additional Options |
jvmclasspath |
JVM Classpath |
jvmcompiler |
JVM Compiler |
jvmentryclass |
JVM Entry Class |
jvmentrymethod |
JVM Entry Method |
jvmentrymethodarguments |
JVM Entry Method Arguments |
jvmentrymethodsignature |
JVM Entry Method Signature |
jvmlibrarypath |
JVM Library Path |
lagcriticalhours |
Critical Hours Lag Threshold |
lagcriticalminutes |
Critical Minutes Lag Threshold |
lagcriticalseconds |
Critical Seconds Lag Threshold |
laginfohours |
Info Hours Lag Threshold |
laginfominutes |
Info Minutes Lag Threshold |
laginfoseconds |
Lag Info Seconds |
lagreporthours |
Report Hours Lag Threshold |
lagreportminutes |
Report Minutes Lag Threshold |
lfmmemory |
LFM (Long Field Memory) |
lfmmemory.directory |
Directory |
lfmmemory.inittransram |
Init Trans RAM |
lfmmemory.ram |
RAM |
lfmmemory.ramincrement |
RAM Increment |
lfmmemory.transallsources |
Trans All Sources |
lfmmemory.transram |
Trans RAM |
list |
List |
lobmemory |
LOB Memory |
lobmemory.directory |
Directory |
lobmemory.inittransram |
Init Trans RAM |
lobmemory.ram |
RAM |
lobmemory.ramincrement |
RAM Increment |
lobmemory.transallsources |
Trans All Sources |
lobmemory.transram |
Trans RAM |
logallsupcols |
Capture All Supplementally Logged Columns |
logfilesbehind |
Log Files Behind |
logfilesbehindinfo |
Log Files Behind Message |
macro |
Macro |
macro.begin |
Body |
macro.params |
Parameters |
macrochar |
Macro Character |
mapexclude |
Map Exclude |
mapexclude.norename |
No Rename |
mapinvisiblecolumns |
Map Invisible Columns |
mapinvisiblecolumns.thread |
Thread |
markertable |
Marker Table |
masterkeyname |
Master Key Name |
masterkeyname.version |
Version |
maxabendrestarts |
Max Abend Restarts |
maxdiscardrecs |
Max Discard Records |
maxetcheckptsecs |
Max Checkpoint Seconds |
maxfetchstatements |
Max Fetch Statements |
maxfieldlen |
Max Field Length |
maxgroups |
Max Process Groups |
maxsqlstatements |
Max SQL Statements |
maxtaclrestarts |
Max Tacl Restarts |
maxtransops |
Max Transaction Operations |
maxtraprestarts |
Max Trap Restarts |
mgrservname |
Manager Server Name |
monitoring_heartbeat_timeout |
Monitoring Heartbeat Timeout (secs) |
nameccsid |
DB Name CCSID |
namematchexact |
Exact Match |
namematchignorecase |
Ignore Case |
namematchnowarning |
No Name Match Warning |
noasciiformat |
No ASCII Format |
nocatalog |
Remove Catalog Name |
nodiscardfile |
Disallow Discard File |
nodupmsgsuppression |
Disallow Duplicate Message Suppression |
noencrypttrail |
Disallow Encrypt Trail |
nosqlformat |
No SQL Format |
nostats |
Disable Performance Statistics |
notracetable |
Disallow Trace Table |
nouserid |
No User ID |
nousethreads |
Disallow Use Threads |
numfiles |
Memory Structures Initial Number |
obey |
Obey |
outputfileumask |
Output File umask |
overridedups |
Override Duplicates |
param_parse_error |
Parameter Parsing Error |
param_parse_error.force |
Force |
passthru |
Enable PassThru |
passthrumessages |
Enable PassThru Messages |
port |
Port |
preservetargettimezone |
Preserve Target Timezone |
ptkcapturebatchsql |
Capture Batch SQL Statistics |
ptkcapturecachemgr |
Capture Cache Statistics |
ptkcaptureift |
Capture Inflight Transactions |
ptkcapturenetwork |
Capture Network Statistics |
ptkcaptureprocstats |
Enable Process/Thread Statistics |
ptkcapturequeuestats |
Capture Queue Statistics |
ptkcapturetablestats |
Capture Table Statistics |
ptkirstatsfrequency |
Statistics Frequency |
ptkmaxtables |
Max Tables for Statistics |
ptkmonitorfrequency |
Monitoring Collection Frequency (sec) |
ptkspstats |
Capture Superpool Statistics |
ptktablepollfrequency |
Poll Interval for Table Statistics |
purgeddlhistory |
Purge DDL_HISTORY |
purgeddlhistory.frequencyhours |
Frequency Hours |
purgeddlhistory.frequencyminutes |
Frequency Minutes |
purgeddlhistory.maxkeepdays |
Max Keep Days |
purgeddlhistory.maxkeephours |
Max Keep Hours |
purgeddlhistory.minkeepdays |
Minimum Keep Days |
purgeddlhistory.minkeephours |
Minimum Keep Hours |
purgeddlhistoryalt |
Purge DDL_HISTORY_ALT |
purgeddlhistoryalt.frequencyhours |
Frequency Hours |
purgeddlhistoryalt.frequencyminutes |
Frequency Minutes |
purgeddlhistoryalt.maxkeepdays |
Max Keep Days |
purgeddlhistoryalt.maxkeephours |
Max Keep Hours |
purgeddlhistoryalt.minkeepdays |
Minimum Keep Days |
purgeddlhistoryalt.minkeephours |
Minimum Keep Hours |
purgemarkerhistory |
Purge MARKER_HISTORY table |
purgemarkerhistory.frequencyhours |
Frequency Hours |
purgemarkerhistory.frequencyminutes |
Frequency Minutes |
purgemarkerhistory.maxkeepdays |
Max Keep Days |
purgemarkerhistory.maxkeephours |
Max Keep Hours |
purgemarkerhistory.minkeepdays |
Minimum Keep Days |
purgemarkerhistory.minkeephours |
Minimum Keep Hours |
purgeoldextracts |
Purge Old Extracts |
purgeoldextracts.frequencyhours |
Frequency Hours |
purgeoldextracts.frequencyminutes |
Frequency Minutes |
purgeoldextracts.maxkeepdays |
Max Keep Days |
purgeoldextracts.maxkeepfiles |
Max Keep Files |
purgeoldextracts.maxkeephours |
Max Keep Hours |
purgeoldextracts.minkeepdays |
Minimum Keep Days |
purgeoldextracts.minkeepfiles |
Minimum Keep Files |
purgeoldextracts.minkeephours |
Minimum Keep Hours |
purgeoldextracts.usecheckpoints |
Use Checkpoints |
purgeoldhistory |
Purge Old History |
purgeoldhistory.maxkeepdays |
Max Keep Days |
purgeoldhistory.maxkeephours |
Max Keep Hours |
purgeoldhistory.minkeepdays |
Minimum Keep Days |
purgeoldhistory.minkeephours |
Minimum Keep Hours |
purgeoldtasks |
Purge Old Tasks |
purgeoldtasks.after |
After |
purgeoldtasks.er |
Extract/Replicat |
purgeoldtasks.extract |
Extract |
purgeoldtasks.replicat |
Replicat |
purgeoldtasks.usestopstatus |
Use Top Status |
randomrollbacks |
Random Rollbacks |
recoveryoptions |
Recovery Options |
recoveryoptions.appendmode |
Append Mode |
recoveryoptions.overwritemode |
Overwrite Mode |
reperror |
Replicat Error |
reperror.reset |
Reset |
repfetchedcoloptions |
Replicat Fetched Column Options |
repfetchedcoloptions.inconsistentrow |
Inconsistent Row |
repfetchedcoloptions.latestrowversion |
Latest Row Version |
repfetchedcoloptions.missingrow |
Missing Row |
repfetchedcoloptions.nofetch |
Prevent Fetch |
repfetchedcoloptions.redundantrow |
Redundant Row |
repfetchedcoloptions.setifmissing |
Set If Missing |
repfetchedcoloptions.snapshotrow |
Snapshot Row |
replacebadchar |
Replaces Invalid Character |
replacebadchar.abort |
Abort |
replacebadchar.enablefallback |
Enable Fallback |
replacebadchar.escape |
Escape |
replacebadchar.forcecheck |
Force Check |
replacebadchar.nowarning |
No Warning |
replacebadchar.null |
Null |
replacebadchar.skip |
Skip |
replacebadchar.space |
Space |
replacebadchar.substitute |
Substitute |
replacebadchar.unprintable |
Unprintable |
replacebadnum |
Replace Invalid Numbers |
replicat |
Replicat |
repobackupdir |
Repository Backup Directory |
repobackupfrequency |
Repository Backup Frequency |
reponumbackupsbeforefullbackup |
Repository Backups Before Full Backup |
report |
Report |
report.AT |
At |
report.ON |
On |
reportcount |
Transaction Record Report Count |
reportcount.every |
Every |
reportcount.rate |
Report Rate |
reportformatnoremote |
Report Format No Remote |
reportrollover |
Report Rollover |
reportrollover.AT |
At |
reportrollover.ON |
On |
restartcollisions |
Restart Collisions |
restartinterval |
Restart Interval |
retrydelay |
Retry Delay |
rmtfile |
Remote File |
rmtfile.append |
Append |
rmtfile.format |
Format Release |
rmtfile.level |
Format Level |
rmtfile.maxfiles |
Max Files |
rmtfile.megabytes |
Megabytes |
rmtfile.objectdefs |
Object Definitions |
rmtfile.purge |
Purge |
rmtfile.release |
Format Release |
rmtfile.trailbyteorder |
Trail Byte Order |
rmthost |
Remote Host |
rmthost.compress |
Compress |
rmthost.compressthreshold |
Compress Threshold |
rmthost.cpu |
CPU |
rmthost.encrypt |
Encrypt |
rmthost.hometerm |
Device |
rmthost.keyname |
Key Name |
rmthost.mgrport |
Manager Port |
rmthost.nostreaming |
No Streaming |
rmthost.params |
Parameters |
rmthost.password |
Password |
rmthost.port |
Collector Port |
rmthost.pri |
Priority |
rmthost.processname |
Process Name |
rmthost.socksproxy |
Socks Proxy |
rmthost.socksproxy.proxycsalias |
Proxy Credential Store Alias |
rmthost.socksproxy.proxycsdomain |
Proxy Credential Store Domain |
rmthost.streaming |
Streaming |
rmthost.tcpbufsize |
TCP Buffer Size |
rmthost.tcpflushbytes |
TCP Flush Bytes |
rmthost.timeout |
Timeout |
rmthost.user |
User ID |
rmthostoptions |
Remote Host Options |
rmthostoptions.compress |
Compress |
rmthostoptions.compressthreshold |
Compress Threshold |
rmthostoptions.encrypt |
Encrypt |
rmthostoptions.keyname |
Key Name |
rmthostoptions.nostreaming |
No Streaming |
rmthostoptions.params |
Parameters |
rmthostoptions.streaming |
Streaming |
rmthostoptions.tcpbufsize |
TCP Buffer Size |
rmthostoptions.tcpflushbytes |
TCP Flush Bytes |
rmthostoptions.timeout |
Timeout |
rmttask |
Remote Task |
rmttask.format |
Format Release |
rmttask.group |
Group |
rmttask.level |
Format Level |
rmttask.params |
Parameters |
rmttask.release |
Format Release |
rmttrail |
Remote Trail |
rmttrail.format |
Format Release |
rmttrail.level |
Format Level |
rmttrail.objectdefs |
Object Definitions |
rmttrail.release |
Format Release |
rmttrail.trailbyteorder |
Trail Byte Order |
rollover |
Rollover |
rollover.at |
At |
rollover.on |
On |
rollover.report |
Report |
schemaexclude |
Exclude Replicat Schema |
schemaexclude.norename |
No Rename |
sequence |
Sequence |
sessioncharset |
Session Character Set |
setenv |
Set Environment |
showsyntax |
Show SQL Syntax |
showsyntax.all |
All |
showsyntax.includelob |
Include LOB |
showsyntax.noapply |
No Apply |
sourcecatalog |
Source Catalog |
sourcecharset |
Source Character Set |
sourcecharset.character_set_name |
Character Set Name |
sourcecharset.db2zos |
DB2 On z/OS |
sourcecharset.override |
Override |
sourcecharset.passthru |
PassThru |
sourcedb |
Source DB |
sourcedb.credentialgroup |
Credential Group |
sourcedb.domain |
Domain |
sourcedb.encryptkey |
Encrypt Key |
sourcedb.password |
Password |
sourcedb.password.aes128 |
AES128 |
sourcedb.password.aes192 |
AES192 |
sourcedb.password.aes256 |
AES256 |
sourcedb.password.blowfish |
Blowfish |
sourcedb.sessioncharset |
Session Character Set |
sourcedb.sqlid |
|
sourcedb.sysdba |
Sysdba |
sourcedb.thread |
Threads |
sourcedb.userid |
User ID |
sourcedb.useridalias |
User Alias |
sourcedefs |
Source Definitions |
sourcedefs.override |
Override |
sourceisfile |
Source Is File |
sourceistable |
Source Is Table |
sourcetimezone |
Source Timezone |
spacestonull |
Convert Spaces to Null |
specialrun |
Special Run |
sqlduperr |
SQL Duplicate Error |
sqlexec |
SQL Execution |
sqlexec.every |
Every |
sqlexec.onexit |
On Exit |
sqlexec.thread |
Thread |
startupvalidationdelay |
Startup Validation Delay (secs) |
startupvalidationdelaycsecs |
Startup Validation Delay (csecs) |
statoptions |
Statistic Options |
statoptions.reportcharconv |
Report Character Conversion |
statoptions.reportdetail |
Operation Statistics |
statoptions.reportfetch |
Fetch Statistics |
statoptions.resetreportstats |
Reset Report Statistics |
statoptions.thread |
Thread |
syslog |
Sys Log |
syslog.all |
All |
syslog.error |
Error |
syslog.info |
Info |
syslog.none |
None |
syslog.warn |
Warning |
tableexclude |
Exclude Table |
tableexclude.norename |
No Rename |
targetdb |
Target DB |
targetdb.domain |
Domain |
targetdb.dsn |
DSN |
targetdb.encryptkey |
Encrypt Key |
targetdb.libfile |
Library File |
targetdb.password |
Password |
targetdb.password.aes128 |
AES128 |
targetdb.password.aes192 |
AES192 |
targetdb.password.aes256 |
AES256 |
targetdb.password.blowfish |
Blowfish |
targetdb.sessioncharset |
Session Character Set |
targetdb.set |
Set |
targetdb.sqlid |
SQL ID |
targetdb.sysdba |
Sysdba |
targetdb.thread |
Threads |
targetdb.userid |
User ID |
targetdb.useridalias |
User Alias |
targetdefs |
Target Definitions |
targetdefs.override |
Override |
tcpsourcetimer |
Compensate For System Clock Differences |
threadoptions |
Thread Options |
threadoptions.eofdelaycsecs |
EOF Delay Centiseconds |
threadoptions.eofdelayms |
EOF Delay (ms) |
threadoptions.except |
Except |
threadoptions.inqueuesize |
Input Queue Size |
threadoptions.outqueuesize |
Output Queue Size |
threadoptions.processthreads |
Process Threads |
threadoptions.select |
Select |
threadoptions.stacksize |
Stack Size |
tltrace |
Transaction Log Trace |
tltrace.data |
Use Raw Format |
tltrace.ddl |
DDL |
tltrace.debug |
Debug |
tltrace.file |
File |
tltrace.level |
Level |
tltrace.pause |
Pause |
trace |
Trace |
trace2 |
Trace2 |
traceapi |
Trace API |
tracetable.0 |
Trace Table |
tracetable.1 |
Name |
trail_seqlen_9d |
Trail Sequence Length 9 digits |
trailbyteorder |
Trail Byte Order |
trailcharset |
Trail Character Set |
trailcharset.replacebadchar |
Replace Bad Character |
trailcharsetascii |
Trail Character Set ASCII |
trailcharsetebcdic |
Trail Character Set EBCDIC |
trailcharsetunicode |
Unicode Trail Character Set |
tranlogoptions |
Transaction Log Options |
tranlogoptions.USE_ROOT_CONTAINER_TIMEZONE |
Use Root Container Timezone |
tranlogoptions._allowtablecompression |
Allow Table Compression |
tranlogoptions.activationidpadlen |
Activation ID Pad Length |
tranlogoptions.activesecondarytruncationpoint |
Active Secondary Truncation |
tranlogoptions.adgapplycheckfreq |
ADG Apply Check Frequency |
tranlogoptions.adgretrycount |
ADG Retry Count |
tranlogoptions.adgtimeout |
ADG Timeout |
tranlogoptions.allowdataloss |
Allow Data Loss |
tranlogoptions.allowtablecompression |
Allow Table Compression |
tranlogoptions.altarchivedlogformat |
Alt Archive Log Format |
tranlogoptions.altarchivelogdest |
Alt Archive Log Destination |
tranlogoptions.altlogdest |
Alt Log Destination |
tranlogoptions.altonlinelogs |
Alt Online Logs |
tranlogoptions.apifilter |
API Filter |
tranlogoptions.archivedlogonly |
Archived Log Only |
tranlogoptions.archiverestoreexecutable |
Archive Restore Executable |
tranlogoptions.archiverestoreparams |
Archive Restore Parameters |
tranlogoptions.asmbufsize |
ASM Buffer Size |
tranlogoptions.asmuser |
ASM User |
tranlogoptions.asmuser.aes128 |
AES128 |
tranlogoptions.asmuser.aes192 |
AES192 |
tranlogoptions.asmuser.aes256 |
AES256 |
tranlogoptions.asmuser.asmpassword |
ASM Password |
tranlogoptions.asmuser.blowfish |
Blowfish |
tranlogoptions.asmuser.encryptkey |
Encrypt Key |
tranlogoptions.asmuser.sysdba |
Sysdba |
tranlogoptions.asmuseralias |
ASM User Alias |
tranlogoptions.asmuseralias.domain |
Domain |
tranlogoptions.asynctransprocessing |
Async Transaction Processing |
tranlogoptions.bufsize |
Buffer Size |
tranlogoptions.checkpointretentiontime |
Checkpoint Retention |
tranlogoptions.checkpointtable |
Checkpoint Table |
tranlogoptions.checkposition |
Check Position |
tranlogoptions.checktablelevelsupplog |
Checktable Level Suppl Log |
tranlogoptions.completearchivedlogonly |
Complete Archived Log |
tranlogoptions.completearchivedlogtimeout |
Complete Archived Log Timeout |
tranlogoptions.convertucs2clobs |
Convert UCS to CLOBS |
tranlogoptions.createtranlog |
Create Transaction Log |
tranlogoptions.databaseidpadlen |
Database ID Pad Len |
tranlogoptions.dblogreader |
DB Log Reader |
tranlogoptions.dblogreaderbufsize |
DB Log Reader Buffer Size |
tranlogoptions.excludetag |
Exclude Tag |
tranlogoptions.excludetrans |
Exclude Transaction |
tranlogoptions.excludeuser |
Exclude User |
tranlogoptions.excludeuserid |
Exclude User ID |
tranlogoptions.failovertargetdestid |
Failover Target Destination ID |
tranlogoptions.fetchinlinesflob |
Fetch Inline FS Lob |
tranlogoptions.fetchlobonerror |
Fetch LOB On Error |
tranlogoptions.fetchpartiallob |
Fetch Partial LOB |
tranlogoptions.fetchpartialxml |
Fetch Partial XML |
tranlogoptions.fetchxmlonerror |
Fetch XML On Error |
tranlogoptions.filtertable |
Filter Table |
tranlogoptions.flush |
Flush |
tranlogoptions.forcefetchlob |
Force Fetch LOB |
tranlogoptions.getctasdml |
Get CTAS DML |
tranlogoptions.getmetadatafromvam |
Get Metadata From VAM |
tranlogoptions.handledlfailover |
Handled Failover |
tranlogoptions.iflockseconds |
If Lock (secs) |
tranlogoptions.ignoredatacapturechanges |
Ignore Data Capture Changes |
tranlogoptions.ignoredirectloadinserts |
Ignore Direct Load Inserts |
tranlogoptions.ignoregap |
Ignore Gap |
tranlogoptions.ignorekeyerror |
Ignore Key Error |
tranlogoptions.includeaux |
Include AUX |
tranlogoptions.includeregionid |
Include Region ID |
tranlogoptions.includeregionidwithoffset |
Include Region ID With Offset |
tranlogoptions.integratedparams |
Integrated Parameters |
tranlogoptions.legacylobreading |
Legacy LOB Reading |
tranlogoptions.logretention |
Log Retention |
tranlogoptions.logretention.days |
Days |
tranlogoptions.logsource |
Log Source |
tranlogoptions.logswitchmsg |
Log Switch Message |
tranlogoptions.managesecondarytruncationpoint |
Manage Secondary Truncation Point |
tranlogoptions.maxparallelrec |
Max Parallel Records |
tranlogoptions.maxreadsize |
Max Read Size |
tranlogoptions.maxwarneof |
Max Warn EOF |
tranlogoptions.minefromactivedg |
Mine From Active DG |
tranlogoptions.minefromsnapshotstby |
Mine From Snapshots |
tranlogoptions.mininguser |
Mining User |
tranlogoptions.mininguser.algorithm |
Algorithm |
tranlogoptions.mininguser.aes128 |
AES128 |
tranlogoptions.mininguser.aes192 |
AES192 |
tranlogoptions.mininguser.aes256 |
AES256 |
tranlogoptions.mininguser.blowfish |
Blowfish |
tranlogoptions.mininguser.encryptkey |
Encrypt Key |
tranlogoptions.mininguser.miningpassword |
Mining Password |
tranlogoptions.mininguser.sysdba |
Sysdba |
tranlogoptions.mininguseralias |
Mining User Alias |
tranlogoptions.mininguseralias.domain |
Domain |
tranlogoptions.noadgtimeout |
No ADG Timeout |
tranlogoptions.noasynctransprocessing |
No Async Transaction Processing |
tranlogoptions.noddlchangewarning |
No DDL Change Warning |
tranlogoptions.noflush |
No Flush |
tranlogoptions.noignoredatacapturechanges |
Do Not Ignore Data Capture |
tranlogoptions.norequirelongdatacapturechanges |
Do Not Require Long Data Capture |
tranlogoptions.onephase |
One Phase |
tranlogoptions.pathmap |
Path Map |
tranlogoptions.pollinterval |
Poll Interval |
tranlogoptions.prepareforupgradetoie |
Prepare For Upgrade To IE |
tranlogoptions.purgeorphanedtransactions |
Purge Orphaned Transactions |
tranlogoptions.queryretrycount |
Query Retry Count |
tranlogoptions.readqueuesize |
Read Queue Size |
tranlogoptions.requirelongdatacapturechanges |
Require Long Data Capture |
tranlogoptions.resetlogsidpadlen |
Reset Logs ID Pad Length |
tranlogoptions.restartappend |
Restart Append |
tranlogoptions.seqpadlen |
Sequence Pad Length |
tranlogoptions.server |
Server |
tranlogoptions.skipdirloadinsert |
Skip DIR Load Insert |
tranlogoptions.startatactivelsn |
Start At Active LSN |
tranlogoptions.threadpadlen |
Thread Pad Length |
tranlogoptions.transcleanupfrequency |
Trans Cleanup Frequency (min) |
tranlogoptions.truncpointoff |
Truncation Point Off |
tranlogoptions.tslookupbeginlri |
Timestamp Lookup Start |
tranlogoptions.tslookupendlri |
Timestamp Lookup Stop |
tranlogoptions.unprivileged |
Unprivileged |
tranlogoptions.usenativeobjsupport |
Use Native Object Support |
tranlogoptions.useocithreads |
Use OCI Threads |
tranlogoptions.useprevresetlogsid |
Use Previous Reset Log SID |
tranlogoptions.userexit |
User Exit |
tranlogoptions.validateinlinesflob |
Validate Inline FS Lob |
tranlogoptions.vamcompatibility |
VAM Compatibility |
transactiontimeout |
Transaction Timeout |
transmemory |
Transaction Memory |
transmemory.directory |
Directory |
transmemory.inittransram |
Initial Trans RAM |
transmemory.ram |
RAM |
transmemory.ramincrement |
RAM Increment |
transmemory.transallsources |
Trans All Sources |
transmemory.transram |
Trans RAM |
trimspaces |
Trim CHAR to VARCHAR Spaces |
trimvarspaces |
Trim VARCHAR to CHAR Spaces |
unlockedtrailfiles |
Unlocked Trail Files |
updatedeletes |
Update Deletes |
updateinserts |
Update Inserts |
updaterecordformat |
Update Record Format |
upreporthours |
Up Report Hours |
upreportminutes |
Up Report Minutes |
use_traildefs |
Use Trail Definitions |
usededicatedcoordinationthread |
Use Dedicated Coordination Thread |
useipv4 |
IPV4 |
useipv6 |
IPV6 |
userid |
Userid |
userid.password |
Password |
userid.password.algorithm |
Algorithm |
userid.password.aes128 |
AES128 |
userid.password.aes192 |
AES192 |
userid.password.aes256 |
AES256 |
userid.password.blowfish |
Blowfish |
userid.password.encryptkey |
Encrypt Key |
userid.sysdba |
Sysdba |
userid.thread |
Threads |
useridalias |
User Alias |
useridalias.domain |
Domain |
useridalias.sysdba |
Sysdba |
useridalias.thread |
Threads |
usethreads |
Use Threads |
usetimeprefix |
Use Time Prefix |
usetimestampprefix |
Use Timestamp Prefix |
vam |
Vendor Access Module |
vam.params |
Parameters |
varwidthnchar |
Treat NCHAR, NVARCHAR2, NCLOB As UTF-16 |
veridatareportage |
Veridata Report Age |
walletlocation |
Wallet Location |
warnlongtrans |
Warn Long Transaction |
warnlongtrans.checkinterval |
Check Interval |
warnlongtrans.nousethreads |
No Use Threads |
warnlongtrans.uselastreadtime |
Use Last Read Time |
warnrate |
Warn Rate |
wildcardresolve |
Resolve Wildcard |
wildcardresolve.both |
Intermediate and Dynamic Resolve |
wildcardresolve.dynamic |
Dynamic Resolve |
wildcardresolve.ignoremissing |
Ignore Missing |
wildcardresolve.immediate |
Immediate Resolve |
xagenable |
XAG Integration |