pp108 : RemovePSL

RemovePSL
This topic describes the command used to remove inactive Publish Source Layers.
Caution

Running the RemovePSL tool removes the inactive Publish Source Layers (PSLs) from the system and consequently improves the migration performance. The process of identifying PSLs eligible for removal involves querying various database tables that might contain several records, for example, PROCESS_INSTANCE table. Running the tool during business hours severely impacts performance. Therefore, ensure this tool is run only during non-business hours.

A PSL is used to graphically view business process models after deployment and enables process administrators to graphically monitor and debug the execution of instances of these business process models. To align with the versioning capabilities on business process models, every package contains a unique PSL and does not overwrite the PSLs of others versions of the same package or other packages.

For general instructions on how to use CWS command-line tools, see  Using the CWS Command-line Tools . You must also ensure the following:

  • The appropriate database driver must be added to the classpath of the Collaborative Workspace Service Container, for example, sqljdbc.jar for MSSQL Server.
  • The user executing the tool must have read and write permissions on the <Process Platform installation directory>.

You can use the  RemovePSL  command as follows:

cws RemovePSL

This command removes the inactive PSLs based on the parameters provided.

Parameters

The following parameters are used to determine the behavior of the RemovePSL command.

 -execute (-x)                  : To enable removal of the inactive PSLs from the computer.
 -history (-h) <number of days> : To specify the period of inactivity on an inactive PSL to be eligible for removal.
 -verbose (-v)                  : To enable verbose logging and provide more information on the timings.

For example, to remove inactive PSLs with no activity for 10 days or more, use the following command in a Windows environment.

 <Process Platform installation directory>\bin>cws RemovePSL -x -h 10

Note: 

A PSL is active with respect to a Business Process Model if one of the following conditions are true.

The deployed business process model referring to the PSL is:

  • still active.
  • inactive but active process instances exist for the given business process model revision.
  • inactive and only completed or terminated process instances exist for the given business process model revision (older than what is shown in the history window).

A PSL is active with respect to a Decision Table if one of the following conditions are true.

The deployed decision table referring to the PSL is:

  • still active.
  • inactive but active process instances exist in the decision table.
  • inactive and only completed or terminated process instances exist in the decision table (older than what is shown in the history window).

In all other cases, the PSLs are considered to be inactive and qualified for deletion.

When the history window displays and the PSLs are deleted, you cannot open the graphical view of the process instances available outside the history window. However, you can still work with the text or grid view in the Process Instance Manager (PIM).