Preparing data for a model in Db2 for z/OS

Before creating a WML for z/OS model, you must prepare your data and engineer data features for model training. For the purpose of practice, consider using the supplied sample data. The sample data is stored in Db2 for z/OS and consists of a single table named TENTDATA. The TENTDATA table contains more than 1000 records.

Before you begin

• Install and configure WML for z/OS as described in Roadmap for installing and configuring WML for z/OS.
• Ensure that you have authority to create tables and load data in a Db2 for z/OS subsystem.

To create a test table in Db2 for z/OS and load test data, complete the following steps:

1. Locate the following files for the sample data in the $IML_INSTALL_DIR/extra/examples/TentLRModel/ directory on the z/OS system where WML for z/OS is installed:
   • tentdata contains the sample data for the TENTDATA table.
   • tentjcl contains a sample JCL job for creating the TENTDATA table and loading the sample tentdata into the table.
2. Customize the tentjcl JCL job for your environment as described in the prolog section and submit the customized job.
3. Verify that the TENTDATA table is created and that it contains the sample data.