1. Applications Upgrade Guide for IBM i with DB2 for IBM i
  2. Monitoring Table Conversions

Monitoring Table Conversions

Table Conversion Workbench implements a throttling mechanism to control conversions. If conversions are run on the Deployment Server, it launches one conversion at a time. If conversions are run on the Enterprise Server, it looks up the maximum number of batch jobs in the queue table and submits that many conversions at a time. Either way, technical conversions are always throttled to 1. The list of submitted conversions can be seen in Table Conversion Planner.

  1. Go to the System Installation Tools menu (GH961)

  2. Open Typical Installation Plan or Custom Installation Plan.

  3. Click Find.

  4. Expand the plan. Drill down to Environments, Environment Name, Table Conversions.

  5. Highlight the Table Conversions node and click Select.

  6. Enter 45 into the Detail Status QBE.

  7. Click Find.

    This image is described in the surrounding text.

    Use Submitted Reports (GH9011) to view the status of submitted conversions. Notice all the jobs show the R98405A program. To link the jobs to conversions, note the job number. The jde.log, jdedebug.log, and conversion log all have the job number in the name. The jde.log contains a message with the conversion name. For more on the log files, see the section below.

    This image is described in the surrounding text.

    Server Manager can be used to monitor processes and queues, and view JDE.LOG, jde.log, , JDEDEBUG.LOG, jdedebug.log, , and JDE.INIjde.ini.

    Platform-specific utilities such as Task ManagerWRKACTJOBps can also be used to monitor the conversions.

    Database Specific Queries that query unconverted tables, temp tables, converted tables, and database system tables can be helpful in monitoring conversions.