It occurred to me to add to my previous comment: For batch applications, you might have some console automation response to the DSN9022I message stating"DSNYASCP 'START DB2' NORMAL COMPLETION" on one hand and the DSNY002I message on shut-down on the other. You would use the response to activate/deactivate a Scheduling Environment and refer to it in your batch JCL.
-----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Kenneth J. Kripke Sent: Monday, April 01, 2013 3:46 PM To: [email protected] Subject: Re: DB2 subsystem availability Thank you to all that have responded. What I am attempting to accomplish. I wish to perform a pre-emptive check on the availability of a DB2 subsystem on another sysplex prior to shipping a batch job over to that Plex. Yes, I could code a small SQL QUERY and check for the SQLCODE returned, but, I wanted to know how something like MSI can show that a subsystem is defined, but, is not active. Special Thanks to Wayne Driscoll. I will test this out, but, it looks like the solution I am seeking. Ken Kripke ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
