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 AUDSERVPROGRAM
- 2.17 AUTORESTART
- 2.18 AUTOSTART
- 2.19 BACKUPCPU
- 2.20 BEGIN
- 2.21 BULKIOLOAD | NOBULKIOLOAD
- 2.22 CHECKINTERVAL
- 2.23 CHECKMINUTES
- 2.24 CHECKPARAMS
- 2.25 CHECKPOINTSECS
- 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 DECRYPTTRAIL
- 2.40 DICTIONARY
- 2.41 DISCARDFILE
- 2.42 DISCARDROLLOVER
- 2.43 DISKTHRESHOLD | NODISKTHRESHOLD
- 2.44 DISPLAYFILEREFRESHES
- 2.45 DISPLAYTRAILSWITCH | NODISPLAYTRAILSWITCH
- 2.46 DOWNCRITICAL
- 2.47 DOWNINFO
- 2.48 DOWNREPORT
- 2.49 DUP
- 2.50 DUPONLYAFTEREVENT
- 2.51 DUPPROCESS
- 2.52 DYNAMICPARTITIONS
- 2.53 DYNAMICPORTLIST
- 2.54 DYNAMICPORTREASSIGNDELAY
- 2.55 EMBEDDEDMACROS | NOEMBEDDEDMACROS
- 2.56 EMSLOG
- 2.57 ENCRYPTTRAIL | NOENCRYPTTRAIL
- 2.58 END
- 2.59 ENTRYSEQUPDATES
- 2.60 EOFDELAY | EOFDELAYCSECS
- 2.61 ERREPLYTIMEOUT
- 2.62 ERROR59ROLLOVER
- 2.63 ETNEWFORMAT
- 2.64 EVENT
- 2.65 EXCLUDEFILE
- 2.66 EXCLUDEGGSTRANSRECS | INCLUDEGGSTRANSRECS
- 2.67 EXCLUDESUFFIXCHAR
- 2.68 EXPANDDDL
- 2.69 EXTFILE
- 2.70 EXTRACT
- 2.71 EXTTRAIL
- 2.72 FASTIO
- 2.73 FASTPOSITION | NOFASTPOSITION
- 2.74 FASTREADS | NOFASTREADS
- 2.75 FETCHCOMPS | FETCHLASTIMAGE
- 2.76 FILE
- 2.77 FILE | TABLE
- 2.78 FILEAGEDAYS
- 2.79 FILEAGESCANDAYS
- 2.80 FILEEXCLUDE
- 2.81 FILEOPWARNING
- 2.82 FILERESOLVE
- 2.83 FILLSHORTRECS | NOFILLSHORTRECS
- 2.84 FILTERVIEW | NOFILTERVIEW
- 2.85 FLUSHCHECKPOINT | NOFLUSHCHECKPOINT
- 2.86 FLUSHSECS | FLUSHCSECS
- 2.87 FORCESTOPDELAY
- 2.88 FORCEUSESYSKEY | NOFORCEUSESYSKEY
- 2.89 FORMATASCII | NOFORMATASCII
- 2.90 FORMATLOCAL
- 2.91 FORMATSQL | NOFORMATSQL
- 2.92 FORMATXML
- 2.93 FUNCTIONSTACKSIZE
- 2.94 GETALTKEYS | IGNOREALTKEYS
- 2.95 GETAPPLOPS | IGNOREAPPLOPS
- 2.96 GETAUXTRAILS | IGNOREAUXTRAILS
- 2.97 GETCOMPS | IGNORECOMPS
- 2.98 GETCREATES | IGNORECREATES
- 2.99 GETDEFAULTS
- 2.100 GETDELETES | IGNOREDELETES
- 2.101 GETENV
- 2.102 GETFILEOPS | IGNOREFILEOPS
- 2.103 GETINSERTS | IGNOREINSERTS
- 2.104 GETMARKERS | IGNOREMARKERS
- 2.105 GETNETCHANGES | IGNORENETCHANGES
- 2.106 GETNETWORKALTFILENAMES | IGNORENETWORKALTFILENAMES
- 2.107 GETNEWCOLUMNS | IGNORENEWCOLUMNS
- 2.108 GETPARTONLYPURGEDATAS | IGNOREPARTONLYPURGEDATAS
- 2.109 GETPURGES | IGNOREPURGES
- 2.110 GETPURGEDATAS | IGNOREPURGEDATAS
- 2.111 GETRENAMES | IGNORERENAMES
- 2.112 GETREPLICATES | IGNOREREPLICATES
- 2.113 GETROLLBACKS | IGNOREROLLBACKS
- 2.114 GETUPDATEAFTERS | IGNOREUPDATEAFTERS
- 2.115 GETUPDATEBEFORES | IGNOREUPDATEBEFORES
- 2.116 GETUPDATES | IGNOREUPDATES
- 2.117 GROUPTRANSOPS
- 2.118 HANDLECOLLISIONS | NOHANDLECOLLISIONS
- 2.119 HEARTBEAT
- 2.120 HOMETERM
- 2.121 HOMETERMMESSAGES
- 2.122 HOST
- 2.123 IGNOREPARAMERROR
- 2.124 IGNORETMFDUMPS
- 2.125 INCLUDE
- 2.126 INCLUDESOURCEAPPINFO | EXCLUDESOURCEAPPINFO
- 2.127 INSERTALLRECORDS | NOINSERTALLRECORDS
- 2.128 INSERTDELETES | NOINSERTDELETES
- 2.129 INSERTMISSINGUPDATES | NOINSERTMISSINGUPDATES
- 2.130 INSERTUPDATES | NOINSERTUPDATES
- 2.131 IPINTERFACE
- 2.132 LAGCRITICAL
- 2.133 LAGINFO
- 2.134 LAGREPORT
- 2.135 LAGSTATS
- 2.136 LIMITRECS
- 2.137 LIST | NOLIST
- 2.138 LOG
- 2.139 LOGFILESBEHIND | LOGFILESBEHINDINFO
- 2.140 LOGFILEOPENS
- 2.141 LOGGERFILENUM
- 2.142 LOGGERFLUSHRECS
- 2.143 LOGGERFLUSHSECS | LOGGERFLUSHCSECS
- 2.144 LOGGERTIMEOUTSECS
- 2.145 LOGGGSCICOMMANDS
- 2.146 LOGON
- 2.147 MACRO
- 2.148 MACROCHAR
- 2.149 MANAGERREQUIRED
- 2.150 MAP
- 2.151 MAPEXCLUDE
- 2.152 MAXABENDRESTARTS
- 2.153 MAXDISCARDRECS
- 2.154 MAXETCHECKPOINTSECS
- 2.155 MAXTRANSMEM
- 2.156 MAXTRANSOPS
- 2.157 MAXWILDCARDENTRIES
- 2.158 NETWORKCHECKPOINTS
- 2.159 NOFILEAGING
- 2.160 NOTSTOPPABLE
- 2.161 NUMEXTRACTS
- 2.162 NUMFILES
- 2.163 OBEY
- 2.164 OLDGROUPNAMING
- 2.165 OMITAUDITGAPCHECK
- 2.166 OPENTIMEOUT | OPENTIMEOUTMINUTES
- 2.167 OPENWARNINGS
- 2.168 OVERRIDEDUPS | NOOVERRIDEDUPS
- 2.169 PARTMAP
- 2.170 PARAMCHECK
- 2.171 PORT
- 2.172 POSITIONFIRSTRECORD
- 2.173 PRIORITY
- 2.174 PURGEDATAALTFILES | NOPURGEDATAALTFILE
- 2.175 PURGEOLDEXTRACTS for Extract and Replicat
- 2.176 PURGEOLDEXTRACTS for Manager
- 2.177 PURGEOLDTASKS
- 2.178 PURGERESTORE | NOPURGERESTORE
- 2.179 READER
- 2.180 READTHRULOCKS | NOREADTHRULOCKS
- 2.181 RECEIVEQWARN
- 2.182 RENAMEBUMPDELAY
- 2.183 REPERROR
- 2.184 REPLACEBADCHAR
- 2.185 REPLACEBADNUM
- 2.186 REPLICAT
- 2.187 REPNEWCOLUMNS | NOREPNEWCOLUMNS
- 2.188 REPORT
- 2.189 REPORTCOUNT
- 2.190 REPORTFILEEXTENTS
- 2.191 REPORTROLLOVER
- 2.192 REPORTTMFEXCEPTIONS
- 2.193 REPSQLLOG
- 2.194 RESTARTCOLLISIONS | NORESTARTCOLLISIONS
- 2.195 RESTARTINTERVAL
- 2.196 RESTORE | NORESTORE
- 2.197 REVERSEWINDOWSECS | REVERSEWINDOWCSECS
- 2.198 RETRYDELAY
- 2.199 RETRYERR
- 2.200 RMTBATCH
- 2.201 RMTFILE
- 2.202 RMTHOST
- 2.203 RMTHOSTALT
- 2.204 RMTTASK
- 2.205 RMTTRAIL
- 2.206 ROLLOVER
- 2.207 SETENV
- 2.208 SHORTREADDELAY
- 2.209 SOURCEDEFS
- 2.210 SOURCEISFILE | SOURCEISTABLE
- 2.211 SPECIALRUN
- 2.212 SQLFORMATDISCARDFILE
- 2.213 SQLFORMATDISCARDROLLOVER
- 2.214 STATOPTIONS
- 2.215 SUPPRESSALLALTERMESSAGES | NOSUPPRESSALLALTERMESSAGES
- 2.216 SUPPRESSALTERMESSAGES | NOSUPPRESSALTERMESSAGES
- 2.217 SUPPRESSFETCHCOMPRESSEDDISCARDS | NOSUPPRESSFETCHCOMPRESSEDDISCARDS
- 2.218 SUPPRESSFILEOPMESSAGES | NOSUPPRESSFILEOPMESSAGES
- 2.219 SUPPRESSMARKERMESSAGES
- 2.220 SUPPRESSMISSINGMAPS|NOSUPPRESSMISSINGMAPS
- 2.221 SWAPVOL
- 2.222 SYNCFILE
- 2.223 SYSKEYCONVERT
- 2.224 TABLE
- 2.225 TABLESINCATALOG
- 2.226 TABLEEXCLUDE
- 2.227 TALUSEREXIT
- 2.228 TCPBUFSIZE
- 2.229 TCPFLUSHBYTES
- 2.230 TCPIPPROCESSNAME
- 2.231 TCPIPSWITCHERRS
- 2.232 TCPSOURCETIMER | NOTCPSOURCETIMER
- 2.233 THRESHOLD | NOTHRESHOLD
- 2.234 TMFDUMPAGE
- 2.235 TMFDUMPTABLEENTRIES
- 2.236 TMFEXCEPTIONS | NOTMFEXCEPTIONS
- 2.237 TMFREFRESHINTERVAL
- 2.238 TMFTRAILTRACE
- 2.239 TRACE
- 2.240 TRACEALLOPENS
- 2.241 TRACECLOSES
- 2.242 TRACEOPENS
- 2.243 TRACEPROCESSIOS
- 2.244 TRACESTATS
- 2.245 TRANSMEMVOLS
- 2.246 UPDATEDELETES | NOUPDATEDELETES
- 2.247 UPDATEINSERTS | NOUPDATEINSERTS
- 2.248 UPREPORT
- 2.249 VERBOSE
- 2.250 VERIDATAREPORTAGE
- 2.251 VERSIONERR
- 2.252 WAITFILEEVENT
- 2.253 WARNRATE
- 2.254 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 STRCAT
- 4.21 STRCMP
- 4.22 STREQ
- 4.23 STREXT
- 4.24 STRFIND
- 4.25 STRLEN
- 4.26 STRLTRIM
- 4.27 STRNCAT
- 4.28 STRNCMP
- 4.29 STRNUM
- 4.30 STRRTRIM
- 4.31 STRSUB
- 4.32 STRTRIM
- 4.33 STRUP
- 4.34 TOKEN
- 4.35 VALONEOF
- 5 DEFGEN Arguments
- 6 DDLGEN Arguments
-
7
User Exit Functions
- 7.1 Function summary
- 7.2 EXIT_CALL_RESULT
- 7.3 EXIT_CALL_TYPE
- 7.4 EXIT_PARAMS
- 7.5 EXIT_REC_BUF
- 7.6 Calling environment functions
- 7.7 COMPRESS_RECORD | COMPRESS_RECORD2
- 7.8 DECOMPRESS_RECORD | DECOMPRESS_RECORD2
- 7.9 FETCH_CURRENT_RECORD
- 7.10 FETCH_CURRENT_RECORD_WITH_LOCK
- 7.11 GET_ALTKEY_INFO
- 7.12 GET_COLUMN_INDEX
- 7.13 GET_COLUMN_NAME
- 7.14 GET_ENV_VALUE
- 7.15 GET_EXITPARAM_VALUE
- 7.16 GET_EXTRBA
- 7.17 GET_EXTSEQNO
- 7.18 GET_FILENAME
- 7.19 GET_FILENAME_EXTERNAL
- 7.20 GET_FOPEN_NUM
- 7.21 GET_NUM_COLUMNS
- 7.22 GET_RECORD | GET_RECORD2
- 7.23 GET_RECORD_LENGTH | GET_RECORD_LENGTH2
- 7.24 GET_SYSKEY_LENGTH
- 7.25 GET_TRANSACTION_IND
- 7.26 GET_USER_TOKEN_VALUE
- 7.27 GGS_EMSMESSAGE
- 7.28 GGS_REPORTMESSAGE
- 7.29 SET_TARGET_FILENAME_EXTERNAL
- 7.30 SET_TARGET_RECORD2
- 7.31 SET_TARGET_RECORD_LENGTH2
- 8 Event Error and Warning Messages