To run the Table Conversion Workbench

1. Fast Path to P9840TC and click ADD.

   

2. On the Maintain Table Conversion Plans form, complete these field and click OK:

   

   Field	Value
   Plan Name	Enter a name for the migration plan.
   Plan Description	Enter a description for the plan.
   Plan Detail Status	This should be set at a status 30.
   From Release Level	A733, A921, A931, or A940
   To Release Level	E920
   Previous Environment	Enter a name to identify the environment you are migrating. This is a temporary environment that is created over the JD Edwards World business and common data libraries. For example, DVTEMP, PYTEMP, PDTEMP, and so on.
   Target Environment	Enter the name of the environment to which you are migrating data.
   Run TC on Deployment Server	This option should not be selected. The workbench should submit the TCs to the Enterprise Server. Although it is not required to run table conversions on the Enterprise Server, performance might be enhanced by doing so. If you have a small database you might decide to the TCs on the Deployment Server. If so, select option Run TC on Deployment Server.
   Enterprise Data source	Enter the Enterprise Data Source name. This is the name of the Enterprise Server.
   TC Max Concurrent	Enter the TC Max Concurrent. 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 the queue setup, using WRKJOBQ. Make sure the IBM i JOBQ MAX ACT is set to match the TC Throttle that you select. Verify by using these commands: DSPSBSD QBATCH Option 6
   Tracing	This option should not be selected.

3. On the Setup DataSources/Mappings for World/CRM Migration form, complete these fields:

   

   In the Business Data Library field, enter the name of the JD Edwards World Business Data library you plan to migrate:

   Business Data – <xxxxxx>

   Where <xxxxxx> is the name of the temporary environment.

   In the Control Tables Library field, enter the name of the JD Edwards World Common Data library you plan to migrate:

   Control Tables – <xxxxxx>

   Where <xxxxxx> is the name of the temporary environment.

4. Click OK to access the Data Source Revisions form for Business Data.

   

5. Click OK to access the Data Source Revisions form for Control Tables.

   

6. Click OK on the message dialog.

   

7. On the Work with Table Conversion Plans form, find and select the plan name.

8. From the Row exit, select TC Planner to review all the JD Edwards World to JD Edwards EnterpriseOne TCs in the plan.

   

9. Verify that all the Table Conversions are at status 30.

10. Click Cancel. This returns you to the Work with Table Conversion Plans form.

11. This step applies ONLY to customers performing Direct Migration from World A7316 to EnterpriseOne 9.2.

    1. Run P9840TC and click Find.

    2. Highlight the created plan and click the TC Planner Row Exit.

    3. Find and select program R893111G. Change the status from “30" to “60" from “DTL STS" QBE.

       

    4. Click Form Exit. Save as shown in the following graphic.

       

    5. After you save it, the status changes to “60".

       

    6. Close the TC planner application.

12. Select the plan name, click Row, and select Table Conversion Workbench:

    

13. From the Form menu, select Convert All.

Troubleshooting:

While the conversions run, you can track their progress by selecting Table Conversion\Merge Log (P984052). On the System Installation Tools menu (GH961), double-click Advanced Operation, and then Table Conversion/Merge Log. The program shows a list of conversions that have processed.