SQL30081N error

[dimeuleh]

I am new to DB2 but I am currently doing a small project which involves two normal windows xp workstations both using DB2 Express C.

I keep getting the SQL30081N error.

I have researched why this error is caused and have done the following to try rectify this:

1. db2stop force, db2start - db2admin stop db2admin start
2. db2set - checked for db2comm=tcpip
3. check that the svcename was set to 50000
4. db2 -v update dbm cfg using svcename 50000

I have checked that on the remote database that the port 50000 was listening:

TCP 0.0.0.0:50000 0.0.0.0:0 LISTENING

Any help appreciated. Thanks

[docdiesel]

Hi,

what exactly do you try to do when you get the SQL30081N error? Do you try to connect from WinXP_A to a database on WinXP_B ? Did you catalog the remote database on client side (=WinXP_A)?

For checking the TCP/IP connection try a "telnet WinXP_B_ip 50000" on your WinXP_A machine.

Regards


Doc Diesel

[Shashank1984]

You can have look over this technote.
SQL30081N TCPIP communication errors
IBM - SQL30081N TCPIP communication errors

Thanks,
Shashank Kharche
IBM, DB2 for Linux, Unix & Windows -Information Management Software