Hi - Our application loads DB2 data on a daily basis every night. It create multiple load files to be loaded for multiple tables. Load files are created on one mainframe box are transmitted to another mainframe box where the table are residing. Load jobs are configured to load these files across multiple tables. Before the load, there is a job that switches the view from the main table to a shadow table and after the load is complete the view is again switched back to the main table. I was looking for any suggestion that can make this process better or replace it with some different solution for ex. Que replication. Any other suggesstions would be helpful.
Average time it takes for the entire process to complete is 3-4 hours. In the meantime, the tables are unavailable and you need to query shadow table to fetch details.