On Tue, 2 Apr 2013 07:40:08 -0500, John Gilmore wrote:
>"A lot less cycles" here replaces a derisory number of them by an
>exiguous one. Jantje's example could be further "refined", but to
>what end?
>
Granted: in the overall total of cycles needed to build up the client
connection, validate t
At the risk of writing like an architect, let's pause to consider that the
problem might be more than a one-off problem. DB2 might be one important
ingredient in consistently delivering a particular business outcome, but
it's probably only one ingredient among several.
If the problem statement is,
John Gilmore wrote:
>"A lot less cycles" here replaces a derisory number of them by an exiguous
>one. Jantje's example could be further "refined", but to what end?
Your point is well taken.
I think the OP wants to check whether a DB2 system is available or reachable
from somewhere [1]. The o
"A lot less cycles" here replaces a derisory number of them by an
exiguous one. Jantje's example could be further "refined", but to
what end?
This sort of suboptimizing is not san appropriate use of anyone's time.
John Gilmore, Ashland, MA 01721 - USA
---
Thanks. I'm not very DB2 literate. Not that stops me from shooting off my
mouth. But I do get a number of misfires.
On Tue, Apr 2, 2013 at 5:20 AM, Jantje. wrote:
> On Mon, 1 Apr 2013 08:21:06 -0500, John McKown <
> john.archie.mck...@gmail.com> wrote:
>
> >
> >SELECT CURRENT-TIME FROM sysibm.
On Mon, 1 Apr 2013 08:21:06 -0500, John McKown
wrote:
>
>SELECT CURRENT-TIME FROM sysibm.systables
>
Make that
SELECT 1 FROM SYSIBM.SYSDUMMY1
and test for SQLCode = 0.
Uses quite a lot less cycles.
Cheers,
Jantje.
--
For I
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:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Kenneth J. Kripke
Sent: Monday, April 01, 2013 3:46 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subjec
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,
ct: [IBM-MAIN] DB2 subsystem availability
Sent by:IBM Mainframe Discussion List
Hello;
Is there a way to determine if a DB2 or any subsystem is truly
available? I know how to sweep the SSCT entries to see if they are
defined,
but,
Is there a way to see if the subsystem is tr
message on shut-down on the other.
Just some ideas.
db
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Kenneth J. Kripke
Sent: Monday, April 01, 2013 2:08 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: DB2 subsystem availability
Hello;
l Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
Behalf Of Kenneth J. Kripke
Sent: Sunday, March 31, 2013 11:08 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: DB2 subsystem availability
Hello;
Is there a way to determine if a DB2 or any subsystem is truly
avai
I'm not familiar with DB2, but to see if something is truly alive, why not
just try something innocuous? I don't know how difficult this is with DB2,
but could you use a SPFUI type program to do something like:
SELECT CURRENT-TIME FROM sysibm.systables
I don't know the name of the actual table to
rom: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
> Behalf
> > Of Kenneth J. Kripke
> > Sent: Sunday, March 31, 2013 11:08 PM
> > To: IBM-MAIN@LISTSERV.UA.EDU
> > Subject: DB2 subsystem availability
> >
> > Hello;
> >
> > Is
looking to do?
Lizette
> -Original Message-
> From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
Behalf
> Of Kenneth J. Kripke
> Sent: Sunday, March 31, 2013 11:08 PM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: DB2 subsystem availability
>
> H
Hello;
Is there a way to determine if a DB2 or any subsystem is truly
available? I know how to sweep the SSCT entries to see if they are defined,
but,
Is there a way to see if the subsystem is truly alive and can process
requests?
Kenneth J. Kripke
k.kri...@comcast.net
---
15 matches
Mail list logo
