Hi,
DB2 7.1 FP11
Windows 2000
Earlier this evening, after dropping and recreating a trigger, DB2 locked
up. I am not entirely sure that the cause of the problem was the replacing
of the trigger, but all of a sudden no users were able to connect to our
customers database. After running db2dart I found numerous corrupted indexes
which I removed using "db2dart MYDB /IM". Finally I was able to get a
connect to work, although the connect does take very long to actually
connect (~1 minute), so I think there is some sort of timeout issue involved
as well.
Our main problem is the fact that remote users are still not able to connect
to the DB. We use named pipes to connect the clients to the server, but when
connecting, we get the following error message:
SQL1287N ATTACH für Exemplar "NPIP0000" ist fehlgeschlagen, da die benannte
Pipe "\\ZHBDBS04\pip e\db2\DB2_0.cnt " nicht gefunden wurde
or in English
SQL1287N ATTACH to instance "NPIP0000" failed, as the named pipe
"\\ZHBDBS04\pip e\db2\DB2_0.cnt " could not be found
I am neither able to connect locally using named pipes, nor remotely.
Does anyone know how I can reinitialize the DB2 named pipes support?
Will a re-install of the software help, or will I still have the same
problem afer re-installation?
Regards
Rudolf Bargholz 2 2715
Rudolf Bargholz wrote: Hi,
DB2 7.1 FP11 Windows 2000
Earlier this evening, after dropping and recreating a trigger, DB2 locked up. I am not entirely sure that the cause of the problem was the replacing of the trigger, but all of a sudden no users were able to connect to our customers database. After running db2dart I found numerous corrupted indexes which I removed using "db2dart MYDB /IM". Finally I was able to get a connect to work, although the connect does take very long to actually connect (~1 minute), so I think there is some sort of timeout issue involved as well.
Our main problem is the fact that remote users are still not able to connect to the DB. We use named pipes to connect the clients to the server, but when connecting, we get the following error message:
SQL1287N ATTACH für Exemplar "NPIP0000" ist fehlgeschlagen, da die benannte Pipe "\\ZHBDBS04\pip e\db2\DB2_0.cnt " nicht gefunden wurde
or in English
SQL1287N ATTACH to instance "NPIP0000" failed, as the named pipe "\\ZHBDBS04\pip e\db2\DB2_0.cnt " could not be found
I am neither able to connect locally using named pipes, nor remotely.
Does anyone know how I can reinitialize the DB2 named pipes support? Will a re-install of the software help, or will I still have the same problem afer re-installation?
I don't have a solution, but I'm 99.999% sure that the trigger had
nothing to do with it.
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Hi Serge, I don't have a solution, but I'm 99.999% sure that the trigger had nothing to do with it.
After reinstalling DB2 7.1, FP3, and then FP11, reattaching the databases,
named pipes worked again, although the installation as usual did not work
out of the box, with the usual errors
<============== ==>
Error during installation: C:\PROGRA~1\SQL LIB\bin\iwh2reg i.exe 10 DWCTRLDB
DWCTRLDB NULL 1252 EN : -1032.
<============== ==>
Error during installation: C:\PROGRA~1\SQL LIB\BIN\IWH2REG I.EXE 12 DWCTRLDB
IWH db2admin ******** C:\PROGRA~1\SQL LIB\LOGGING C:\PROGRA~1\SQL LIB : 2009.
<============== ==>
Only after installing FP11 did the error no longer occur, and I had to
install in english as german did not work any more (same errors as above).
At least our customer was able to go back online at six in the morning. And
I was able to go offline ....
Regards
Rudolf Bargholz This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Matt W |
last post by:
Hi all,
I just noticed this in the manual yesterday:
http://www.mysql.com/doc/en/Windows_running.html
"MySQL supports TCP/IP on all Windows platforms. The mysqld-nt and
mysql-max-nt servers support named pipes on NT, 2000, and XP. The default is
to use TCP/IP regardless of the platform, because named pipes are actually
*slower* than TCP/IP ..."
|
by: glenn.owens |
last post by:
In the process of doing some routine monitoring/clean-up we've
discovered that several (many?) users are apparently set to access our
SQL Server 2000 database instances via the Named Pipes protocol. In
readings and recommendations we've decided that our WAN would be best
served if we use the less "chatty" TCP/IP.
As such we've also decided to try to enforce this decision to use
TCP/IP exclusively using the domain login script used by all...
|
by: Ken Allen |
last post by:
Is there any built-in facility for handling named pipes in C#/.Net, or must
one use unsafe code to access the WIN32 API directly?
There exists some code that uses named pipes heavily and there exists a need
for that code to send some information to a new .Net service I am writing.
It is a relatively simple matter for the existing code to use a named pipe
to send the data, but I can find no references to how I can create the named
pipe...
|
by: Jarrod Morrison |
last post by:
Hi All
Im looking for a way use named pipes between a service app and an app run
when a user logs on and be able to pass string based data, im hoping that
the service can contact the app that is running in the user session and tell
it a path of an app to launch as the logged on user. Does anybody know of an
easy way to do this or have any examples i could look at ? Any help is
greatly appreciated
Many thanks
|
by: Jarrod Morrison |
last post by:
Hello all
Ive been trying to get a service app that i run to interact with the logged
on user of the machine and so far havent been very successfull and have read
that maybe named pipes is the way to go. Im hoping someone has some
information and easy to understand examples on named pipes. Basically i need
my service app to signal a user app thats running and send basic text to it.
Any help is greatly appreciated
Thanks
| |
by: Rochester |
last post by:
Hi,
I just found out that the general open file mechanism doesn't work
for named pipes (fifo). Say I wrote something like this and it
simply hangs python:
#!/usr/bin/python
import os
|
by: fahad.usman |
last post by:
I am making an application in which if the second instance of the same
application is launched, it checks its command-line arguments and
passes them to the already running instance. I have been told by
someone that using named pipes is one of the most commonly used ways
of doing this. But I did it in a simpler way; I saved the command-line
arguments in a text file and passed a message to the previously
running instance to read the...
|
by: dgk |
last post by:
I trying to use a named pipe but can't figure out how to get the
callback to work:
Module Module1
Private ps As System.IO.Pipes.NamedPipeServerStream
Public Sub main()
Application.EnableVisualStyles()
Try
ps = New System.IO.Pipes.NamedPipeServerStream("Test")
ps.BeginWaitForConnection(AddressOf HandleConnection, "Test")
|
by: andrewb |
last post by:
Hi all,
Having some trouble using named pipes and Visual Basic .NET and would
appreciate and help you could offer.
Essentially I am trying to develop a simple client/server application
that exchanges text messages using named pipes. The internet resources
seem a bit scarce and the only Microsoft resource I can find is
http://support.microsoft.com/kb/871044.
|
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: 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,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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: 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: 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
| |
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...
| |