Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Related Information
  • Conventions
• GGSCI Commands
  • Manager commands
    • INFO MANAGER
    • SEND MANAGER
    • START MANAGER
    • STATUS MANAGER
    • STOP MANAGER
  • Extract commands
    • ADD EXTRACT
    • ALTER EXTRACT
    • CLEANUP EXTRACT
    • DELETE EXTRACT
    • INFO EXTRACT
    • KILL EXTRACT
    • LAG EXTRACT
    • SEND EXTRACT
    • START EXTRACT
    • STATUS EXTRACT
    • STOP EXTRACT
  • Replicat commands
    • ADD REPLICAT
    • ALTER REPLICAT
    • CLEANUP REPLICAT
    • DELETE REPLICAT
    • INFO REPLICAT
    • KILL REPLICAT
    • LAG REPLICAT
    • SEND REPLICAT
    • START REPLICAT
    • STATUS REPLICAT
    • STOP REPLICAT
  • ER Commands
    • SEND ER* STATS
  • Logger Commands
    • ADD LOGGER
    • ALTER LOGGER
    • DELETE LOGGER
    • INFO LOGGER
    • SEND LOGGER
    • START LOGGER
    • STATUS LOGGER
    • STOP LOGGER
  • Trail commands
    • ADD EXTTRAIL
    • ADD RMTTRAIL
    • ALTER EXTTRAIL
    • ALTER RMTTRAIL
    • DELETE EXTTRAIL
    • DELETE RMTTRAIL
    • INFO EXTTRAIL
    • INFO RMTTRAIL
  • Database commands
    • CAPTURE TABLEDEFS
    • ENCRYPT PASSWORD
    • INFO DDLDEFS
    • INFO FILES
  • Audit trail commands
    • STATUS AUDITTRAIL
  • Remote checkpoint commands
    • ADD REMOTECHKPT
    • DELETE REMOTECHKPT
    • INFO REMOTECHKPT
  • TMF commands
    • REFRESHTMFINFO
    • TMFDUMPAGE
    • TMFDUMPINFO
    • TMFDUMPTABLEENTRIES
    • TMFREFRESHINTERVAL
    • TMFTRAILINFO
  • Coordinator commands
    • ADD COORDINATOR
    • ALTER COORDINATOR
    • DELETE COORDINATOR
    • INFO COORDINATOR
    • SEND COORDINATOR
    • START COORDINATOR
    • STATUS COORDINATOR
    • STOP COORDINATOR
  • Process commands
    • SEND PROCESS
  • Marker commands
    • ADD MARKER
    • INFO MARKER
  • Programs commands
    • BIND PROGRAMS
    • INFO PROGRAMS
    • LINK PROGRAMS
  • Report commands
    • SEND REPORT
    • VIEW REPORT
  • Syncfile commands
    • ADD SYNCFILE
    • ALTER SYNCFILE
    • DELETE SYNCFILE
    • INFO SYNCFILE
    • KILL SYNCFILE
    • START SYNCFILE
    • STATUS SYNCFILE
    • STOP SYNCFILE
  • Miscellaneous commands
    • CLEANUP NETWORKCHECKPOINTS
    • ! command
    • ENV
    • FC
    • GETMGRVERSION
    • HELP
    • HISTORY
    • INFO ALL
    • LOG
    • LOG STOP
    • OBEY
    • EDIT PARAMS
    • VIEW PARAMS
    • SYSTEM
    • VIEW GGSEVT
• Oracle GoldenGate Parameters
  • Parameter Summaries
    • GLOBALS Parameters Summary
    • Manager Parameters Summary
    • Logger Parameters Summary
    • CHGNOTE Parameters Summary
    • Extract Parameters Summary
    • Replicat Parameters Summary
    • Coordinator Parameters Summary
    • Syncfile Parameters Summary
  • ABORTDUPERRWINDOW
  • ADD DEFINE
  • ALLOCFILES
  • ALTFILERESOLVE | NOALTFILERESOLVE
  • ALTINPUT
  • ASSUMETARGETDEFS
  • AUDITING
  • AUDITREPS | NOAUDITREPS
  • AUDITRETRYDELAY
  • AUDSERVCACHEBLOCKS
  • AUDSERVCPU
  • AUDSERVPARAM
  • AUDSERVPREFIX
  • AUDSERVPROCESS
  • AUTORESTART
  • AUTOSTART
  • BACKUPCPU
  • BEGIN
  • BULKIOLOAD | NOBULKIOLOAD
  • CHECKINTERVAL
  • CHECKMINUTES
  • CHECKPARAMS
  • CHECKPOINTSECS
  • CHECKTHRESHOLDMIN
  • CHECKUNIQUEKEY | NOCHECKUIQUEKEY
  • CLEANUPSAVECOUNT
  • COBOLUSEREXIT
  • COLMATCH
  • COMMENT
  • COMPRESSDELETES | NOCOMPRESSDELETES
  • CONTROLTABLELOCKOFF
  • CONVERTALLFLOATSTOIEEE | NOCONVERTALLFLOATSTOIEEE
  • CONVERTALLFLOATSTOTDM | NOCONVERTALLFLOATSTOTDM
  • COORDINATOR
  • CPU
  • CUSEREXIT
  • DEBUGONSTACKCHECK
  • DISCARDROLLOVER
  • DECRYPTTRAIL
  • DEFERAPPLYINTERVAL
  • DICTIONARY
  • DISCARDFILE
  • DISKTHRESHOLD | NODISKTHRESHOLD
  • DISPLAYFILEREFRESHES
  • DISPLAYTRAILSWITCH | NODISPLAYTRAILSWITCH
  • DOWNCRITICAL
  • DOWNINFO
  • DOWNREPORT
  • DUP
  • DUPONLYAFTEREVENT
  • DUPPROCESS
  • DYNAMICPORTLIST
  • DYNAMICPORTREASSIGNDELAY
  • EMBEDDEDMACROS | NOEMBEDDEDMACROS
  • EMSLOG
  • ENCRYPTTRAIL | NOENCRYPTTRAIL
  • END
  • ENTRYSEQUPDATES
  • EOFDELAY | EOFDELAYCSECS
  • ERREPLYTIMEOUT
  • ERROR59ROLLOVER
  • ETNEWFORMAT
  • EVENT
  • EXCLUDEFILE
  • EXCLUDEGGSTRANSRECS | INCLUDEGGSTRANSRECS
  • EXCLUDESUFFIXCHAR
  • EXPANDDDL
  • EXTFILE
  • EXTRACT
  • EXTTRAIL
  • FASTIO
  • FASTPOSITION | NOFASTPOSITION
  • FASTREADS | NOFASTREADS
  • FETCHCOMPS | FETCHLASTIMAGE
  • FILE
  • FILEAGEDAYS
  • FILEAGESCANDAYS
  • FILEEXCLUDE
  • FILEOPWARNING
  • FILERESOLVE
  • FILE | TABLE
  • FILLSHORTRECS | NOFILLSHORTRECS
  • FILTERVIEW | NOFILTERVIEW
  • FLUSHCHECKPOINT | NOFLUSHCHECKPOINT
  • FLUSHSECS | FLUSHCSECS
  • FORCESTOPDELAY
  • FORCEUSESYSKEY | NOFORCEUSESYSKEY
  • FORMATASCII | NOFORMATASCII
  • FORMATLOCAL
  • FORMATSQL | NOFORMATSQL
  • FORMATXML
  • FUNCTIONSTACKSIZE
  • GETALTKEYS | IGNOREALTKEYS
  • GETAPPLOPS | IGNOREAPPLOPS
  • GETAUXTRAILS | IGNOREAUXTRAILS
  • GETCOMPS | IGNORECOMPS
  • GETCREATES | IGNORECREATES
  • GETDEFAULTS
  • GETDELETES | IGNOREDELETES
  • GETENV
  • GETFILEOPS | IGNOREFILEOPS
  • GETINSERTS | IGNOREINSERTS
  • GETMARKERS | IGNOREMARKERS
  • GETNETCHANGES | IGNORENETCHANGES
  • GETNETWORKALTFILENAMES | IGNORENETWORKALTFILENAMES
  • GETNEWCOLUMNS | IGNORENEWCOLUMNS
  • GETPARTONLYPURGEDATAS | IGNOREPARTONLYPURGEDATAS
  • GETSQLPARTONLYPURGEDATAS | IGNORESQLPARTONLYPURGEDATAS
  • GETPURGES | IGNOREPURGES
  • GETPURGEDATAS | IGNOREPURGEDATAS
  • GETRENAMES | IGNORERENAMES
  • GETREPLICATES | IGNOREREPLICATES
  • GETROLLBACKS | IGNOREROLLBACKS
  • GETSQLPARTONLYPURGEDATAS | IGNORESQLPARTONLYPURGEDATAS
  • GETUPDATEAFTERS | IGNOREUPDATEAFTERS
  • GETUPDATEBEFORES | IGNOREUPDATEBEFORES
  • GETUPDATES | IGNOREUPDATES
  • GROUPTRANSOPS
  • HANDLECOLLISIONS | NOHANDLECOLLISIONS
  • HEARTBEAT
  • HOMETERM
  • HOMETERMMESSAGES
  • HOST
  • IGNOREPARAMERROR
  • IGNORETMFDUMPS
  • INCLUDE
  • INCLUDESOURCEAPPINFO | EXCLUDESOURCEAPPINFO
  • INSERTALLRECORDS | NOINSERTALLRECORDS
  • INSERTDELETES | NOINSERTDELETES
  • INSERTMISSINGUPDATES | NOINSERTMISSINGUPDATES
  • INSERTUPDATES | NOINSERTUPDATES
  • IPINTERFACE
  • LAGCRITICAL
  • LAGINFO
  • LAGREPORT
  • LAGSTATS
  • LIMITRECS
  • LIST | NOLIST
  • LOG
  • LOGFILESBEHIND | LOGFILESBEHINDINFO
  • LOGFILEOPENS
  • LOGGERFILENUM
  • LOGGERFLUSHRECS
  • LOGGERFLUSHSECS | LOGGERFLUSHCSECS
  • LOGGERTIMEOUTSECS
  • LOGGGSCICOMMANDS
  • LOGON
  • MACRO
  • MACROCHAR
  • MANAGERREQUIRED
  • MAP
  • MAPEXCLUDE
  • MAXABENDRESTARTS
  • MAXDISCARDRECS
  • MAXETCHECKPOINTSECS
  • MAXTRANSMEM
  • MAXTRANSOPS
  • MAXWILDCARDENTRIES
  • NETWORKCHECKPOINTS
  • NOFILEAGING
  • NOTSTOPPABLE
  • NUMEXTRACTS
  • OBEY
  • OLDGROUPNAMING
  • OMITAUDITGAPCHECK
  • OPENTIMEOUT | OPENTIMEOUTMINUTES
  • OPENWARNINGS
  • OVERRIDEDUPS | NOOVERRIDEDUPS
  • PARTMAP
  • PARAMCHECK
  • PORT
  • POSITIONFIRSTRECORD
  • PRIORITY
  • PURGEDATAALTFILES | NOPURGEDATAALTFILE
  • PURGEOLDEXTRACTS for Extract and Replicat
  • PURGEOLDEXTRACTS for Manager
  • PURGEOLDTASKS
  • PURGERESTORE | NOPURGERESTORE
  • READER
  • READTHRULOCKS | NOREADTHRULOCKS
  • RECEIVEQWARN
  • RENAMEBUMPDELAY
  • REPERROR
  • REPLACEBADCHAR
  • REPLACEBADNUM
  • REPLICAT
  • REPNEWCOLUMNS | NOREPNEWCOLUMNS
  • REPORT
  • REPORTCOUNT
  • REPORTFILEEXTENTS
  • REPORTROLLOVER
  • REPORTTMFEXCEPTIONS
  • REPSQLLOG
  • RESTARTCOLLISIONS | NORESTARTCOLLISIONS
  • RESTARTINTERVAL
  • RESTORE | NORESTORE
  • REVERSEWINDOWSECS | REVERSEWINDOWCSECS
  • RETRYDELAY
  • RETRYERR
  • RMTFILE
  • RMTHOST
  • RMTHOSTALT
  • RMTTASK
  • RMTTRAIL
  • ROLLOVER
  • SETENV
  • SHORTREADDELAY
  • SOURCEDEFS
  • SOURCEISFILE | SOURCEISTABLE
  • SPECIALRUN
  • SQLFORMATDISCARDFILE
  • SQLFORMATDISCARDROLLOVER
  • STATOPTIONS
  • SUPPRESSALLALTERMESSAGES | NOSUPPRESSALLALTERMESSAGES
  • SUPPRESSALTERMESSAGES | NOSUPPRESSALTERMESSAGES
  • SUPPRESSFETCHCOMPRESSEDDISCARDS | NOSUPPRESSFETCHCOMPRESSEDDISCARDS
  • SUPPRESSFILEOPMESSAGES | NOSUPPRESSFILEOPMESSAGES
  • SUPPRESSMARKERMESSAGES
  • SUPPRESSMISSINGMAPS|NOSUPPRESSMISSINGMAPS
  • SWAPVOL
  • SYNCFILE
  • SYSKEYCONVERT
  • TABLE
  • TABLESINCATALOG
  • TABLEEXCLUDE
  • TALUSEREXIT
  • TCPBUFSIZE
  • TCPFLUSHBYTES
  • TCPIPPROCESSNAME
  • TCPIPSWITCHERRS
  • TCPSOURCETIMER | NOTCPSOURCETIMER
  • THRESHOLD | NOTHRESHOLD
  • TMFDUMPAGE
  • TMFDUMPTABLEENTRIES
  • TMFEXCEPTIONS | NOTMFEXCEPTIONS
  • TMFREFRESHINTERVAL
  • TMFTRAILTRACE
  • TRACE
  • TRACEALLOPENS
  • TRACECLOSES
  • TRACEOPENS
  • TRACEPROCESSIOS
  • TRACESTATS
  • TRANSMEMVOLS
  • UPDATEDELETES | NOUPDATEDELETES
  • UPDATEINSERTS | NOUPDATEINSERTS
  • UPREPORT
  • VERBOSE
  • VERIDATAREPORTAGE
  • VERSIONERR
  • WAITFILEEVENT
  • WARNRATE
  • Y2KCENTURYADJUSTMENT | NOY2KCENTURYADJUSTMENT
• Collector Parameters
  • Collector Parameters
  • QSAM Configuration Parameters
• Field Conversion Functions
  • Overview of Functions
    • Function Syntax
    • Function Summaries
      • Working with Columns
      • Working with Dates
      • Working with Numbers and Arithmetic Expressions
      • Working with Conditional Statements
      • Working with Character and Numeric Strings
      • Environmental Information
  • BINARY
  • CASE
  • COLSTAT
  • COLTEST
  • COMPUTE
  • CONVERTFLOAT
  • DATE
  • DATEDIFF
  • DATENOW
  • EVAL
  • GETENV
  • GETTLFTOKEN
  • GETVAL
  • HIGHVAL | LOWVAL
  • IF
  • NUMBIN
  • NUMSTR
  • RANGE
  • SIZEOF
  • STRCAT
  • STRCMP
  • STREQ
  • STREXT
  • STRFIND
  • STRLEN
  • STRLTRIM
  • STRNCAT
  • STRNCMP
  • STRNUM
  • STRRTRIM
  • STRSUB
  • STRTRIM
  • STRUP
  • TOKEN
  • VALONEOF
• DEFGEN Arguments
  • Argument Summary
  • EXCLUDESYSTEM | INCLUDESYSTEM
  • EXPANDDDL
  • NCHARCOMPATIBILITY
  • RECORDNAMEPROMPTING
  • FORMAT RELEASE
• DDLGEN Arguments
  • Run-time arguments
  • Template parameters
  • OMITNULL | INCLUDENULL
  • OMITNOTNULL | INCLUDENOTNULL
  • OMITREDEFS | INCLUDEREDEFS
  • OMITCOMMENTS | INCLUDECOMMENTS
  • USESAMENULLS
• User Exit Functions
  • Function summary
  • User Exits in Native Mode
  • EXIT_CALL_RESULT
  • EXIT_CALL_TYPE
  • EXIT_PARAMS
  • EXIT_REC_BUF
  • Calling environment functions
  • COMPRESS_RECORD | COMPRESS_RECORD2
  • DECOMPRESS_RECORD | DECOMPRESS_RECORD2
  • FETCH_CURRENT_RECORD
  • FETCH_CURRENT_RECORD_WITH_LOCK
  • GET_ALTKEY_INFO
  • GET_COLUMN_INDEX
  • GET_COLUMN_NAME
  • GET_ENV_VALUE
  • GET_EXITPARAM_VALUE
  • GET_EXTRBA
  • GET_EXTSEQNO
  • GET_FILENAME
  • GET_FILENAME_EXTERNAL
  • GET_FILEOP_INFO
  • GET_FOPEN_NUM
  • GET_NUM_COLUMNS
  • GET_RECORD | GET_RECORD2
  • GET_RECORD_LENGTH | GET_RECORD_LENGTH2
  • GET_SYSKEY_LENGTH
  • GET_TRANSACTION_IND
  • GET_USER_TOKEN_VALUE
  • GGS_EMSMESSAGE
  • GGS_REPORTMESSAGE
  • SET_TARGET_FILENAME_EXTERNAL
  • SET_TARGET_RECORD2
  • SET_TARGET_RECORD_LENGTH2
• Event Error and Warning Messages