Unanswered: automated export and ftp files script?
Perhaps the Unix script gurus can help me out. We want to export about 15 tables from our production database server over to our test database server (separate machine) using export and ftp. Any tips besides replication on how to do this? Here is a sample:
Database Server A:
db2 "export to /staging/info.del of del select * from info";
Database Server B:
script would need to connect to Database Server A and grab the files using ftp.