Dovetailed Technologies

z/OS Hybrid Batch Processing: Updating a Linux database from z/OS batch

In a typical zEnterprise ecosystem, it is common to have Linux virtual servers that run customer facing web applications. In some cases, these applications use z/OS DB2 for their back end data store, but it is also typical to have this role fulfilled by an Oracle database on the Linux system itself.

Even if the database is local to the Linux system, however, it may need to be updated with data that is produced and/or held on z/OS. Traditionally, the process of applying these updates has involved a file transfer of a dataset containing the updates followed by a trigger that kicks off the utility (typically SQL *Loader) to load the database.

This approach has several drawbacks:

It would be ideal if this maintenance process could be scheduled and managed from z/OS, with just the database update program being present on the Linux system. In order to make this possible, the following considerations need to be addressed. How will SQL *Loader:

The Co:Z Co-Processing Toolkit provides z/OS users with tools that mitigate these considerations while making it easy to exploit remote virtual servers (Linux on System z or Linux on zBX) from traditional batch workloads - an idiom we refer to as z/OS hybrid batch processing.

View the full paper: z/OS Hybrid Batch Processing: Updating a Linux database from z/OS batch [PDF]