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

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

book

Article ID: 264615

calendar_today

Updated On:

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