TCP/IP port 5000/50001 question

[x***@tom.com]

1. I can connect to DB2 V8.1 and list all tables of Sample database(or others created by DB2 system after installation)using "IBM OLE DB Provider for DB2" in Microsft Visual Studio 2005 at port 50001.
2. I get an error "SYSIBM:CLI:-805 ... SQLSTATE=38553" at port 50000.
3. I can connect to DB2 V8.1 but can't list any database I created at port 50001.I get the same error as 2. at port 50000.

Any idea?
Thanks!

[m***@iipay.com]

It sounds to me like you have the database using port 50001. Nothing wrong with that. Check your services file in the database server. DB2 adds a line at the end (at least it does on Linux) with the service name and the port. If you want to change port just change the value there and restart the database manager.

As for not being able to list databases - I'd start with the clp on the database server and make sure you can see the databases there as the instance owner. If that doesn't work you should be able to catalog them. If you want to use a graphical tool and use the discovery service make sure you have discovery service switched on and no firewall in the way. If you are using a Windows client then check you are allowing the discovery service through any client firewall. Discovery uses a different port, so if in doubt switch off the client firewall for a few seconds to see if that helps. Once you have the databases cataloged on the client you can switch the firewall back on.

[n***@pbsg.com]

Kindly check whether the desirec tcp port is added to services file

Unix: Added to /etc/services
Windows : C:\WINDOWS\system32\drivers\etc\services

Hope it helps !

[Knut Stolze]

Post by n***@pbsg.com
Kindly check whether the desirec tcp port is added to services file
Unix: Added to /etc/services
Windows : C:\WINDOWS\system32\drivers\etc\services

First, verify that DB2 is started with TCPIP (db2set DB2COMM=tcpip). Then
verify what the DBM CFG parameter named "SVCENAME" is set to. If that
parameter is a number, you can completely ignore /etc/services and related.
Otherwise, the name in SVCENAME is a symbolic name that is resolved to a
specific port number using /etc/services. With that information, verify at
which port DB2 is listening.

As for the -805 error, please post the complete error message. It contains
the name of a package which could not be found and needs to be bound first.