Simplify your OpenText Documentum migration with dqMan

1. Add the id to compare list

Find the active jobs by executing the following query: Select * from dm_job where is_inactive = false;

2. Use results to generate the script to enable the found jobs

Use Ctrl+A in the Results window to select all the results and use the option Generate Script from the right-click menu.

1. Select the type of script as DQL script.
2. Use the value of the ’{object_name}’ attribute (from the objects displayed in the Results window). FYI: The “’{” and “}’” before the attribute name are mandatory! Also, the “;” character is mandatory at the end of the query. To trigger automatic completion after the “’{” characters, press CTRL+SPACE.
3. Use the Generate button to generate the script.
   The resulting script will look like below. It should be copy-pasted in a separate document for safe keeping (until the jobs must be enabled again).
   

3. Disable the jobs

Disable the jobs by executing the following query: update dm_job objects set is_inactive = true where is_inactive = false;

4. Enable the jobs after the jobs

Retrieve the DQL script created in section 2 above and execute it as follows:

1. Select the DQL script window (in order to execute the whole script with just one click).
2. Paste the content of the file generated in section 2 into the DQL script window.
3. Click on the Run button.
4. Verify that the DQLs have been executed.
5. For each DQL, check that “object_update” indicates the number of updates as 1. FYI: For other scripts, the number should reflect the number of objects that need to be updated by that specific DQL.