Exporting a table using R3trans is DB independent method.
Steps:
Login to CI server using sidadm user.
Check R3trans -d (Rc should be 0)
create a file named as export.ctl and put the tables names with sql queries in the file.
vi export.ctl
export
client=all
select * from SNCSYSACL
execute the below line.
R3trans -w export.log -u 1 export.ctl
this will create data file(trans.dat) and log file. check the log file.
After the export is completed. and after system copy is done we need to reimport the tables as below.
Import :
- After the System copy is completed, you can now (re)import the exported tables .
- You can check the tables entries after import and check the against logs of the table export
- Create the import.ctl file with entries, for example
- Run the command “R3trans -w import.log import.ctl “
- Check the log for the imported table entries and return code
