erik.jans...@ing.nl
-Oorspronkelijk bericht-
Van: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] Namens Ted
MacNEIL
Verzonden: maandag 21 juni 2010 20:19
Aan: IBM-MAIN@BAMA.UA.EDU
Onderwerp: Re: Enclaves hung up
imit the query with the DB2 resource limiter.
That, as a capacity
That fully depends on the nature of the query. In our case we allow the users
to use wildcards, but if they go overboard on that we could have some very
long running queries
On the otherhand, who makes the decision that it's overboard?
You? Or, the people who are ensuring you continue to get a
Ward, Mike S
[mw...@ssfcu.org]
Verzonden: vrijdag 18 juni 2010 16:46
Aan: IBM-MAIN@BAMA.UA.EDU
Onderwerp: Enclaves hung up
Hello, all. I have a problem that we are working on and it seems to no
avail. We have a distributed application that uses DB/2 on the MF and
DB/2 connect to get
imit the query with the DB2 resource limiter.
That, as a capacity analyst, is a huge waste of resources.
If the user needs the query toi run, and you terminate it before it's done,
then the user will have no choice to run it again.
If you terminate and the user needs it, and so on...
If this is
Hello, all. I have a problem that we are working on and it seems to no
avail. We have a distributed application that uses DB/2 on the MF and
DB/2 connect to get to the mainframe. We are on z/os V1.7 currently
migrating to V1.11 with DB/2 at V7 with no plan to migrate because of
the application on
DB2 has a default deadlock timeout which rolls back deadly embraces after
the timeout expires (DROLLBACK(YES)). Most DB2 systems have this turned on,
including yours most likely, or nothing would ever get done.
However, when DB2 CONNECT triggers a CICS Distributed Program Link (DPL)
mirror
One thing we do to protect our system from runaway distributed DB2 queries
is to make sure the WLM service class for possibly-ill-behaved queries has
two periods with the final period set to Discretionary. That way, we have a
chance of logging on and dealing with an ill-behaved thread without too
-Original Message-
From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On
Behalf Of Ward, Mike S
Sent: Friday, June 18, 2010 10:46 AM
To: IBM-MAIN@bama.ua.edu
Subject: Enclaves hung up
Hello, all. I have a problem that we are working on and it seems to no
avail. We have
: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On
Behalf Of Ward, Mike S
Sent: Friday, June 18, 2010 10:46 AM
To: IBM-MAIN@bama.ua.edu
Subject: Enclaves hung up
Hello, all. I have a problem that we are working on and it seems to no
avail. We have a distributed application
9 matches
Mail list logo