473,657 Members | 2,484 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Server Crash - Application

16 New Member
Hi,

We had a situation recently. An application connected via DB2 data server client ( Application server) to the database hung for around 9 minutes and then timed out with SQL30081N. This situation occured when the database server crashed all of a sudden ( sort fo power off situation).


Ques:

1) Can some one explain why did the application did not get back a SQL return code immediately after the server crash?

Thanks,
Panditt
Sep 15 '10 #1
2 1566
Amarnath Reddy N
11 New Member
Hi,

check whether ConnectionTimeo ut IBM Data Server Driver configuration keyword is enabled in your environment. This keyword is used Specifies the time in seconds to wait for a reply when trying to establish a connection to a server before terminating the attempt and generating a communication timeout.

Refer below link for more info:
http://publib.boulder.ibm.com/infoce.../r0054613.html

Thanks.
Amar
Sep 20 '10 #2
deshaipet
16 New Member
Thanks a lot Amar
Sep 23 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

19
14832
by: Thue Tuxen Sørensen | last post by:
Hi everybody ! I´m maintaining a large intranet (approx 10000 concurrent users) running on one IIS box and one DB box with sqlserver 2000. Currently there is 2,5 GB Ram, 1 1400 mhz cpu and 2 scsi disks installed on the db box. Sqlserver is set to use max 1,4 GB RAM, and the sqlserver does not seem to be using it all.
0
1030
by: Russell | last post by:
Hello everybody, I'm the administrator of our network and we have a problem with our Windows server 2003 standard. Recently I've installed the server on our network and promoted it to domain controller. Everything works fine. Our R&D department is developing a program that's created with c-sharp and runs in .NET (I hope my explanation is correct, because I'm not familiair with programming!)
1
1386
by: Tim Smith | last post by:
Hi, I have a system which comprises of a number of server side application and services. There is a thread per service or application and some threads may also create their own application threads. ServerApplication.exe ----------Controller Thread ---------App1 ---------App2
5
4533
by: Sam Loveridge | last post by:
Hi All. I'm hoping someone can point me in the direction of a solution to unhandled exceptions in MDI child forms causing the application to crash. I've found various articles describing a method using Application.Run(new MyMainParentForm) to place in the application's Sub Main to allow catching of unhandled exceptions in the application. The problem I'm facing is that I want to be able to trap unhandled exceptions at the MDI child...
0
1030
by: Victor Paraschiv | last post by:
Hi, I have a server that runs IIS along with a public webservice. On the same machine, on serial port, is connected an external device that controlls a process of filling some tanks with water.I have to connect to that process through the webservice. I can run on the server an application or a windowsservice to send commands to the process and get back feedback(doing this efficiently would be a realy challange). The questions is how do I...
0
1147
by: Aqib | last post by:
I am working with Client Server Desktop Application which used to run on intranet. I am facing problem of slow speed due to large data (up to 1 GB). I am using Synchronies communication method (as data is very important) and Service to transfer data (in the form of Xml) from server to client. Can you please tell me how to maximize the data transferring speed? I will be thankful to you for this favor (in advance)
0
1176
by: mandrivacsprof2030 | last post by:
Hi there. I have a problem in socket programming. I'm writing a server/client application in C#. When client connects to the server, a text-based communication between server and client. When server send "Bye" message to the client, client execs the shutdown and then close method of socket in client. When client's socket is closed, I receive an exception from server. I've written server as a windows service. If server's socket is closed,...
39
5849
by: alex | last post by:
I've converted a latin1 database I have to utf8. The process has been: # mysqldump -u root -p --default-character-set=latin1 -c --insert-ignore --skip-set-charset mydb mydb.sql # iconv -f ISO-8859-1 -t UTF-8 mydb.sql mydb_utf8.sql mysqlCREATE DATABASE mydb_utf8 CHARACTER SET utf8 COLLATE utf8_general_ci;
1
2195
by: vijayakumar | last post by:
hi all I'm beginner in CORBA Server-Client application development. My server- client application was worked well and i have tested it too. Due to some Network problem we have rebooted our dedicated server , then i restart my corba service, application in the server it started running without any exception. when the client application tried to connect with the server it go to wait_to_connect mode and gives TRANSIENT ERROR
8
2007
dmjpro
by: dmjpro | last post by:
What's the difference between Web Server and Application Server. I had an idea that Web Server only able to serve the static pages and Application Server able to serve dynamic pages. One more thing suppose i am using J2ee framework. So when a HTTP request comes to a j2ee server then how Web Server and Application server come into the play?
0
8325
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8742
jinu1996
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...
0
8621
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5643
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4173
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...
0
4330
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2743
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1971
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1734
bsmnconsultancy
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...

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.