Running a work statement list to apply changes
Apply changes are placed in a work statement list (WSL) if you specified Generate apply jobs = YES and As work statement list = YES on the Generate Compare Jobs (GOC5) panel. You must use Db2® Admin Tool panels to run the work statement list.
About this task
When you run a WSL, you can generate single or multiple apply jobs for all operations. When no UNLOAD, RELOAD, or REORG operations are required, or when a single UNLOAD, a single RELOAD, or a single REORG operation is required, only a single job is generated for the WSL. When multiple UNLOAD, RELOAD, or REORG operations are required, and you want to generate a single apply job for all operations rather than a separate job for each operation, you must specify that a single job be generated when you run the WSL. If you specify one job, table GRANT statements are generated by Object Comparison Tool after tables, related indexes, and foreign keys are created, and after all rows are reloaded.