WebSphere MQ Workflow
Process Template Deletion Tool - Quick Reference

Note: This document must be printed in landscape format!

Currrently, you can only logically delete process templates but not physically remove them from the run-time database. For example, if you delete templates from your template list in the Runtime client, they are no longer available to the Runtime client but they are not physically removed from the database. These logically deleted process templates waste space in your database and can impact performance.

You can use the Process Template Deletion Tool (PTDT) to physically remove logically deleted process templates from the run-time database. The PTDT can be used with MQ Workflow Version 3.5.0. The tool runs on all of the supported platforms.

Starting the PTDT

You can find general installation instructions in the installation instructions for the MQ Workflow database tools.

You can use the following command to start the PTDT from the command prompt:
java com.ibm.workflow.util.dbTools.PTDT [Options]

The options are:

        -u <username>           MQ Workflow user with database administrator rights
        -p <password>           password of MQ Workflow user
        -q <customization HLQ>  MQ Workflow Customization HLQ (z/OS only)
        -y <configuration id>   MQ Workflow configuration ID
        -l <DB2 location>       location name of the DB2 subsystem (optional)(z/OS only)
        -s <DB2 schema>         DB2 system group object qualifier (z/OS only)

The tool prompts you for values if you do not specify them in the command line. The DB2 location name is optional and will not be prompted if you specify command line parameters.

Using the PTDT

The main menu

If your log-on information is correct, the main menu isdisplayed:

              -------------------MAIN-MENU---------------------            
              | (l)  --> List all active process templates    |
              | (f)  --> List deleted process templates       |
              | (r)  --> Remove deleted process templates     |
              | (x)  --> Exit                                 |
              -------------------------------------------------

To carry out an action, type the corresponding letter on the command line and press Enter:

  • To see all active process templates, type l
  • To list the templates that are logically deleted, type f
  • To physically remove templates that are logically deleted, type r
  • To exit the tool, type x

Example: Removing process templates from the database

You can remove templates from the database only if you have you logically deleted them first. This example describes how to select a set of templates, logically delete them, and then remove them from the database.

  1. From the main menu, type l to list the active process templates.
    The list of templates is displayed and the following submenu is shown:

                MARK  NAME
    ---------------------------------

    0.( ) CreditRequest
    1.( ) GDCCreditRequest
    2.( ) GDCNestedBlockCR
    3.( ) Hotel booking
    ----------------------------------------------------
    | (r) --> Reduce list of active process templates |
    | (l) --> Show versions of selected templates |
    | (x) --> Exit |
    ----------------------------------------------------

    Your choice:

  2. To reduce the list of active templates, type r.

    You are prompted for a selection pattern. You can use '?' or '_' as wildcards for a single character and '*' or '%' as wildcards for multiple characters. You can mark a template for deletion by typing its number in the command line. After you have marked a template, an updated list similar to the following is shown:


                MARK  NAME
    ---------------------------------
    0.( ) CreditRequest
    1.( ) GDCCreditRequest
    2.( ) GDCNestedBlockCR
    3.(X) Hotel booking
    ----------------------------------------------------
    | (r) --> Reduce list of active process templates |
    | (l) --> Show versions of selected templates |
    | (x) --> Exit |
    ----------------------------------------------------

    Your choice:
  3. To list the versions of the marked templates, type l.

    Version means that the templates are differentiated by the VALID_FROM date. This date is either specified when the template is created or it is the date and time the template was imported into Runtime.

                MARK  NAME              VALID_FROM 
    ---------------------------------------------------

    0.( ) Hotel booking 2003-02-06 14:52:17.996
    1.( ) Hotel booking 2003-02-11 13:20:07.136
    2.( ) Hotel booking 2003-02-11 13:32:37.715

    ------------------------------------------------
    | (n) --> Select versions between two numbers |
    | (a) --> Select all versions |
    | (u) --> Unselect all versions |
    | (d) --> Delete selected versions of |
    | process templates |
    | (x) --> Exit |
    ------------------------------------------------

    Your choice:

    The version list shows all the versions of the process templates you selected in step 2.

  4. Select the versions to be deleted:
    • To select all the versions, type a.
    • To select versions between two sequence numbers, type n.
  5. Type d to logically delete the selected versions of the templates.
  6. Type x in this menu and in the following menu to return to the main menu.
  7. In the main menu, type f to list all the logically deleted templates:
                MARK  NAME
    ---------------------------------
    0.(X) Credit Request
    1.(X) Hotel booking
    ----------------------------------------------
    | (c) --> Remove deleted process templates |
    | (x) --> Exit |
    ----------------------------------------------

    Your choice:
  8. Type r to remove all the logically deleted process templates from the database.

    You will be prompted if some lists or queries use a specific template within a filter. If a query or a filter explicitly uses the global container of a template you will also be notified. These templates cannot be deleted until the query which uses the global container is changed. This also happens if you try to remove a template that has an active process instance.

You can also remove logically deleted templates without listing these templates first. You can do this directly from the main menu by typing r.

 

Subheadings






     (Back to the top)