Address SQL UPDATE with SYSPLEX parameter / How to update RDB tables in all systems of a SYSPLEX

Products

• OPS/MVS Event Management & Automation

Issue/Introduction

I'm writing a rule to update the STCTBL and I'd like it to be issued to the SYSPLEX and not just the local system.   

Below is the code that will execute on the local system:

 ADDRESS SQL "UPDATE STCTBL",               
             "SET DESIRED_STATE = 'DOWN'",  
             "WHERE JOBNAME = 'CA11'"   

Environment

Release : 14.0

Resolution

In this case, just add the keyword SYSPLEX in addition to SYSTEM(ALL):

ADDRESS SQL "UPDATE STCTBL",               
             "SET DESIRED_STATE = 'DOWN'",  
             "WHERE JOBNAME = 'CA11'",
              "SYSTEM(ALL) SYSPLEX"

From documentation:

SYSPLEX
(Optional) Reduces the scope of the SYSTEM(ALL|EXT) operand to MSF connected systems that belong to the same z/OS sysplex as the command issuer. The keyword has no effect on a list of explicit system names.

ADDRESS SQL Statements