I am getting SQL30081N error while connecting to the database from an URL. I am using DB2 version 9.5 in UNIX AIX server...
I am able to connect to the database in UNIX AIX server and I am seeing no problem in connecting ti the database in UNIX terminal. But developers sayin tat tey could not access the database thro an URL. I checked the following things from DB side:
1. db2COMM registry variable is set to TCPIP
2. correct port no is assigend.
$db2 get dbm cfg | grep -i svce
$more /etc/services | grep -i db2ckeuaapl1
The port no is also assigned correctly.
3. The database manager is running.
4. netstat -an | grep 60136 >> The port is Listening only...
I still could not figure about what the problem is. Please help me how to resolve this error? Do i need to check anything more in DB side apart from the above things?
Hi Thanks for the response. I tried the following command:
telnet hostname port_no.... but it is neither fetchin results nor errors... I did not get any reulst output in the screen... wat does it mean? Does it mean that it is unalbe to connect to the server using the port??
no - db2 is not serving a telnet appl
if no error - means you can connect to the port (so db2 is listening)
there is another problem
has this worked before or new installation ?
do you have a regular client somewhere ? try to catalog the db and connect
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be