打开附加日志，配置相关进程

1、添加附加日志
[code]ggsci
dblogin userid ogguser,password ogguser
add trandata LPROMIS.T_JJ_XMAQJCXX
add trandata LPROMIS.T_JJ_AQYBZDFX
add trandata LPROMIS.T_JJ_ZBXX
add trandata LPROMIS.T_JJ_YZXMBRY
add trandata LPROMIS.T_JJ_YZXMBJBXX
add trandata LPROMIS.T_JJ_XMGC
add trandata LPROMIS.T_JJ_GCSPQK
add trandata LPROMIS.T_JJ_DTGCJD
add trandata LPROMIS.T_JJ_DTGC
add trandata LPROMIS.T_JJ_NDJDJHXF
add trandata LPROMIS.T_JJ_JSGLDW
add trandata LPROMIS.T_JJ_DMMX
add trandata LPROMIS.T_JJ_XMJBXX
add trandata LPROMIS.T_JJ_XMJDZT
add trandata STDPM.T_BNS_PRJM_PROJECT
add trandata STDPM.T_SXM_SHIGRZ
add trandata STDPM.T_SXM_WORKSC
add trandata STDPM.T_SXM_ZHOUYB
add trandata STDPM.T_BNS_PRJM_CONSTRUTUNIT
add trandata STDPM.T_BNS_PRJM_PROBASINFOSEND
add trandata STDPM.T_BNS_PRJM_PROBASINFOTRAN
add trandata STDPM.T_BNS_PRJM_PROBASINFO
add trandata STDPM.T_CTL_DICTIONARY
add trandata STDPM.T_GATHER_PROJECT_GROUP_DX
add trandata STDPM.T_PDC_ORGANIZATION
add trandata STDPM.T_PGC_OF_PROJECT
add trandata STDPM.T_PGC_OF_PROJECT_LIST
add trandata STDPM.T_STD_YEAR_PLAN[/code]

2、添加抽取和投递进程
[code]add extract sextr01, tranlog, begin now
add exttrail ./dirdat/va, EXTRACT sextr01, megabytes 100

add extract spump01 , exttrailsource ./dirdat/va
add rmttrail ./dirdat/va, ext spump01, megabytes 100[/code]

3、配置抽取进程sextr01
[code]GGSCI (twserver) 5> edit params sextr01
EXTRACT sextr01
SETENV (NLS_LANG=AMERICAN_AMERICA.UTF8)
USERID ogguser,PASSWORD ogguser
DYNAMICRESOLUTION
Gettruncates
report at 1:59
reportrollover at 2:00
warnlongtrans 3h, checkinterval 10m
TRANLOGOPTIONS RAWDEVICEOFFSET 0
EXTTRAIL ./dirdat/va

TABLE LPROMIS.T_JJ_XMAQJCXX;
TABLE LPROMIS.T_JJ_AQYBZDFX;
TABLE LPROMIS.T_JJ_ZBXX;
TABLE LPROMIS.T_JJ_YZXMBRY;
TABLE LPROMIS.T_JJ_YZXMBJBXX;
TABLE LPROMIS.T_JJ_XMGC;
TABLE LPROMIS.T_JJ_GCSPQK;
TABLE LPROMIS.T_JJ_DTGCJD;
TABLE LPROMIS.T_JJ_DTGC;
TABLE LPROMIS.T_JJ_NDJDJHXF;
TABLE LPROMIS.T_JJ_JSGLDW;
TABLE LPROMIS.T_JJ_DMMX;
TABLE LPROMIS.T_JJ_XMJBXX;
TABLE LPROMIS.T_JJ_XMJDZT;
TABLE STDPM.T_BNS_PRJM_PROJECT;
TABLE STDPM.T_SXM_SHIGRZ;
TABLE STDPM.T_SXM_WORKSC;
TABLE STDPM.T_SXM_ZHOUYB;
TABLE STDPM.T_BNS_PRJM_CONSTRUTUNIT;
TABLE STDPM.T_BNS_PRJM_PROBASINFOSEND;
TABLE STDPM.T_BNS_PRJM_PROBASINFOTRAN;
TABLE STDPM.T_BNS_PRJM_PROBASINFO;
TABLE STDPM.T_CTL_DICTIONARY;
TABLE STDPM.T_GATHER_PROJECT_GROUP_DX;
TABLE STDPM.T_PDC_ORGANIZATION;
TABLE STDPM.T_PGC_OF_PROJECT;
TABLE STDPM.T_PGC_OF_PROJECT_LIST;
TABLE STDPM.T_STD_YEAR_PLAN;[/code]

4、配置投递进程spump01
[code]GGSCI (twserver) 6> edit params spump01

EXTRACT spump01
DYNAMICRESOLUTION
USERID ogguser,PASSWORD ogguser
RMTHOST 10.141.5.30,MGRPORT 7848,COMPRESS
RMTTRAIL ./dirdat/va
TABLE LPROMIS.*;
TABLE STDPM.*;[/code]
5、开启相关进程
[code]start mgr
start sextr01
start spump01
info all
info *[/code]