472,958 Members | 1,583 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,958 software developers and data experts.

Named Pipes Problem

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\pipe\db2\DB2_0.cnt" nicht gefunden wurde

or in English

SQL1287N ATTACH to instance "NPIP0000" failed, as the named pipe
"\\ZHBDBS04\pipe\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
Nov 12 '05 #1
2 2643
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\pipe\db2\DB2_0.cnt" nicht gefunden wurde

or in English

SQL1287N ATTACH to instance "NPIP0000" failed, as the named pipe
"\\ZHBDBS04\pipe\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
Nov 12 '05 #2
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\SQLLIB\bin\iwh2regi.exe 10 DWCTRLDB
DWCTRLDB NULL 1252 EN : -1032.
<================>
Error during installation: C:\PROGRA~1\SQLLIB\BIN\IWH2REGI.EXE 12 DWCTRLDB
IWH db2admin ******** C:\PROGRA~1\SQLLIB\LOGGING C:\PROGRA~1\SQLLIB : 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
Nov 12 '05 #3

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

Similar topics

0
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...
5
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...
4
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...
1
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...
1
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...
14
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
2
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...
1
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()...
7
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...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
2
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

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.