Scenario: Creating a job definition and submitting to a dynamic pool

In this scenario, you define the requirements for running the job when creating the dynamic pool, for example you can include in the dynamic pool all workstations with Windows operating system and DB2 installed and maximum CPU utilization at 50%. The dynamic pool is then populated with the workstations which match your requirements and is ready for the job to be submitted.

1. Log in to the Dynamic Workload Console.
2. From the navigation toolbar, click Administration > Workload Environment Design > Create Workstations.
3. Select an engine and click OK.
4. The Workstation Properties page is displayed.
5. Select Dynamic Pool in the Workstation type menu.
6. Complete the required fields.
7. Click Edit Requirements. The Requirements page is displayed.
8. Specify the following requirements:
   • Select the operating system in the Operating System pane.
   • Select the CPU utilization in the CPU utilization pane.
   • Select the required logical resource in the Logical Resources pane. To include workstations with DB2 installed, click Add and specify your requirement in the Requirements pane.
   • Optionally, select the required optimization policy.
9. Click OK to save your requirements.
10. Click Save to save the dynamic pool.
11. From the navigation toolbar, click Administration > Workload Design > Manage Workload Definitions
12. Specify an engine name, either distributed or z/OS®. The Workload Designer opens. Job types and characteristics vary depending on whether you select a distributed or a z/OS engine.
13. Select New > Job Definition > Database and Integrations > Database.
14. Complete the required fields and specify the dynamic pool you previously created in the Workstation field.
15. Type your SQL instructions in the SQL tab.
16. Click Save to save the job.
17. From the navigation toolbar, click Administration > Workload Submission > Submit Predefined Jobs.