Using per job queries when upgrading from a version earlier than 9.4 Fix Pack 2

1. Upgrade all components in your environment to version 9.4, Fix Pack 2 or later.
2. Depending on your database, run one of the statements listed below as many times as necessary until the History table is entirely updated. Several runs might be necessary.
3. Run the queries listed in Per Job license model.

If you are using a DB2 database, run the following statement:

UPDATE ( SELECT * FROM MDL.JHR_JOB_HISTORY_RUNS 
WHERE WKC_LICENSE_TYPE = '-' FETCH FIRST 10000 ROWS ONLY )
SET WKC_LICENSE_TYPE = 'J'

If you are using an Oracle database, run the following statement:

UPDATE JHR_JOB_HISTORY_RUNS
   set WKC_LICENSE_TYPE = 'J'
   where WKC_LICENSE_TYPE = '-' and rownum <= 10000

If you are using an IDS database, run the following statement:

UPDATE MDL.JHR_JOB_HISTORY_RUNS SET WKC_LICENSE_TYPE = 'J' WHERE JOB_ID  IN 
 (SELECT JOB_ID FROM 
    (SELECT FIRST 10000 JOB_ID FROM MDL.JHR_JOB_HISTORY_RUNS WHERE
    WKC_LICENSE_TYPE = '-')
  )

If you are using an MSSQL database, run the following statement:

UPDATE TOP (10000) MDL.JHR_JOB_HISTORY_RUNS set WKC_LICENSE_TYPE = 'J'
  where WKC_LICENSE_TYPE = '-'