Deleting multiple work IDs

To help control the size of the CM_WORKID and CM_SYNC tables, as well as other product CD tables, you can delete any unwanted work IDs. For information about controlling the size of sync tables, see Product-table-maintenance.

In this task, you perform the following subtasks:

1. Create a task ID.
2. Create a DML statement.
3. Execute the task ID.

To create a task ID

1. On the BMC AMI Change Manager for Db2 Main Menu, select CM/PILOT, and press Enter.
2. On the CM/PILOT Main Menu, select TASKIDs and press Enter.
3. On the TASKID Action Menu, type the name of a new TASKID and select Create a TASKID. Then, press Enter.
4. On the Script Selection List, select Delete one or more WORKIDs and press Enter.
5. On the Create TASKID panel, specify the information for a task ID.
   1. (optional) Specify a Comment to describe the task ID.
   2. Type S to select Create or Edit DML.
   3. Press Enter.

To create the DML statement

1. On the WORKID Detail for Delete WORKID DML panel, create a DML statement.

   1. Type an operator and a value for the WHERE clause.

      Tip

      To view all of the fields that can be used in the WHERE clause, type NEXT on the Command line after you have specified a value for the WHERE clause.

   2. Press END.

   The DML is displayed in the ISPF Editor.

2. Edit your DML statement in the ISPF Editor as shown in the following figure, if necessary.For information about DML syntax, see CM-PILOT-Data-Manipulation-Language-DML.

   Important

   You can copy the DML statement from member ACMDMLD2 in the HLQ.BMCCNTL data set.

   DELETE WORKID
   WHERE
         (WKOWNER  LIKE 'ABC%' OR
          WKOWNER  LIKE 'DEF%')
   AND    DATE(MODDATE) < DATE('2009-11-01')
   ;
3. When you have finished editing the statement, press END until the TASKID Action Menu is displayed.The task ID containing the DML statement for the script is created.

To execute the task ID

1. On the TASKID Action Menu, select Execute a TASKID and press Enter.
2. On the TASKID Interface panel, specify the data set names to be used by CM/PILOT.
   1. Type the data set name for the CM/PILOT Worklist.
   2. Type the data set name for the CM/PILOT JCL.
   3. Type the data set name for Diagnostics or type SYSOUT.
3. Select the method of executing the CM/PILOT worklist.For more information about executing a CM/PILOT worklist, see Processing-CM-PILOT-worklists.

4. On the TASKID Interface panel, create a CM/PILOT worklist and select your options for processing the worklist.

   1. Type S to select Create Worklist. Then, press Enter.
   2. To edit the CM/PILOT worklist, type S to select Edit Worklist.
   3. To create the JCL to run the worklist, type S to select Create JCL.
   4. To review or modify the JCL, type S to select Edit JCL.
   5. To submit the JCL to run the CM/PILOT worklist, type S to select Submit JCL.
   6. Press Enter.CM/PILOT deletes the work IDs.

   Important

   An Analysis worklist is not created and is not required.