How to Issue EXCMGR in batch IDB2 across multiple Db2 members

Products

• SYSVIEW Performance Management Option for DB2 for z/OS
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Insight Performance Monitor for DB2 UDB for z/OS
• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Recovery Suite
• Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

Thread Termination Process is implemented with the following overall cycle if an issue is encountered with the need to change the IQL
to allow for the Exception to the current rules. Understanding is that the overall cycle is:

1. Stop IQL
2. Change IQL
3. Start IQL
4. Recycle exception monitor

The understanding is that step 2 only has to be performed once since the IQL is being picked up from a shared dataset, but steps 1, 3, and 4 have to
be performed for each Db2 member. Is there a way to issue the commands in steps 1, 3, and 4 in batch job that can coded ahead of time to
reduce our overall response time?

Resolution

Use IUIBATCH to STOP and START requests and the restart of the Exception System. Assuming the situation here is that an IQL exception was
coded with criteria for cancellation. There maybe a need to deploy multiple jobs UNLESS all of the Data Collectors are accessible via RAF.
Then this can be  done in one batch just by changing the APPLS value on the STOP and START commands.

Please see the following link for an example:
Batch User Interface (UI)