{"id":1534,"date":"2010-04-19T22:04:47","date_gmt":"2010-04-20T03:04:47","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=1534"},"modified":"2011-02-16T11:14:04","modified_gmt":"2011-02-16T16:14:04","slug":"goldengate-commands-trail","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=1534","title":{"rendered":"GoldenGate Commands: Trail"},"content":{"rendered":"<span id=\"ADD_EXTTRAIL\"><h2>ADD EXTTRAIL<\/h2><\/span>\n<p>Create a trail for<br \/>\n* Online processing on the local system<br \/>\n* Associate it with an Extract group<br \/>\n* Assign a maximum file size<\/p>\n<span id=\"Syntax\"><h3>Syntax<\/h3><\/span>\n<pre lang=\"sql\">\r\nADD EXTTRAIL <trail name>, -- Full path name of trail name (two characters only)\r\nEXTRACT <group name>  -- Only one extract can write data to trail\r\n[, MEGABYTES n]  -- Max size of trail file\r\n<\/pre>\n<span id=\"Examples\"><h3>Examples<\/h3><\/span>\n<pre>\r\nGGSCI 57> add exttrail .\/dirdat\/cu, extract e_cust, megabytes 20\r\nEXTTRAIL added.<\/pre>\n<span id=\"ALTER_EXTTRAIL\"><h2>ALTER EXTTRAIL<\/h2><\/span>\n<p>Alter local extract trail attributes. The change takes effect the next time extract starts.<\/p>\n<span id=\"Syntax_1\"><h3>Syntax<\/h3><\/span>\n<pre lang=\"sql\">\r\nALTER EXTTRAIL <trail name>, EXTRACT < group name>[, MEGABYTES <n>]<\/pre>\n<span id=\"Examples_1\"><h3>Examples<\/h3><\/span>\n<pre lang=\"sql\">\r\nGGSCI 12> info exttrail *\r\n       Extract Trail: .\/dirdat\/cu\r\n             Extract: E_CUST\r\n               Seqno: 0\r\n                 RBA: 0\r\n           File Size: 20M\r\n       Extract Trail: C:\\prog\\GoldenGate\\GoldenGate_Src\\dirdat\\cu\r\n             Extract: E_CUST\r\n               Seqno: 0\r\n                 RBA: 980\r\n           File Size: 20M\r\n\r\nGGSCI 13> alter exttrail C:\\prog\\GoldenGate\\GoldenGate_Src\\dirdat\\cu, extract e_cust, megabytes 25\r\nEXTTRAIL altered.\r\n\r\nGGSCI 14> info exttrail *\r\n\r\n       Extract Trail: .\/dirdat\/cu\r\n             Extract: E_CUST\r\n               Seqno: 0\r\n                 RBA: 0\r\n           File Size: 20M\r\n       Extract Trail: C:\\prog\\GoldenGate\\GoldenGate_Src\\dirdat\\cu\r\n             Extract: E_CUST\r\n               Seqno: 0\r\n                 RBA: 980\r\n           File Size: 25M\r\n<\/pre>\n<span id=\"ALTER_RMTTRAIL\"><h2>ALTER RMTTRAIL<\/h2><\/span>\n<p>Change extract trail attributes on a remote system. The change takes effect the next time extract starts.<\/p>\n<span id=\"Syntax_2\"><h3>Syntax<\/h3><\/span>\n<pre lang=\"sql\">\r\nALTER RMTTRAIL <trail name>, EXTRACT <group name>\r\n[, MEGABYTES <n>]<\/pre>\n<span id=\"Examples_2\"><h3>Examples<\/h3><\/span>\n<pre lang=\"sql\">\r\nALTER RMTTRAIL c:\\ggs\\dirdat\\aa, EXTRACT finance,\r\nMEGABYTES 20<\/pre>\n<span id=\"DELETE_EXTTRAIL\"><h2>DELETE EXTTRAIL<\/h2><\/span>\n<p>Delete <strong>checkpoint records<\/strong> associated with a trail on local system. Does <strong>not<\/strong> delete trail files themselves. Use standard OS commands to remove files.<\/p>\n<span id=\"Syntax_3\"><h3>Syntax<\/h3><\/span>\n<pre lang=\"sql\">\r\nDELETE EXTTRAIL <trail name><\/pre>\n<span id=\"Examples_3\"><h3>Examples<\/h3><\/span>\n<pre lang=\"sql\">\r\nDELETE EXTTRAIL \/home\/ggs\/dirdat\/et<\/pre>\n<span id=\"DELETE_RMTTRAIL\"><h2>DELETE RMTTRAIL<\/h2><\/span>\n<p>Delete <strong>checkpoint records<\/strong> associated with a trail on remote system. Does <strong>not<\/strong> delete trail files themselves. Use standard OS commands to remove files.<\/p>\n<span id=\"Syntax_4\"><h3>Syntax<\/h3><\/span>\n<pre lang=\"sql\">\r\nDELETE RMTTRAIL <trail name><\/pre>\n<span id=\"Examples_4\"><h3>Examples<\/h3><\/span>\n<pre lang=\"sql\">\r\nDELETE RMTTRAIL \/home\/ggs\/dirdat\/et<\/pre>\n<span id=\"INFO_EXTTRAIL\"><h2>INFO EXTTRAIL<\/h2><\/span>\n<p>Retrieves extract trail info for a local trail.<\/p>\n<span id=\"Syntax_5\"><h3>Syntax<\/h3><\/span>\n<pre lang=\"sql\">\r\nINFO EXTTRAIL <trail name><\/pre>\n<span id=\"Examples_5\"><h3>Examples<\/h3><\/span>\n<pre lang=\"sql\">\r\nGGSCI 18> info exttrail .\/dirdat\/cu\r\n       Extract Trail: .\/dirdat\/cu\r\n             Extract: E_CUST\r\n               Seqno: 0\r\n                 RBA: 0\r\n           File Size: 20M\r\n\r\nGGSCI 19> info exttrail *<\/pre>\n<span id=\"INFO_RMTTRAIL\"><h2>INFO RMTTRAIL<\/h2><\/span>\n<p>Get extract trail info on a  remote system.<\/p>\n<span id=\"Syntax_6\"><h3>Syntax<\/h3><\/span>\n<pre lang=\"sql\">\r\nINFO RMTTRAIL <trail name><\/pre>\n<span id=\"Examples_6\"><h3>Examples<\/h3><\/span>\n<pre lang=\"sql\">\r\nINFO RMTTRAIL c:\\ggs\\dirdat\\aa\r\nINFO RMTTRAIL *<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>ADD EXTTRAIL Create a trail for * Online processing on the local system * Associate it with an Extract group * Assign a maximum file size Syntax ADD EXTTRAIL , &#8212; Full path name of trail name (two characters only) &hellip; <a href=\"https:\/\/jianmingli.com\/wp\/?p=1534\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","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-1534","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-oK","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1534","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=1534"}],"version-history":[{"count":2,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1534\/revisions"}],"predecessor-version":[{"id":1946,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1534\/revisions\/1946"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}