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.
-
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:
|
-
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:
|
-
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.
-
Select the versions to be deleted:
-
To select all the versions, type a.
-
To select versions between two sequence numbers, type n.
-
Type d to logically delete the selected versions of the templates.
-
Type x in this menu and in the following menu to return to the main
menu.
-
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:
|
-
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.
|