How do you all refresh data from one subsystem to another?
The way I do is, I've a list of tables to be refreshed in a table. I read that table, using a COBOL program and build Fast Load and Fast Unload JCLs and then run all the unload jobs first and then run all the load jobs. Sounds simple, right?
Here are the problems I've.
1. I use "OUTPUT-FORMAT LOAD" in the load control when I'm unloading data. This means, the tables structure have to match exactly between source and target. Sometimes the table structures don't match (one subsystem might have an extra column). So I run a compare DDL to make sure the structures match. If not, I sync them up manually - this is a time consuming process. If I use OUTPUT-FORMAT DSNTIAUL, I don't have to do this, but it's too slow.
2. We're on r16 of CA for DB2 tools. And it doesn't support LOBs and Index on Expressions. We're upgrading to r18. Does anyone remember on top of their head, if r18 support these tables? Without support for these objects, I'm using IBM tools just to refresh these tables. For Index on expression, I'm dropping those indexes, load the table and recreating the indexes - again, time consuming process.