R3trans used for System Refresh activity

R3tans command can be very handy for System Refresh as we can take export of tables relevant to RFCs, Partner profiles, tRFC ports and distribution models :

command for export

R3trans -w exp.log AE1_export.ctl

example of AE1_export.ctl


export
client=100
file='expAE1100_tables.dmp'
select * from edipoa
select * from edipod
select * from ediport
select * from edp12
select * from edp13
select * from edp21
select * from edpp1
select * from filename
select * from filetext
select * from kcdrm
select * from kcdrs
select * from kcdsm
select * from t462a
select * from tbd00
select * from tbd00t
select * from tbd05
select * from tbd06
select * from tbd30
select * from tbda2
select * from tbdlt
select * from tede2
select * from vari
select * from varid
select * from varit
select * from TBLSYSDEST
select * from TVARVC
select * from CIF_IMOD
select * from TBLSYSDEST
select * from EDPPV
select * from EDPVW
select * from TBDBR
select * from TBDBRF
select * from edpar
select * from edpi1
select * from edmat
select * from edmms
select * from edpo1
select * from edpo3
select * from ediphone
select * from EDPST
select * from EDIPO2
select * from EDIPOACODPAG
select * from EDIPOF
select * from EDIPOI
select * from EDIPOX
select * from EDIPOXH
select * from EDIPOXU

export
file='expAE1_tables.dmp'
select * from crep
select * from crep_http
select * from crepdescr
select * from dbsnp
select * from devaccess
select * from e070l
select * from edbas
select * from edbast
select * from edcim
select * from edcimt
select * from edimsg
select * from edimsgt
select * from edma
select * from edmsg
select * from edview
select * from edviewt
select * from filenameci
select * from filetextci
select * from moni
select * from ndisystems
select * from osmon
select * from pahi
select * from prgn_cust
select * from rslogsysmap
select * from rzllitab
select * from ssf_pse_h
select * from ssf_pse_d
select * from t000
select * from t002
select * from t002t
select * from tbdls
select * from tbdlst
select * from tdevc
select * from tedst
select * from tedtt
select * from toaar
select * from tpfet
select * from tpfht
select * from edipo
select * from crep_rfc
select * from btcomset
select * from STRUSTCERT
select * from STRUSTSSL
select * from STRUSTSSLT
select * from tmsqlastwl
select * from tmsqnotes
select * from tmsqwl
select * from tmsqwlf
select * from HTTPURLLOC
select * from rspor_t_portal 
select * from EDPO_QUEUE



export
file='expAE1RFC_tables.dmp'
select * from RFC2SOAPS
select * from RFCADPTATTR
select * from RFCADPTRCVLOG
select * from RFCADPTSNDLOG
select * from RFCATTRIB
select * from RFCCHECK
select * from RFCCMC
select * from RFCDES
select * from RFCDESSECU
select * from RFCGO
select * from RFCLIST
select * from RFCSTXTAB
select * from RFCSYSACL
select * from RFCTRUST
select * from RFCTSTLOG
select * from RFCTSTTAB
select * from RFCTYPE
select * from RFCTA
select * from RFCDOC


After system refresh, we need to import the above exported tables. While importing we need to reverse the process :

command

R3trans -w imp.log AE1_import.ctl


example of AE1_import.ctl

remove
client=100
select * from edipoa
select * from edipod
select * from ediport
select * from edp12
select * from edp13
select * from edp21
select * from edpp1
select * from filename
select * from filetext
select * from kcdrm
select * from kcdrs
select * from kcdsm
select * from t462a
select * from tbd00
select * from tbd00t
select * from tbd05
select * from tbd06
select * from tbd30
select * from tbda2
select * from tbdlt
select * from tede2
select * from vari
select * from varid
select * from varit
select * from TBLSYSDEST
select * from TVARVC
select * from CIF_IMOD
select * from TBLSYSDEST
select * from EDPPV
select * from EDPVW
select * from TBDBR
select * from TBDBRF
select * from edpar
select * from edpi1
select * from edmat
select * from edmms
select * from edpo1
select * from edpo3
select * from ediphone
select * from EDPST
select * from EDIPO2
select * from EDIPOACODPAG
select * from EDIPOF
select * from EDIPOI
select * from EDIPOX
select * from EDIPOXH
select * from EDIPOXU

import
client=100
file='expAE1100_tables.dmp'

remove
select * from crep
select * from crep_http
select * from crepdescr
select * from dbsnp
select * from devaccess
select * from e070l
select * from edbas
select * from edbast
select * from edcim
select * from edcimt
select * from edimsg
select * from edimsgt
select * from edma
select * from edmsg
select * from edview
select * from edviewt
select * from filenameci
select * from filetextci
select * from moni
select * from ndisystems
select * from osmon
select * from pahi
select * from prgn_cust
select * from rslogsysmap
select * from rzllitab
select * from ssf_pse_h
select * from ssf_pse_d
select * from t000
select * from t002
select * from t002t
select * from tbdls
select * from tbdlst
select * from tdevc
select * from tedst
select * from tedtt
select * from toaar
select * from tpfet
select * from tpfht
select * from edipo
select * from crep_rfc
select * from btcomset
select * from STRUSTCERT
select * from STRUSTSSL
select * from STRUSTSSLT
select * from tmsqlastwl
select * from tmsqnotes
select * from tmsqwl
select * from tmsqwlf
select * from HTTPURLLOC
select * from rspor_t_portal 
select * from EDPO_QUEUE

import
file='expAE1_tables.dmp'


remove
select * from RFC2SOAPS
select * from RFCADPTATTR
select * from RFCADPTRCVLOG
select * from RFCADPTSNDLOG
select * from RFCATTRIB
select * from RFCCHECK
select * from RFCCMC
select * from RFCDES
select * from RFCDESSECU
select * from RFCGO
select * from RFCLIST
select * from RFCSTXTAB
select * from RFCSYSACL
select * from RFCTRUST
select * from RFCTSTLOG
select * from RFCTSTTAB
select * from RFCTYPE
select * from RFCTA
select * from RFCDOC

import
file='expAE1RFC_tables.dmp'