Table of Contents
- Title and Copyright Information
- Preface
-
1
GGSCI Commands
- 1.1 Manager commands
- 1.2 Extract commands
- 1.3 Replicat commands
- 1.4 ER Commands
- 1.5 Logger Commands
- 1.6 Trail commands
- 1.7 Database commands
- 1.8 Audit trail commands
- 1.9 Remote checkpoint commands
- 1.10 TMF commands
- 1.11 Coordinator commands
- 1.12 Process commands
- 1.13 Marker commands
- 1.14 Programs commands
- 1.15 Report commands
- 1.16 Syncfile commands
- 1.17 Miscellaneous commands
-
2
Oracle GoldenGate Parameters
- 2.1 Parameter Summaries
- 2.2 ABORTDUPERRWINDOW
- 2.3 ADD DEFINE
- 2.4 ALLOCFILES
- 2.5 ALTFILERESOLVE | NOALTFILERESOLVE
- 2.6 ALTINPUT
- 2.7 ASSUMETARGETDEFS
- 2.8 AUDITING
- 2.9 AUDITREPS | NOAUDITREPS
- 2.10 AUDITRETRYDELAY
- 2.11 AUDSERVCACHEBLOCKS
- 2.12 AUDSERVCPU
- 2.13 AUDSERVPARAM
- 2.14 AUDSERVPREFIX
- 2.15 AUDSERVPROCESS
- 2.16 AUTORESTART
- 2.17 AUTOSTART
- 2.18 BACKUPCPU
- 2.19 BEGIN
- 2.20 BULKIOLOAD | NOBULKIOLOAD
- 2.21 CHECKINTERVAL
- 2.22 CHECKMINUTES
- 2.23 CHECKPARAMS
- 2.24 CHECKPOINTSECS
- 2.25 CHECKTHRESHOLDMIN
- 2.26 CHECKUNIQUEKEY | NOCHECKUIQUEKEY
- 2.27 CLEANUPSAVECOUNT
- 2.28 COBOLUSEREXIT
- 2.29 COLMATCH
- 2.30 COMMENT
- 2.31 COMPRESSDELETES | NOCOMPRESSDELETES
- 2.32 CONTROLTABLELOCKOFF
- 2.33 CONVERTALLFLOATSTOIEEE | NOCONVERTALLFLOATSTOIEEE
- 2.34 CONVERTALLFLOATSTOTDM | NOCONVERTALLFLOATSTOTDM
- 2.35 COORDINATOR
- 2.36 CPU
- 2.37 CUSEREXIT
- 2.38 DEBUGONSTACKCHECK
- 2.39 DISCARDROLLOVER
- 2.40 DECRYPTTRAIL
- 2.41 DEFERAPPLYINTERVAL
- 2.42 DICTIONARY
- 2.43 DISCARDFILE
- 2.44 DISKTHRESHOLD | NODISKTHRESHOLD
- 2.45 DISPLAYFILEREFRESHES
- 2.46 DISPLAYTRAILSWITCH | NODISPLAYTRAILSWITCH
- 2.47 DOWNCRITICAL
- 2.48 DOWNINFO
- 2.49 DOWNREPORT
- 2.50 DUP
- 2.51 DUPONLYAFTEREVENT
- 2.52 DUPPROCESS
- 2.53 DYNAMICPARTITIONS
- 2.54 DYNAMICPORTLIST
- 2.55 DYNAMICPORTREASSIGNDELAY
- 2.56 EMBEDDEDMACROS | NOEMBEDDEDMACROS
- 2.57 EMSLOG
- 2.58 ENCRYPTTRAIL | NOENCRYPTTRAIL
- 2.59 END
- 2.60 ENTRYSEQUPDATES
- 2.61 EOFDELAY | EOFDELAYCSECS
- 2.62 ERREPLYTIMEOUT
- 2.63 ERROR59ROLLOVER
- 2.64 ETNEWFORMAT
- 2.65 EVENT
- 2.66 EXCLUDEFILE
- 2.67 EXCLUDEGGSTRANSRECS | INCLUDEGGSTRANSRECS
- 2.68 EXCLUDESUFFIXCHAR
- 2.69 EXPANDDDL
- 2.70 EXTFILE
- 2.71 EXTRACT
- 2.72 EXTTRAIL
- 2.73 FASTIO
- 2.74 FASTPOSITION | NOFASTPOSITION
- 2.75 FASTREADS | NOFASTREADS
- 2.76 FETCHCOMPS | FETCHLASTIMAGE
- 2.77 FILE
- 2.78 FILEAGEDAYS
- 2.79 FILEAGESCANDAYS
- 2.80 FILEEXCLUDE
- 2.81 FILEOPWARNING
- 2.82 FILERESOLVE
- 2.83 FILE | TABLE
- 2.84 FILLSHORTRECS | NOFILLSHORTRECS
- 2.85 FILTERVIEW | NOFILTERVIEW
- 2.86 FLUSHCHECKPOINT | NOFLUSHCHECKPOINT
- 2.87 FLUSHSECS | FLUSHCSECS
- 2.88 FORCESTOPDELAY
- 2.89 FORCEUSESYSKEY | NOFORCEUSESYSKEY
- 2.90 FORMATASCII | NOFORMATASCII
- 2.91 FORMATLOCAL
- 2.92 FORMATSQL | NOFORMATSQL
- 2.93 FORMATXML
- 2.94 FUNCTIONSTACKSIZE
- 2.95 GETALTKEYS | IGNOREALTKEYS
- 2.96 GETAPPLOPS | IGNOREAPPLOPS
- 2.97 GETAUXTRAILS | IGNOREAUXTRAILS
- 2.98 GETCOMPS | IGNORECOMPS
- 2.99 GETCREATES | IGNORECREATES
- 2.100 GETDEFAULTS
- 2.101 GETDELETES | IGNOREDELETES
- 2.102 GETENV
- 2.103 GETFILEOPS | IGNOREFILEOPS
- 2.104 GETINSERTS | IGNOREINSERTS
- 2.105 GETMARKERS | IGNOREMARKERS
- 2.106 GETNETCHANGES | IGNORENETCHANGES
- 2.107 GETNETWORKALTFILENAMES | IGNORENETWORKALTFILENAMES
- 2.108 GETNEWCOLUMNS | IGNORENEWCOLUMNS
- 2.109 GETPARTONLYPURGEDATAS | IGNOREPARTONLYPURGEDATAS
- 2.110 GETPURGES | IGNOREPURGES
- 2.111 GETPURGEDATAS | IGNOREPURGEDATAS
- 2.112 GETRENAMES | IGNORERENAMES
- 2.113 GETREPLICATES | IGNOREREPLICATES
- 2.114 GETROLLBACKS | IGNOREROLLBACKS
- 2.115 GETUPDATEAFTERS | IGNOREUPDATEAFTERS
- 2.116 GETUPDATEBEFORES | IGNOREUPDATEBEFORES
- 2.117 GETUPDATES | IGNOREUPDATES
- 2.118 GROUPTRANSOPS
- 2.119 HANDLECOLLISIONS | NOHANDLECOLLISIONS
- 2.120 HEARTBEAT
- 2.121 HOMETERM
- 2.122 HOMETERMMESSAGES
- 2.123 HOST
- 2.124 IGNOREPARAMERROR
- 2.125 IGNORETMFDUMPS
- 2.126 INCLUDE
- 2.127 INCLUDESOURCEAPPINFO | EXCLUDESOURCEAPPINFO
- 2.128 INSERTALLRECORDS | NOINSERTALLRECORDS
- 2.129 INSERTDELETES | NOINSERTDELETES
- 2.130 INSERTMISSINGUPDATES | NOINSERTMISSINGUPDATES
- 2.131 INSERTUPDATES | NOINSERTUPDATES
- 2.132 IPINTERFACE
- 2.133 LAGCRITICAL
- 2.134 LAGINFO
- 2.135 LAGREPORT
- 2.136 LAGSTATS
- 2.137 LIMITRECS
- 2.138 LIST | NOLIST
- 2.139 LOG
- 2.140 LOGFILESBEHIND | LOGFILESBEHINDINFO
- 2.141 LOGFILEOPENS
- 2.142 LOGGERFILENUM
- 2.143 LOGGERFLUSHRECS
- 2.144 LOGGERFLUSHSECS | LOGGERFLUSHCSECS
- 2.145 LOGGERTIMEOUTSECS
- 2.146 LOGGGSCICOMMANDS
- 2.147 LOGON
- 2.148 MACRO
- 2.149 MACROCHAR
- 2.150 MANAGERREQUIRED
- 2.151 MAP
- 2.152 MAPEXCLUDE
- 2.153 MAXABENDRESTARTS
- 2.154 MAXDISCARDRECS
- 2.155 MAXETCHECKPOINTSECS
- 2.156 MAXTRANSMEM
- 2.157 MAXTRANSOPS
- 2.158 MAXWILDCARDENTRIES
- 2.159 NETWORKCHECKPOINTS
- 2.160 NOFILEAGING
- 2.161 NOTSTOPPABLE
- 2.162 NUMEXTRACTS
- 2.163 NUMFILES
- 2.164 OBEY
- 2.165 OLDGROUPNAMING
- 2.166 OMITAUDITGAPCHECK
- 2.167 OPENTIMEOUT | OPENTIMEOUTMINUTES
- 2.168 OPENWARNINGS
- 2.169 OVERRIDEDUPS | NOOVERRIDEDUPS
- 2.170 PARTMAP
- 2.171 PARAMCHECK
- 2.172 PORT
- 2.173 POSITIONFIRSTRECORD
- 2.174 PRIORITY
- 2.175 PURGEDATAALTFILES | NOPURGEDATAALTFILE
- 2.176 PURGEOLDEXTRACTS for Extract and Replicat
- 2.177 PURGEOLDEXTRACTS for Manager
- 2.178 PURGEOLDTASKS
- 2.179 PURGERESTORE | NOPURGERESTORE
- 2.180 READER
- 2.181 READTHRULOCKS | NOREADTHRULOCKS
- 2.182 RECEIVEQWARN
- 2.183 RENAMEBUMPDELAY
- 2.184 REPERROR
- 2.185 REPLACEBADCHAR
- 2.186 REPLACEBADNUM
- 2.187 REPLICAT
- 2.188 REPNEWCOLUMNS | NOREPNEWCOLUMNS
- 2.189 REPORT
- 2.190 REPORTCOUNT
- 2.191 REPORTFILEEXTENTS
- 2.192 REPORTROLLOVER
- 2.193 REPORTTMFEXCEPTIONS
- 2.194 REPSQLLOG
- 2.195 RESTARTCOLLISIONS | NORESTARTCOLLISIONS
- 2.196 RESTARTINTERVAL
- 2.197 RESTORE | NORESTORE
- 2.198 REVERSEWINDOWSECS | REVERSEWINDOWCSECS
- 2.199 RETRYDELAY
- 2.200 RETRYERR
- 2.201 RMTBATCH
- 2.202 RMTFILE
- 2.203 RMTHOST
- 2.204 RMTHOSTALT
- 2.205 RMTTASK
- 2.206 RMTTRAIL
- 2.207 ROLLOVER
- 2.208 SETENV
- 2.209 SHORTREADDELAY
- 2.210 SOURCEDEFS
- 2.211 SOURCEISFILE | SOURCEISTABLE
- 2.212 SPECIALRUN
- 2.213 SQLFORMATDISCARDFILE
- 2.214 SQLFORMATDISCARDROLLOVER
- 2.215 STATOPTIONS
- 2.216 SUPPRESSALLALTERMESSAGES | NOSUPPRESSALLALTERMESSAGES
- 2.217 SUPPRESSALTERMESSAGES | NOSUPPRESSALTERMESSAGES
- 2.218 SUPPRESSFETCHCOMPRESSEDDISCARDS | NOSUPPRESSFETCHCOMPRESSEDDISCARDS
- 2.219 SUPPRESSFILEOPMESSAGES | NOSUPPRESSFILEOPMESSAGES
- 2.220 SUPPRESSMARKERMESSAGES
- 2.221 SUPPRESSMISSINGMAPS|NOSUPPRESSMISSINGMAPS
- 2.222 SWAPVOL
- 2.223 SYNCFILE
- 2.224 SYSKEYCONVERT
- 2.225 TABLE
- 2.226 TABLESINCATALOG
- 2.227 TABLEEXCLUDE
- 2.228 TALUSEREXIT
- 2.229 TCPBUFSIZE
- 2.230 TCPFLUSHBYTES
- 2.231 TCPIPPROCESSNAME
- 2.232 TCPIPSWITCHERRS
- 2.233 TCPSOURCETIMER | NOTCPSOURCETIMER
- 2.234 THRESHOLD | NOTHRESHOLD
- 2.235 TMFDUMPAGE
- 2.236 TMFDUMPTABLEENTRIES
- 2.237 TMFEXCEPTIONS | NOTMFEXCEPTIONS
- 2.238 TMFREFRESHINTERVAL
- 2.239 TMFTRAILTRACE
- 2.240 TRACE
- 2.241 TRACEALLOPENS
- 2.242 TRACECLOSES
- 2.243 TRACEOPENS
- 2.244 TRACEPROCESSIOS
- 2.245 TRACESTATS
- 2.246 TRANSMEMVOLS
- 2.247 UPDATEDELETES | NOUPDATEDELETES
- 2.248 UPDATEINSERTS | NOUPDATEINSERTS
- 2.249 UPREPORT
- 2.250 VERBOSE
- 2.251 VERIDATAREPORTAGE
- 2.252 VERSIONERR
- 2.253 WAITFILEEVENT
- 2.254 WARNRATE
- 2.255 Y2KCENTURYADJUSTMENT | NOY2KCENTURYADJUSTMENT
- 3 Collector Parameters
-
4
Field Conversion Functions
- 4.1 Overview of Functions
- 4.2 BINARY
- 4.3 CASE
- 4.4 COLSTAT
- 4.5 COLTEST
- 4.6 COMPUTE
- 4.7 CONVERTFLOAT
- 4.8 DATE
- 4.9 DATEDIFF
- 4.10 DATENOW
- 4.11 EVAL
- 4.12 GETENV
- 4.13 GETTLFTOKEN
- 4.14 GETVAL
- 4.15 HIGHVAL | LOWVAL
- 4.16 IF
- 4.17 NUMBIN
- 4.18 NUMSTR
- 4.19 RANGE
- 4.20 SIZEOF
- 4.21 STRCAT
- 4.22 STRCMP
- 4.23 STREQ
- 4.24 STREXT
- 4.25 STRFIND
- 4.26 STRLEN
- 4.27 STRLTRIM
- 4.28 STRNCAT
- 4.29 STRNCMP
- 4.30 STRNUM
- 4.31 STRRTRIM
- 4.32 STRSUB
- 4.33 STRTRIM
- 4.34 STRUP
- 4.35 TOKEN
- 4.36 VALONEOF
- 5 DEFGEN Arguments
- 6 DDLGEN Arguments
-
7
User Exit Functions
- 7.1 Function summary
- 7.2 User Exits in Native Mode
- 7.3 EXIT_CALL_RESULT
- 7.4 EXIT_CALL_TYPE
- 7.5 EXIT_PARAMS
- 7.6 EXIT_REC_BUF
- 7.7 Calling environment functions
- 7.8 COMPRESS_RECORD | COMPRESS_RECORD2
- 7.9 DECOMPRESS_RECORD | DECOMPRESS_RECORD2
- 7.10 FETCH_CURRENT_RECORD
- 7.11 FETCH_CURRENT_RECORD_WITH_LOCK
- 7.12 GET_ALTKEY_INFO
- 7.13 GET_COLUMN_INDEX
- 7.14 GET_COLUMN_NAME
- 7.15 GET_ENV_VALUE
- 7.16 GET_EXITPARAM_VALUE
- 7.17 GET_EXTRBA
- 7.18 GET_EXTSEQNO
- 7.19 GET_FILENAME
- 7.20 GET_FILENAME_EXTERNAL
- 7.21 GET_FILEOP_INFO
- 7.22 GET_FOPEN_NUM
- 7.23 GET_NUM_COLUMNS
- 7.24 GET_RECORD | GET_RECORD2
- 7.25 GET_RECORD_LENGTH | GET_RECORD_LENGTH2
- 7.26 GET_SYSKEY_LENGTH
- 7.27 GET_TRANSACTION_IND
- 7.28 GET_USER_TOKEN_VALUE
- 7.29 GGS_EMSMESSAGE
- 7.30 GGS_REPORTMESSAGE
- 7.31 SET_TARGET_FILENAME_EXTERNAL
- 7.32 SET_TARGET_RECORD2
- 7.33 SET_TARGET_RECORD_LENGTH2
- 8 Event Error and Warning Messages