Db2 for z/OS work files

The CDC for Db2® for z/OS® Differential Refresh feature uses a scrollable cursor to progress through the source and target tables when determining which rows of the source table need to be sent to the target table, and which rows of the target table need to be removed. Scrollable cursors require the use of Db2 Declared Global Temporary Tables (DBTT), which in turn require that underlying Db2 work file database and table spaces be defined. This is documented in the appropriate Db2 manuals. If these Db2 resources were not created during the installation of Db2, then they must be created before the first attempt to use the CDC for Db2 for z/OS Differential Refresh feature.

For more information about Differential Refresh, see Starting a refresh on a subscription.