Loading tables in Data Gate

You can load tables in the Data Gate 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 datasets , 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 instances.
Restrictions:
  • During a load process, you cannot close Cloud Pak for Data 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 instance. The operation fails. 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 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.

  • You can load no more than 100 synchronization-enabled tables concurrently. If you want to load more than 100 synchronization-enabled tables, you must issue multiple requests.

Procedure

  1. Make sure that the Cloud Pak for Data perspective is selected. If necessary, click Perspective icon to change the perspective.
  2. Under My instances, click the name of the instance that you want to edit.
  3. Click Open instance.
  4. From the Table tab of the dashboard, select the tables that 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.
  5. 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.