473,379 Members | 1,544 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,379 software developers and data experts.

Server Crash - Application

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 1551
Hi,

check whether ConnectionTimeout 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
Thanks a lot Amar
Sep 23 '10 #3

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

Similar topics

19
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...
0
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...
1
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...
5
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...
0
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...
0
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...
0
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...
39
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...
1
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...
8
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...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
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: 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
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

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.