Some times its very difficult to find Extract is Classic or integrated when you are newly learning Golden Gate or New to Integrated Extract. Here are the few ways you can find existing Extract is Classic or Integrated by using below methods
Method 1 ) By executing info extract extract_name you can get information
GGSCI (test.corp.cox.com) 5> info APPSEX
EXTRACT APPSEX Last Started 2016-03-28 20:16 Status STOPPED
Checkpoint Lag 00:00:01 (updated 4874:08:45 ago)
Log Read Checkpoint Oracle Redo Logs ======> Classic Extract
2016-03-29 08:37:37 Thread 1, Seqno 8270, RBA 12257432
SCN 0.86773783 (86773783)
-- Lets see Integrated Extract output
GGSCI (test.corp.cox.com) 5> info APPSEXAPE1
EXTRACT APPSEXAPE1 Last Started 2016-09-23 19:26 Status RUNNING
Checkpoint Lag 00:00:03 (updated 00:00:02 ago)
Process ID 2202
Log Read Checkpoint Oracle Integrated Redo Logs ==> Integrated Extract
2016-10-18 10:45:41
SCN 2669.1345414578 (11464613127602)
Note : you can also get by hitting below command on GGSCI
info extract extract_name , detail
Example :-
GGSCI (test.corp.cox.com) 8> info APEX3, detail
EXTRACT APEX3 Last Started 2016-09-23 19:26 Status RUNNING
Checkpoint Lag 00:00:04 (updated 00:00:04 ago)
Process ID 2471
Log Read Checkpoint Oracle Integrated Redo Logs
2016-10-18 15:14:40
SCN 2677.985860036 (11498613311428)
Target Extract Trails:
Trail Name Seqno RBA Max MB Trail Type
./dirdat/APPS/E3 28 39880233 500 EXTTRAIL
Integrated Extract outbound server first scn: Unavailable.Need DBLOGIN.
Integrated Extract outbound server filtering start scn: Unavailable.Need DBLOGIN.
Extract Source Begin End
Not Available 2016-06-23 14:43 2016-10-18 15:14
Not Available 2016-06-23 14:43 2016-09-23 19:23
Not Available 2016-06-23 14:43 2016-09-23 19:23
Not Available 2016-06-23 14:43 2016-09-13 11:31
Not Available 2016-06-23 14:43 2016-09-13 11:31
Not Available 2016-06-23 14:43 2016-09-10 12:07
Not Available 2016-06-23 14:43 2016-09-10 12:07
Not Available 2016-06-23 14:43 2016-09-10 01:28
Not Available 2016-06-23 14:43 2016-09-10 01:28
Not Available 2016-06-23 14:43 2016-08-31 19:24
Not Available 2016-06-23 14:43 2016-08-31 19:24
Not Available 2016-06-23 14:43 2016-08-31 01:47
Not Available 2016-06-23 14:43 2016-08-31 01:47
Not Available 2016-06-23 14:43 2016-08-25 10:50
Not Available 2016-06-23 14:43 2016-08-25 10:50
Not Available 2016-06-23 14:43 2016-08-23 09:33
Not Available 2016-06-23 14:43 2016-08-23 09:33
Not Available 2016-06-23 14:43 2016-08-22 15:28
Not Available 2016-06-23 14:43 2016-08-22 15:28
Not Available * Initialized * 2016-06-23 14:43
Not Available * Initialized * 2016-06-23 14:43
Current directory /product/12.2/gghome11
Report file /product/12.2/gghome11/dirrpt/XXXX.rpt
Parameter file /product/12.2/gghome11/dirprm/XXXX.prm
Checkpoint file /product/12.2/gghome11/dirchk/XXXX.cpe
Process file /product/12.2/gghome11/dirpcs/XXXX.pce
Error log /product/12.2/gghome11/ggserr.log
Method 2 ) you can check parameter file for extract where you can find some specific parameters for Integrated extract
cat /product/12.2/gghome11/dirprm/APEX3_Extract_Global.prm | |grep -i integrated
TRANLOGOPTIONS INTEGRATEDPARAMS (max_sga_size 1024, parallelism 2)
So you can see above parameter IntegratedParams in parameter file. if you found above parameter that extract is integrated.
No comments:
Post a Comment