Hi,
can anybody tell me what the reason code 18 means in combination with
a SQL0902 error?
It would be helpful to know details about the reason code but I could
not find any details about that code.
Here is the full error message (out of a DataStage job)
E_STG_CRM_PROFI LE..xfm3: [IBM][CLI Driver] SQL0902C A system error
(reason code = "18") occurred. Subsequent SQL statements cannot be
processed. SQLSTATE=58005
[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:
"10.21.16.5 8". Communication function detecting the error: "recv".
Protocol specific error code(s): "10055", "*", "*". SQLSTATE=08001
SQLFetch: Error retrieving results from server.
Thanks in advance
Michael
2  10429 
On Nov 5, 8:31 pm, globomike <M_Tiefenbac... @gmx.dewrote:
Hi,
can anybody tell me what the reason code 18 means in combination with
a SQL0902 error?
It would be helpful to know details about the reason code but I could
not find any details about that code.
Here is the full error message (out of a DataStage job)
E_STG_CRM_PROFI LE..xfm3: [IBM][CLI Driver] SQL0902C A system error
(reason code = "18") occurred. Subsequent SQL statements cannot be
processed. SQLSTATE=58005
[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:
"10.21.16.5 8". Communication function detecting the error: "recv".
Protocol specific error code(s): "10055", "*", "*". SQLSTATE=08001
SQLFetch: Error retrieving results from server.
Thanks in advance
Michael
Hi,
check the service configured with SVCE_NAME in dbm cfg. Seems that
client couldn't connect to the specified port
globomike wrote:
Hi,
can anybody tell me what the reason code 18 means in combination with
a SQL0902 error?
It would be helpful to know details about the reason code but I could
not find any details about that code.
The SQL0902C message usually implies bad things have happened in the DB.
For the system error specifics (rc=18), you have to check your platform.
(Windows, AIX, Solaris, etc.) Most POSIX compliant platforms ie. AIX
(/usr/include/sys/errno.h) show 18 mapped to EXDEV.
>
[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:
"10.21.16.5 8". Communication function detecting the error: "recv".
In many cases the -902 will result in DB2 marking the DB as "Bad".
All further (re)connections to the DB will be refused, as a precaution
to avoid propagating possibly corrupt data. So the SQL30081N sometimes
can cause confusion about what's really wrong.
Best to check in the DB2 notification log for database marked bad msgs.
Also examine the db2diag.log file for more detailed info around the time
when the SQL0902 error first occurred. You may be able to narrow the
scope by which function was executing when the error happened.
Eric This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Cem Louis |
last post by:
Hi,
I want to get each line of e-mail accounts from my txt file and put
them in an array after checking the syntax.
I made a few tries but can't accomplish on that here is my text file
look like:
mails.txt
|
by: Nitin |
last post by:
i dont know , what's the reson of this, but if i complile my solution in
release mode , it works , but give buid error in Debug mode -- "Unexpected
error creating debug information file .pdb". Project is on .net 1.0
framework. Error came after i installed framework 2.0 from net. but now i
uninstalled it. but facing same problem , i have also tried repair from
VS.net setup, pls tell me if anyone get solution of this..
|
by: Peter Oliphant |
last post by:
For some reson my code is generating a LNK1215 error, which 'suggests' I
re-install VS C++. So I did. which did NOT solve the problem. The weid part
is it seems to be caused by my one CPP file, but not sure how. It compiled
just fine. Then I made a simple change and re-compiled, and got the 1215
error. After that I have to bring back in an old version of the code to make
it work again (not fun)...
This seems like a REAL LINKER error, not...
|
by: Brian Farnhill (MCP VB.NET) |
last post by:
Hi,
I am having some trouble using the MailMessage object to send an email with
more than one attachment.
I am working on a web based application where a user can submit information,
along with a number of files. The information, including the file is stored
in the database, and an email is sent with the information and any files that
were submitted are attached. The system works fine when a user makes a
submission that has no...
|
by: Woody Splawn |
last post by:
I have a try catch statement in a fucntion that is supposed to return a true
or a false
My code looks like this:
Try
mySqlConnection.Open()
Dim Da1 As New SqlDataAdapter("Select JnlType, Description from
JnlType", mySqlConnection)
Dim Ds As New DataSet("X")
| | |
by: Mr Newbie |
last post by:
I am often in the situation where I want to act on the result of a function,
but a simple boolean is not enough. For example, I may have a function
called
isAuthorised ( User, Action ) as ?????
OK, this function may return a boolean, and if this is true, then no message
back is really required, but if it fails then some supporting message needs
to be returned to the calling code. As I see it there are a few options.
|
by: Tony Johansson |
last post by:
Hello!
Why does not this cause a compile error because a ulong has never been
implicitly convertible to byte?
ulong vektor = {100000,200000,300000};
foreach(byte b in vektor)
{
Console.WriteLine("i={0}", b);
}
|
by: Amzul |
last post by:
hello all agian,
i feel like i am asking to many qustion. :\
i have a problam and i cant think of any sulotion for it.
in my script i declare few GLOBAL VARIBLAS but the function dont know them
////global vars//////
var txbox1=20;
var txbox2=30;
|
by: pitjpz |
last post by:
We have moved our Database to another server. The server it was on used SQL 4 and the new one its on now uses SQL5
the only problem we can find is that when you attempt to delete a record from the DB the following happens:
When Deleting a record:
Fatal Error:
Can't call method "fetchrow_arrayref" on an undefined value at GT::SQL::File::delete_records line 275.
Stack Trace:
GT::Base (2704): main::fatal called at...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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();...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
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...
| |
