On Tue, 2 Apr 2013 07:40:08 -0500, John Gilmore jwgli...@gmail.com 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,
On Mon, 1 Apr 2013 08:21:06 -0500, John McKown john.archie.mck...@gmail.com
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.
Thanks. I'm not very DB2 literate. Not that stops me from shooting off my
mouth. But I do get a number of misfires. grin/
On Tue, Apr 2, 2013 at 5:20 AM, Jantje. jan.moeyers...@gfi.be wrote:
On Mon, 1 Apr 2013 08:21:06 -0500, John McKown
john.archie.mck...@gmail.com wrote:
SELECT
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
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 only
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
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
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
Hello;
Is there a way
@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
available? I know
how to sweep the SSCT entries
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
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
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
Subject: Re: DB2 subsystem
12 matches
Mail list logo