--=================================== -- VERSION 103 -- EDIT DATE: 22-AUG-17 -- EDIT BY: DJR/DFI --=================================== EXTRACT EATGUNCL SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8) USERID xx@PTBSN, PASSWORD xx EXTTRAIL ./dirdat/LOCAL/ATGUNCL/uc TRANLOGOPTIONS EXCLUDEUSER ggs TRANLOGOPTIONS EXCLUDEUSER exgg TRANLOGOPTIONS EXCLUDEUSER system TRANLOGOPTIONS EXCLUDEUSER sys -- VERSION 101A: DJR 8/25/2015 ADDED VERIDATA USER EXCLUSIONS TRANLOGOPTIONS EXCLUDEUSER VERI_FIX1 TRANLOGOPTIONS EXCLUDEUSER VERI_FIX2 TRANLOGOPTIONS EXCLUDEUSER VERI_FIX3 TRANLOGOPTIONS EXCLUDEUSER VERI_FIX4 TRANLOGOPTIONS ALLOWDATALOSS DISCARDFILE ./dirrpt/DISC/eatguncl.dsc, MEGABYTES 2000, APPEND DISCARDROLLOVER AT 01:00 DISCARDROLLOVER AT 05:00 DISCARDROLLOVER AT 09:00 DISCARDROLLOVER AT 13:00 DISCARDROLLOVER AT 17:00 DISCARDROLLOVER AT 21:00 REPORTCOUNT EVERY 100000 RECORDS, RATE REPORT ON SUNDAY AT 00:30 REPORTROLLOVER AT 01:00 ON SUNDAY STATOPTIONS REPORTFETCH STATOPTIONS RESETREPORTSTATS -- DMM 7/26/13 ADD CDROPTIONS CDROPTIONS _LOGALLSUPPCOLS DBOPTIONS ALLOWUNUSEDCOLUMN -- VERSION 100: DJR 10/23/2014 ADDED STABILITY ENHANCEMENTS TRANLOGOPTIONS LOGRETENTION SR WARNLONGTRANS 6HOURS, CHECKINTERVAL 30M TRANLOGOPTIONS DBLOGREADER TRANLOGOPTIONS BUFSIZE 4096000 TRANLOGOPTIONS DBLOGREADERBUFSIZE 4096000 --=================================== -- TESTING TABLE --=================================== TABLE GGS_TEST.NAMES2; -- VERSION 102 - DJR/DFI - 01-JUN-17 - CHANGED INCLUDE FILE NAME INCLUDE ./dirprm/eatg.inc -- VERSION 103 - DJR/DFI - 01-AUG-17 - Added new schema - moved wildcard to prm TABLE BBB_SWITCH_A.*; TABLE BBB_SWITCH_B.*; TABLE BBB_PUB.*; TABLE BBB_PIM_STG.*; TABLE BBB_CORE_PRV.*; TABLE BBB_GG.*; TABLE BBB_GG_PRV.*; --===================================