Generate Sourcedefs
ggsci > Edit params defgen
defsfile ./dirsql/SOURCE_DEFGEN.def
userid gguser password ******
TABLE schema.*;
Â
Enter the parameters listed above in the order shown and invoke DEFGEN from GG_HOME location
$ ./defgen paramfile ./dirprm/defgen.prm
Â
Use FTP or SFTP to transfer this SOURCE_DEFGEN.def file to the TARGET server
Â
Specify this copied SOURCE_DEFGEN.def file location in REPLICAT param file
e.g. SOURCEDEFS ./dirsql/SOURCE_DEFGEN.def
Discussion ¬