How to stop a situation on z/OS without using TEP portal?

Use the below SQL to stop the situation with and without recycling the Tivoli Enterprise Monitoring Server (TEMS)

SQL 1 : Doesn't require recycling the TEMS but the situation will start again when you recycle the TEMS if the "Run at startup" option is set

1. Create a member named SITSTOP (or any member) in RKANSQLU dataset and cut and paste the following SQL

INSERT INTO O4SRV.TOBJACCL (NODEL, OBJCLASS, OBJECTLOCK, OBJNAME, OPERATION, QIBCLASSID )
VALUES('TEMS_NODEID','5140',' ','sit-name','T','5625');

where TEMS_NODEID is the CMS_NODEID looks like "L2623SYG:CMS" and sit-name is the name of the situation name and it is case sensitive

2. Run the SQL

/F tems_name,CTDS START SPUFIL SITUPDT
/F <tems_task>,FLUSH


SQL 2: Requires TEMS recycle

Execute the below SQL to stop the situation and recycle the TEMS

UPDATE O4SRV.TSITDESC
SET AUTOSTART = "*NO"
WHERE SITNAME='Sit_name';

The below SQL can be used to stop the policy

UPDATE O4SRV.TPCYDESC
SET AUTOSTART = "*NO"
WHERE PCYNAME='Policy_name';

Note : All the above SQLs can be used to stop the situation/policy on other platforms too