Work statement lists (WSLs)

A work statement list, or WSL, is a collection of one or more tasks that perform basic operations, such as creating objects, granting authorizations, and running utilities.

You can use WSLs to group and run related tasks. For example, suppose that you want to run a batch program that makes a lot of updates, schedule an image copy, and then run the RUNSTATS utility immediately afterward. In this case, you can create a WSL that includes these three tasks. You can then run the WSL online or in batch mode. If the WSL fails, you can restart it.

Although you specify which operations to include in a WSL, the WSL format is created and maintained by Db2 Admin Tool. In general, the statements in a WSL are standard statements or commands that you would normally code to perform a task.

A WSL can also be cloned with different owners and names for the objects. This capability allows you to create a WSL on one subsystem and then change or execute it on another system. For example, the following scenarios are possible:

• Local use only: Generate the WSL on subsystem DB2-1. Clone the WSL many times with different owners and names for the objects. Execute the WSL on DB2-1.
• Local customization and remote execution: Generate the WSL on subsystem DB2-1. Clone the WSL many times with different owners and names for the objects. Send the WSL to subsystem DB2-2. Execute the WSL on DB2-2.
• Remote customization and execution: Generate the WSL on subsystem DB2-1. Send the WSL to DB2-2. Clone the WSL many times with different owners and names for the objects. Execute the WSL on DB2-2.