473,385 Members | 1,317 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Application hanging

i have one procedure which contains lots of logics in it. (which is one
of the largest procedure in my application)

i have 5 application(or agent) which access this procedure.
when i am accessing a particular code in it all the applications
connected to it hangs.
ultimately it leads to the restarting of the db2 server.

i even tried putting some part of the code in to a new procedure but in
vain.
can anybody help me how to improve performance

May 18 '06 #1
3 1110
situ wrote:
i have one procedure which contains lots of logics in it. (which is one
of the largest procedure in my application)

i have 5 application(or agent) which access this procedure.
when i am accessing a particular code in it all the applications
connected to it hangs.
ultimately it leads to the restarting of the db2 server.

i even tried putting some part of the code in to a new procedure but in
vain.
can anybody help me how to improve performance

Which platform and version are you on?
My first guess would be that you either have some SQL which runs forever
or you have a dead-lock.
Take a look at SNAPSHOTs or the db2pd tool to analyze.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
May 18 '06 #2
i am working in windows xp platform
and i am using DB2 V8.1.7.445

May 18 '06 #3
hello serge,
which parameter i have to take in to consideration in get snapshot
statement
when i say list application its showing 40 applications running on the
database

May 18 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Harlan Messinger | last post by:
A publication style guide indicates that for a table heading like the following, Table 3. Wheat and rye harvest in European countries in years that end in 3 or 7 or when a new prime minister...
25
by: Shannon Jacobs | last post by:
Maybe there is a simple trick here, and I'm not spotting it... Is there a guru of CSS hanging around here who can help out? The page in question has a multi-column table with a list of links in...
0
by: Rob Rogers | last post by:
Visual Studio.Net started hanging when trying to create an ASP.NET application. The problem started after I installed "Norton Firewall". I haven't had any luck getting support from Norton. The...
0
by: kentk | last post by:
I was wondering if there is a way to detect when an api call is hanging and end it. I am working with a 3rd party API call and it will infrequently hang when I call it. I am working with the...
12
by: JohnR | last post by:
I have narrowed a problem down to a simple example. A form with two buttons. One EXIT and one FBD. The exit button does an "END" to end the application. The FBD button does a...
6
by: Wayne Smith | last post by:
Hi, We are having a few problems with ASP.Net pages hanging during load when an Application Pool is recycled. To test this we have setup the following ASP.net page which refreshes every 2...
1
by: Radesh | last post by:
Hi Guys. I have to write and display the following song using an appropriate loop. 10 green bottles Hanging on the wall And if 1 green bottle Should accidentally fall There'll be 9 green...
6
by: Adrian | last post by:
Hi there My VB Code looks something like that: ************************************************************** Dim oShellApplication = CreateObject("Shell.Application") Dim objWindow For Each...
4
by: DubSport | last post by:
I am trying to get my .net page to run a simple batch file on my IIS server. I want it to run with specified credentials. It appears to start the program cmd.exe as the correct user (shows up in...
1
by: =?iso-8859-1?q?Jean-Fran=E7ois_Michaud?= | last post by:
Hello guys, I was wondering if anybody here had implemented a solution where Tables are aligned according to what the hanging indent tells us when there is a potential for the table overflowing...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.