473,385 Members | 1,642 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.

DB2 CAF DISCONNECT and re-CONNECT

Hi,

According to Application Programming and SQL Guide chapter 29:

"If DB2 terminates, a task that issued CONNECT must issue DISCONNECT
to reset the CAF control blocks. The function returns the reset
accomplished return codes
and reason codes (+004 and X'00C10824'), and ensures that future
connection requests from the task work when DB2 is back on line."

My CAF batch application issues CONNECT and works fine.
When STOP DB2 command is entered, my tecb (terminate ecb) is posted,
and I do a DISCONNECT.
Instead of the above retcode & reason code (4 & 824) I get a retcode=0
& reason code=0.
When checking with DISPLAY THREAD(*) I see my application's connection
to DB2 is still active.

Is it a bug of DB2 or am I doing something wrong?

I have also noticed that in the code example, at the end of chapter
29, when QUIESCE mode is found, nothing is done!?
It looks like a wrong behavior.
I thought that when STOP DB2 command is set, my CAF application should
DISCONNECT, to allow DB2 termination to be completed.
Then, when DB2 is up again, I shall do CONNECT again.

Please advise.
Avner
Nov 12 '05 #1
0 2719

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

Similar topics

1
by: codecraig | last post by:
Hi, If I create a connection to a and XML-RPC server, how can the client disconnect from the server? CLIENT: url = "http://1.1.1.1:1234" server = xmlrpclib.Server(url) server.doSomething()
6
by: Toralf Kirsten | last post by:
Hi, we are using db2 8.1 on Linux. I'd like to close all open connection at a defined time point. Therfore I wrote a sql script including the command disconnect all or release all
1
by: bl181076 | last post by:
Hello, In our organization we have 4 different access applications (all owned by different people) which use the same backend (owned by me). When the backend gets corrupt I have to disconnect...
0
by: Sateesh | last post by:
Hello, I am mapping to a network share from a .Net service to transfer some specified directories and some times before I disconnect the drive, network would become unavailable. I am unable to...
3
by: HABJAN ®iga | last post by:
Is there a way to be notifyed (callback, event,...) when the connection of socket was closed... The WinSock activex in vb6 had event ondisconnect... I get exception when i try to send some data,...
3
by: JR | last post by:
Hi, Any idees how to disconnect some usb devices Jan
3
by: xincmu | last post by:
I built a very basic server-client in C#. When my server disconnects from the client, the socket at the server is already disconnected, but the socket the client remains open. I used the sample...
0
by: meromake | last post by:
My question about ADO disconnect mode I wanna use SQL Statement (INSERT INTO,UPDATE,DELETE,SELECT) with ADO Disconnect Mode Who can I do it? Thanks
0
by: =?Utf-8?B?SnVsaWFu?= | last post by:
I have an application written in vb.net (VS2005) running on a Windows Mobile 6 device. It uses the GPRS (GSM Data bearer) for its comms back to the server. The comms are a standard connection...
9
by: Kelii | last post by:
Currently I have a button that allows the user to "Close Company" - at the moment it doesn't do anything :D I would like the button to "disconnect" the back end then show my Open Company form. ...
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: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
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: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
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.