Loading tables in Data Gate on Cloud

You can load tables in the Data Gate on Cloud instance from the Table tab of the dashboard.

About this task

  • Loading can take a long time (for example minutes or hours) depending on the amount of data in the original Db2® for z/OS® tables.
  • The disk throughput can be volatile, depending on the disk configuration, the placement of data sets, the number of parallel I/O operations, and so on. To a large extent, the throughput depends on the following factors:
    • Partitioning of tables in your Db2 subsystem. In Db2 for z/OS, this determines the degree of parallelism that can be used internally by the Db2 Unload Utilities.
    • Number of DATE, TIME, and TIMESTAMP columns in your original table. The conversion of the values in such columns is CPU-intensive.
    • Compression of data in Db2 for z/OS.
    • Number of available processors.
    • Workload Manager (WLM) configuration.
    • Workload on the IBM® Z server.
    • Workload on the Data Gate on Cloud instances.
Restrictions:
  • During a load process, you cannot close OpenShift® or the database connection before the loading has finished.
  • If you change the partitioning type of the table space of a Db2 for z/OS table (for example, from segmented to partitioned by growth), you can no longer load the corresponding table in your Data Gate on Cloud instance. The operation will fail. Therefore, you must remove the table from the instance and redefine it after changing the partitioning type.
  • After a load, a replication-enabled Data Gate on Cloud table goes into Suspended state if someone has stopped replication during the load.

    Suspended means that the table is skipped when incremental updates are applied. To make this table part of the synchronization process again, you must reload it.

Procedure

  1. Open the Data Gate on Cloud instance UI (as described in chapter xx)
    Draft comment: kuester@de.ibm.com
    Resolve the reference "as described in chapter xx"
    You see the dashboard of your instance.
  2. From the Table tab of the dashboard, select the tables you want to load by selecting the appropriate check boxes in front of the table name (in the check boxes column of the list).
    If the list of tables is long, you can use the search field above the list header. The field allows you to search for particular schema names or table names. Type the names in this field, either fully or partially, to display just the schemas or tables starting with or containing the search string.
  3. Click the Load button on the header of the tables list.

Results

The status of the selected tables on the Table tab of the dashboard changes to Loading. When the loading has finished, the status is Loaded. If the tables are loaded by the synchronization process, the status is Active when the loading has finished.
Note: If the load fails, first check whether DSNUTIL was started in Db2 for z/OS.