Tables By Batches (bcgct8189m000)

Use this session to list the tables under a specific batch along with further information regarding the migration of each table.

Preparation

Before you can use this session, the Maintain Batch Codes (bcgct8188m000) session should be running. The Tables By Batches (bcgct8189m000) session can be invoked from the Maintain Batch Codes session.

Batch Code

This field displays the Batch Code from which the tables are listed.

Table Name

This field displays the name of the table.

Skip?

The value in this field indicates whether the table is considered for migration or not.

If this check box is selected, the table is bypassed during conversion that is, the table is not considered for migration. If this check box is cleared, the table is considered for migration.

Duration

The value in this field indicates the time taken for migrating the table.

Allowed values

  • Shorter
  • Longer

Default value

  • Shorter

Select Longer if the table is extremely large. While dumping, all the tables marked as Longer are dumped first, followed by tables marked as Shorter. This helps in load balancing, and ensures that dumping the large tables does not start at the end and take a long time when all the other b-shells are already completing the dumping process. A list of tables that usually contain a large amount of data are marked as Longer. You can choose a list of tables manually, as per your requirements.

  • Load balancing is a technique used to improve the performance of the tool.
  • Generate a mix of Longer and Shorter tables in a ratio of 60:40 for the dump b-shells.
Load Option

The value in this field indicates, if data is already existing, the same must be overwritten or retained during migration.

Allowed values

  • Truncate: If the table on the target side already has some data, the data will be deleted and data from the table on the source side will be added to the table on the target side during migration.
  • Append: The data from the table on the source side is appended to the already existing data in the table on the target side.

Default value

  • Truncate

The Truncate option is not available in the Informix-specific loader. If the load option is Truncate, the table rows are manually deleted with SQL, and the Append option is the default option.

Mode of Loading

The value in this field is used during the generation of the control file.

Allowed values

  • Automatic
  • Conventional

Default value

  • Automatic

The Oracle SQL* Loader has two load modes. The two modes are Direct and Conventional. If you set the load mode to Automatic, and the size of the data file is greater than 10,000 bytes, the load mode of SQL* Loader is set to Direct. If you set the load mode to Conventional, the load mode of SQL* Loader is also set to Conventional.

Informix HPL has two load modes. The two modes are Express and Deluxe. If you set the load mode in Informix to Automatic, and the size of the data file is greater than 10,000 bytes, the load mode of Informix HPL is set to Express. Otherwise, the load mode is Deluxe. If you set the load mode to Conventional, the load mode of the Informix HPL is set to Deluxe.

Object Present

The value in this field indicates whether the conversion script (in the form of dll) is present for the respective table on the source side or not.