B Oracle GoldenGate Commands and Parameters that you can use with the Properties Inspector

Learn about the correlation between the Oracle GoldenGate commands and parameters that are run when you select the various options in 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

B.1 Commands with Options

The Oracle GoldenGate commands with the specified options are listed in the following sections.

B.1.1 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

B.1.2 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

B.1.3 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

B.1.4 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

B.1.5 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

B.1.6 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

B.1.7 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

B.1.8 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

B.2 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.

B.3 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

B.4 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

B.5 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