ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to Issue EXCMGR in batch IDB2 across multiple db2 members?

book

Article ID: 196532

calendar_today

Updated On:

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: it is my understanding 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,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?

Environment

Release : 20.0

Component : CA Insight Database Performance Monitor for DB for z/OS

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 DC's 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)