Hi David,
There can be many reasons for that reason code. The -30081 is a general
connection failure. The reason code can be sometimes more helpful but a
lot of times not very helpful.
We have run into this combination error and return code several times every
time for a different reason
1. There was a TCPIP error when the failover process was set up. Some db2
files were missing.
2. Another time we failed to use the proper dsn name for a remote server
3. Another time we had the wrong port number in the catalog node statement
.
4. Another time DB2COMM=TCPIP was missing when we issued the db2set -all
command
5.Another time we had an error in the SVCENAME in the dbm cfg.
Hope one of these helps you. If you find another problem let me know so I
can document for our shop.
Thanks,
Frank Crissy
Chief Systems Engineer
Data Base Administration
The Home Depot
11953
"Davage, Marcus"
<[EMAIL PROTECTED] To: "'DB2EUG (E-mail)'" <[EMAIL
PROTECTED]>, "DB2-L (E-mail)"
sTSB.co.uk> <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: [DB2EUG] 7.2 - 8.1 DB
migration problem
.org
03/22/2004 09:37 AM
Please respond to
"Davage, Marcus"
Fixpak 3 I think.
Just logged onto the IBM website to download fixpak 4 to get the following
error message:
V8 displayfixpaktable: The query returned error: -30081
[IBM][CLI Driver] SQL30081N A communication error has been detected.
Communication protocol being used: "TCP/IP". Communication API being used:
"SOCKETS". Location where the error was detected: "". Communication
function detecting the error: "connect". Protocol specific error code(s):
"79", "*", "*". SQLSTATE=08001
V8 displayfixpaktable: The query returned error: -99999
[IBM][CLI Driver] SQL30081N A communication error has been detected.
Communication protocol being used: "TCP/IP". Communication API being used:
"SOCKETS". Location where the error was detected: "". Communication
function detecting the error: "connect". Protocol specific error code(s):
"79", "*", "*". SQLSTATE=08001 [IBM][CLI Driver] CLI0106E Connection is
closed. SQLSTATE=08003
Anyone from IBM watching?
Marcus
---------------------------------------------------------------------------------------------------------------
This e-mail is intended only for the above addressee. It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it. If you have
received it in error please delete it and immediately notify the sender.
evolvebank.com is a division of Lloyds TSB Bank plc.
Lloyds TSB Bank plc, 25 Gresham Street, London, EC2V 7HN. Registered in
England, number 2065. Telephone No: 020 7626 1500
Lloyds TSB Scotland plc, Henry Duncan House, 120 George Street,
Edinburgh EH2 4LH. Registered in Scotland, number 95237. Telephone
No: 0131 225 4555
Lloyds TSB Bank plc and Lloyds TSB Scotland plc are authorised and
regulated by the Financial Services Authority and represent only the
Scottish Widows and Lloyds TSB Marketing Group for life assurance,
pensions and investment business.
Signatories to the Banking Codes.
---------------------------------------------------------------------------------------------------------------
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
