| # 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. Related topics Maintain Batch Codes (bcgct8188m000) 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. Generate Use this option in the appropriate menu to generate the list of tables under a batch. It starts the Generate (bcgct8289m000) session. Specify the range for package, module and table. For the given range, it checks if every package is implemented in Implemented Packages (bcgct7187m000) session. If the Tables by Batches (bcgct8189m000) session already consists of table related data for the currently selected batch code, you will be shown a message box with the query Do you want to delete the existing methods and generate afresh?. The message box provides the following options: Append: Adds the generated data to the existing data in Tables by Batches (bcgct8189m000) session. Overwrite: Deletes the existing data and store only the generated data in Tables by Batches (bcgct8189m000) session. Cancel: Cancels the action. Print Verify List Use this option in the appropriate menu to print a report. This report displays the list of tables that are currently present in the Tables by Batches (bcgct8189m000) session. Set Bypass Yes/No to Range of Tables Use this option in the appropriate menu to update the value in the Bypass field for a range of tables simultaneously. |