Hello,
Sometime, clients disconnect after starting sql and sql keep running
in the db2 engine making it a runaway sql.
is there something in DB2 which can avoid this behavior i.e. clean any
agents/subagents/sqls when client is no longer connected ?
4  2561 
On 4 Nov, 18:10, db2admin <jag...@gmail.c omwrote:
Hello,
Sometime, clients disconnect after starting sql and sql keep running
in the db2 engine making it a runaway sql.
is there something in DB2 which can avoid this behavior i.e. clean any
agents/subagents/sqls when client is no longer connected ?
I’m not sure if SET CLIENT command can help you; see following link: http://publib.boulder.ibm.com/infoce.../r0001999.html
Regards
Salvatore Vacca
On Nov 4, 12:37*pm, Salvatore Vacca <s.va...@gmail. comwrote:
On 4 Nov, 18:10, db2admin <jag...@gmail.c omwrote:
Hello,
Sometime, clients disconnect after starting sql and sql keep running
in the db2 engine making it a runaway sql.
is there something in DB2 which can avoid this behavior i.e. clean any
agents/subagents/sqls when client is no longer connected ?
I’m not sure if SET CLIENT command can help you; see following link:
http://publib.boulder.ibm.com/infoce...dex.jsp?topic=....
Regards
Salvatore Vacca
thankyou,
i am going to look into that
i also noticed this DB2CHECKCLIENTI NTERVAL parameter
is this something which can also help to clean runaway sql ?
Hi!
Will you please publish the results if you succeed!
Thanks
/dg
"db2admin" <ja****@gmail.c omwrote in message news:55******** *************** ***********@f37 g2000pri.google groups.com...
Hello,
Sometime, clients disconnect after starting sql and sql keep running
in the db2 engine making it a runaway sql.
is there something in DB2 which can avoid this behavior i.e. clean any
agents/subagents/sqls when client is no longer connected ?
On 5 Nov, 18:14, db2admin <jag...@gmail.c omwrote:
On Nov 4, 12:37*pm, Salvatore Vacca <s.va...@gmail. comwrote:
On 4 Nov, 18:10, db2admin <jag...@gmail.c omwrote:
Hello,
Sometime, clients disconnect after starting sql and sql keep running
in the db2 engine making it a runaway sql.
is there something in DB2 which can avoid this behavior i.e. clean any
agents/subagents/sqls when client is no longer connected ?
I’m not sure if SET CLIENT command can help you; see following link:
http://publib.boulder.ibm.com/infoce...dex.jsp?topic=....
Regards
Salvatore Vacca
thankyou,
i am going to look into that
i also noticed this DB2CHECKCLIENTI NTERVAL parameter
is this something which can also help to clean runaway sql ?
It depends on which version of db2 are you using; as you can see from
documentation the default value of DB2CHECKCLIENTI NTERVAL is 50 for
version >= 8.1.4, prior to version 8.1.4, the default value was 0 (no
client connection verifications is performed). http://publib.boulder.ibm.com/infoce.../r0005660.html This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: David Hane |
last post by:
Hi all,
I would like give users the ability to experiment with complex queries but
I'm worried about them creating queries that will bog down the server.
Does anyone have any ideas for preventing a runaway process?
I'd like to empower my users AND keep my server online :-)
Thanks!
|
by: Tom Kitta |
last post by:
Hello,
I am administering a DB which is about 2GB in size and sees few hundred,
maybe up to a few thousand inserts a day plus very few deletions and updates
(less than few hundred). DB has about 200,000 records in it total. For some
time now I have noticed that the transaction logs grow a lot -- like 1GB per
day. I don't know why they are growing so much and would like to find out
why - DB usage that I know of cannot cause such a high...
|
by: aj |
last post by:
Red Hat Linus AS 2.1
DB2 WSE 8.1 FP5
I am using the following JVM for my java UDF's:
java version "1.3.1"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1)
Classic VM (build 1.3.1, J2RE 1.3.1 IBM build cxia32131-20020302 (JIT
enabled: jitc))
|
by: Thomas W Ping |
last post by:
Putting focus in a form element like a dropdown box and using the mouse
wheel - even one click forward or backward with it - cycles through
every record, in that direction, until first or last record is reached.
MSKB has a VB workaround for making Access unresponsive to the mouse
wheel, but I don't need to prevent that -- just the *runaway* cycling.
Any ideas? I've not seen this behavior in any other applications.
Logitech USB optical...
|
by: Matthew Groch |
last post by:
Hi all,
I've got a server that handles a relatively high number of concurrent
transactions (on the magnitude of 1000's per second). Client
applications establish socket connections with the server. Data is
sent and received over these connections using the asynchronous model.
The server is currently in beta testing. Sporadically over the course
of the day, I'll observe the thread count on the process (via perfmon)
start climbing....
| | |
by: shahbazc |
last post by:
Hi All,
I'm rather new to asp.net, currently I am experimenting with .NET 2.0.
I have a fairly large number of reports which have everything in common
except the sql, report heading and perhaps a caption or two.
Now, I'm wondering what's the best way I can keep my sqls in, perhaps a
seperate xml file or a database table. As you can imagine, this will
work amazingly well if I could somehow combine site maps with this
templated...
|
by: splatt |
last post by:
I'm getting this error on my program and don't know what's the problem?
syntax error at testing5 line 38, near "chomp($choice=<STDIN>);"
(Might be a runaway multi-line )) string starting on line 37)
Here is the code:
line34 until ($choice == q) {print "What would you like to convert?\n\n"};
line35 chomp($choice=<STDIN>);
|
by: Jason |
last post by:
Hello,
I am testing a complex J2EE application on WebSphere and UDB V8.2.3.
Because of the compliexity of the application, we have to run it a few
hours to finish all test scenarios.
One of our test objectives is to identify the top 100 most expensive
SQLs (based on CPU time, the total executive time, and the number of
executions). So I am trying different DB2 monitoring tools, but I can't
get the SQLs that I want. Here is what I...
|
by: aj |
last post by:
Microsoft SQL Server 2005 - 9.00.3054.00 (X64)
(Build 3790: Service Pack 2)
Last Friday we had a situation where the DNS system inside
our Active Directory server went weird. I know this isn't
a DNS or AD NG, but please bear with me...
The DNS server didn't really stop working - it was just taking
a looooooonnnggggg time to service requests. During this, the SQL
server (SQLS) engine had lots of (mostly jdbc) connections to web
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
