Get the code
by Gregory Dritschler | Published March 21, 2019
This code pattern shows you how to generate a set of CSV files, transform them using a tool called SQLite, and load them to a Db2 for z/OS database using a JDBC function called zload.
This work was done as part of the Summit Health set of code patterns, which demonstrate how cloud technology can access data stored on z/OS systems. We needed a way to generate a large amount of patient health care data to populate the Db2 for z/OS database. We found an open source tool called Synthea that generates the kind of synthentic data we wanted.
The Synthea CSV files needed to be transformed to match the table schemas used in the Summit Health application. We found a public domain tool called SQLite which made these transformations easy.
Finally, the transformed CSV files needed to be loaded from a distributed workstation into the Db2 for z/OS database. We used a JDBC function called zload to accomplish this. zload requires Db2 for z/OS version 12.
A shell script (run.sh or run.bat) drives the processing. There are four main steps as shown below.
Find the detailed steps for this pattern in the README file. The steps show you how to:
This article gives DB2 database administrators an overview of DB2 on a different platform than the one they're most familiar…
Start adding new apps to the ZOWE WebUi and find out how to communicate with other parts of ZOWE.
Get the Code »
Back to top