Running Table Conversions

Note: During your upgrade you may choose to defer index builds for very large tables, for tables that are converted several times during the Table Conversion Workbench, or if you are planning on a Unicode conversion. For details and instructions on deferring index builds, refer to the subsection in this guide entitled: Deferring Index Builds During Table Conversion Workbench.

Note: Under certain conditions some Table Conversions may be marked as having already been run. Refer to Understanding UDO Table Conversions.

To run table conversions:

1. If it is not already open, open Installation Workbench, double-click your plan on Work with Installation Plan, and click Next until Table Conversion Workbench appears.

   

2. To override where the Table Conversions will be run, click on Run TC on Deployment Server.

3. To change how many Table Conversions are submitted simultaneously to the Enterprise Server, change the value in TC Throttle. This value should match the maximum jobs set up for the QBATCH queue on the Enterprise Server. You control how many TCs are actually running at any time by your queue set up by using WRKJOBQE.

   On your IBM i machine, make sure JOBQ MAX ACT is set to match the TC Throttle that you choose.

   Tip: To set the maximum number of simultaneous jobs submitted, refer to Select Enterprise Server and Maximum Jobs On Select Environments - Advanced Exit.

4. Select Convert All from the Form menu.

Tip: To do one conversion at a time, select the appropriate detail records, and then select Convert Selected from the Form menu. While the conversions run, you can track their progress by choosing Table Conversion\Merge Log (P984052). To do so, on the System Installation Tools menu (GH961), double-click Advanced Operation, and then Table Conversion\Merge Log. The program shows a scrolling list of the conversions that have processed.