{"id":1532,"date":"2010-04-19T21:02:55","date_gmt":"2010-04-20T02:02:55","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=1532"},"modified":"2011-08-04T12:23:20","modified_gmt":"2011-08-04T17:23:20","slug":"goldengate-commands-extract","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=1532","title":{"rendered":"GoldenGate Commands: Extract"},"content":{"rendered":"<p>Use Extract commands to create and manage Extract groups. The Extract process captures either full data records or transactional data changes, depending on configuration parameters, and then sends the data to a target system to be applied to target tables or processed further by another process, such as a load utility.<\/p>\n<span id=\"ADD_EXTRACT\"><h2>ADD EXTRACT<\/h2><\/span>\n<p>Create an extract group.<\/p>\n<span id=\"Syntax:_regular_extract\"><h3>Syntax: regular extract<\/h3><\/span>\n<pre>\r\nADD EXTRACT group name  -- Group name max is 8, do not end with numbers\r\n{, SOURCEISTABLE |  -- Creates initial load for whole table\r\n, TRANLOG [bsds name] |  -- Use transaction log as data source. bsds name: for DB2\r\n, VAM |  -- Use vendor access module to extract data\r\n, EXTFILESOURCE file name |  -- Use an extract file as data source (pump). File name needs to be full path \r\n, EXTTRAILSOURCE trail name | -- Use a trail file as data source (pump). File name needs to be full path\r\n, VAMTRAILSOURCE VAM trail name}  -- Use VAM trail file as data source.\r\n{, BEGIN {NOW |   -- When ADD EXTRACT command is issued. Do not use for pumps.\r\nyyyy-mm-dd [hh:mi:[ss[.cccccc]]]} |  \r\n, EXTSEQNO seqno -- For Oracle\r\n, EXTRBA relative byte address | -- For DB2\r\n, LOGNUM log number, LOGPOS byte offset |  -- For c-tree\r\n, LSN value |  -- For SQLServer\r\n, EXTRBA relative byte address |\r\n, EOF | LSN value |  -- DB2\r\n, PAGE data page, ROW row |  -- Sybase\r\n}\r\n[, THREADS n]  -- Number of redo threads when extracting data from Oracle RAC.\r\n[, PASSIVE]  -- Runs in passive mode. Can only be start\/stop by an alias extract group on target system.\r\n[, PARAMS parameter file]  -- Specify full path of parameter file if not default 'dirprm'\r\n[, REPORT report file]  -- Specify full path of report file if not default 'dirrpt'\r\n[, DESC description]  -- Some description\r\n<\/pre>\n<span id=\"Syntax:_Alias_Extract\"><h3>Syntax: Alias Extract<\/h3><\/span>\n<pre>ADD EXTRACT group name\r\n, RMTHOST {host name | IP address}  -- Identifies extract group as an alias extract\r\n, {MGRPORT port} | -- Remote manager port (dynamic Collector)\r\n{PORT port}  -- Static Collector port\r\n[, RMTNAME name]  -- Specify passive extract name\r\n[, DESC description]<\/pre>\n<span id=\"Examples\"><h3>Examples<\/h3><\/span>\n<p>Regular extract<\/p>\n<pre>\r\nGGSCI 19> add extract e_cust, tranlog, begin now\r\nEXTRACT added.\r\nGGSCI 20> info extract *\r\nEXTRACT    E_CUST    Initialized   2010-04-15 10:42   Status STOPPED\r\nCheckpoint Lag       00:00:00 (updated 00:00:02 ago)\r\nLog Read Checkpoint  Oracle Redo Logs\r\n                     2010-04-15 10:42:05  Seqno 0, RBA 0\r\n<\/pre>\n<p>Initial load extract group<\/p>\n<pre>\r\nGGSCI 21> add extract e_load, sourceistable\r\nEXTRACT added.\r\nGGSCI 23> info extract e_load\r\n\r\nEXTRACT    E_LOAD    Initialized   2010-04-15 10:49   Status STOPPED\r\nCheckpoint Lag       Not Available\r\nLog Read Checkpoint  Not Available\r\n                     First Record         Record 0\r\nTask                 SOURCEISTABLE\r\n<\/pre>\n<p>Delayed start extract.<\/p>\n<pre>\r\nGGSCI 24> add extract e_delay, tranlog, begin 2010-4-15 02:00\r\nEXTRACT added.\r\n\r\nGGSCI 26> info extract e_delay\r\nEXTRACT    E_DELAY   Initialized   2010-04-15 11:30   Status STOPPED\r\nCheckpoint Lag       09:30:59 (updated 00:00:12 ago)\r\nLog Read Checkpoint  Oracle Redo Logs\r\n                     2010-04-15 02:00:00  Seqno 0, RBA 0<\/pre>\n<p>Passive extract.<\/p>\n<pre>\r\nGGSCI 27> add extract e_pass, tranlog, begin now, passive\r\nEXTRACT added.\r\n\r\nGGSCI 28> add extract e_pass_a, rmthost localhost, mgrport 7909\r\n, rmtname e_pass\r\nEXTRACT added.\r\n\r\nGGSCI 29> info extract e_pass\r\nEXTRACT    E_PASS    Initialized   2010-04-15 11:33   Status STOPPED\r\nCheckpoint Lag       00:00:00 (updated 00:00:45 ago)\r\nLog Read Checkpoint  Oracle Redo Logs\r\n                     2010-04-15 11:33:20  Seqno 0, RBA 0\r\n\r\nGGSCI 33> info extract e_pass_a\r\nEXTRACT    E_PASS_A  Initialized   2010-04-15 11:35   Status STOPPED\r\nALIAS      E_PASS    LOCALHOST:7909\r\n\r\nForwarding command to E_PASS@LOCALHOST:7909\r\nEXTRACT    E_PASS    Initialized   2010-04-15 11:33   Status STOPPED\r\nCheckpoint Lag       00:00:00 (updated 00:01:58 ago)\r\nLog Read Checkpoint  Oracle Redo Logs\r\n                     2010-04-15 11:33:20  Seqno 0, RBA 0\r\n<\/pre>\n<span id=\"ALTER_EXTRACT\"><h2>ALTER EXTRACT<\/h2><\/span>\n<span id=\"Syntax\"><h3>Syntax<\/h3><\/span>\n<pre>ALTER EXTRACT group name\r\n[, ADD EXTRACT attribute]\r\n[, THREAD number]\r\n[, ETROLLOVER]  -- Rollover to next trail file\r\n<\/pre>\n<span id=\"Examples_1\"><h3>Examples<\/h3><\/span>\n<pre>alter extract e_delay, etrollover<\/pre>\n<span id=\"CLEANUP_EXTRACT\"><h2>CLEANUP EXTRACT<\/h2><\/span>\n<p>Delete extract run history.<\/p>\n<span id=\"Syntax_1\"><h3>Syntax<\/h3><\/span>\n<pre>CLEANUP EXTRACT <group name> \r\n[, SAVE n]  -- Save most n recent records\r\n<\/pre>\n<span id=\"Examples_2\"><h3>Examples<\/h3><\/span>\n<pre>GGSCI 36> cleanup extract e_delay\r\nERROR: Nothing to cleanup for EXTRACT E_DELAY.<\/pre>\n<span id=\"DELETE_EXTRACT\"><h2>DELETE EXTRACT<\/h2><\/span>\n<p>Delete an extract group. It deletes checkpoint file only. Parameter file and trail file are not deleted.<\/p>\n<span id=\"Syntax_2\"><h3>Syntax<\/h3><\/span>\n<pre>DELETE EXTRACT <group name> \r\n[!]  -- Delete all extract groups associated with a wildcard (*) without prompting.\r\n<\/pre>\n<span id=\"Examples_3\"><h3>Examples<\/h3><\/span>\n<pre>GGSCI 37> delete extract e_pass_a\r\nDeleted EXTRACT E_PASS_A.<\/pre>\n<span id=\"INFO_EXTRACT\"><h2>INFO EXTRACT<\/h2><\/span>\n<p>Show info about an extract group.<\/p>\n<span id=\"Syntax_3\"><h3>Syntax<\/h3><\/span>\n<pre>INFO EXTRACT<group name>\r\n[, SHOWCH [n]]  -- Show checkpoints\r\n[, DETAIL]  -- Show details\r\n[, TASKS   -- Show tasks\r\n| ALLPROCESSES]  -- Show all processes\r\n<\/pre>\n<span id=\"Examples_4\"><h3>Examples<\/h3><\/span>\n<pre>\r\ninfo extract e_cust\r\ninfo extract e_cust, detail\r\ninfo extract e_cust, showch\r\ninfo extract *, tasks\r\ninfo extract *, allprocesses\r\n<\/pre>\n<span id=\"KILL_EXTRACT\"><h2>KILL EXTRACT<\/h2><\/span>\n<p>Kill an extract process if it can *not* be stopped by STOP EXTRACT.<\/p>\n<span id=\"Syntax_4\"><h3>Syntax<\/h3><\/span>\n<pre>KILL EXTRACT group name<\/pre>\n<span id=\"Examples_5\"><h3>Examples<\/h3><\/span>\n<pre>\r\nGGSCI 51> kill extract e_cust\r\nEXTRACT E_CUST is already stopped.\r\n\r\nGGSCI 52> kill extract e*\r\nEXTRACT E_CUST is already stopped.\r\nEXTRACT E_DELAY is already stopped.\r\nEXTRACT E_PASS is already stopped.<\/pre>\n<span id=\"LAG_EXTRACT\"><h2>LAG EXTRACT<\/h2><\/span>\n<p>Displays true lag between extract and data source.<\/p>\n<span id=\"Syntax_5\"><h3>Syntax<\/h3><\/span>\n<pre>LAG EXTRACT <group name><\/pre>\n<span id=\"Examples_6\"><h3>Examples<\/h3><\/span>\n<pre>lag extract e_cust<\/pre>\n<span id=\"SEND_EXTRACT\"><h2>SEND EXTRACT<\/h2><\/span>\n<span id=\"Syntax_6\"><h3>Syntax<\/h3><\/span>\n<pre><\/pre>\n<span id=\"Examples_7\"><h3>Examples<\/h3><\/span>\n<pre><\/pre>\n<span id=\"START_EXTRACT\"><h2>START EXTRACT<\/h2><\/span>\n<span id=\"Syntax_7\"><h3>Syntax<\/h3><\/span>\n<pre>START EXTRACT group_name<\/pre>\n<span id=\"Examples_8\"><h3>Examples<\/h3><\/span>\n<pre>start extract e_cust<\/pre>\n<span id=\"STATS_EXTRACT\"><h2>STATS EXTRACT<\/h2><\/span>\n<p>Get stats about extract process.<\/p>\n<span id=\"Syntax_8\"><h3>Syntax<\/h3><\/span>\n<pre>STATS EXTRACT group name\r\n[, statistic] -- e.g. TOTAL, DAILY, HOURLY, LATEST, RESET\r\n[, TABLE table]\r\n[, TOTALSONLY table spec]\r\n[, REPORTFETCH | NOREPORTFETCH]\r\n[, REPORTRATE time units] -- e.g. HR, MIN, SEC\r\n[, ... ]\r\n<\/pre>\n<span id=\"Examples_9\"><h3>Examples<\/h3><\/span>\n<pre>STATS EXTRACT finance, TOTAL, HOURLY, TABLE acct,\r\nREPORTRATE MIN, RESET, REPORTFETCH<\/pre>\n<span id=\"STOP_EXTRACT\"><h2>STOP EXTRACT<\/h2><\/span>\n<p>Stops an extract process.<\/p>\n<span id=\"Syntax_9\"><h3>Syntax<\/h3><\/span>\n<pre>STOP EXTRACT group name<\/pre>\n<span id=\"Examples_10\"><h3>Examples<\/h3><\/span>\n<pre><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Use Extract commands to create and manage Extract groups. The Extract process captures either full data records or transactional data changes, depending on configuration parameters, and then sends the data to a target system to be applied to target tables &hellip; <a href=\"https:\/\/jianmingli.com\/wp\/?p=1532\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[88],"tags":[],"class_list":["post-1532","post","type-post","status-publish","format-standard","hentry","category-goldengate"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-oI","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1532","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1532"}],"version-history":[{"count":5,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1532\/revisions"}],"predecessor-version":[{"id":2922,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1532\/revisions\/2922"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}