SQL Error

[bhoomi]

I am trying to connect DB2 Version 9 to Brio, but i am getting an SQL Error:

sqlcode: -1336

sqlstate: 08001

Can somebody help me to rectify this. Also please suggest the steps to follow if someone knows about this.

Thank You.

Bhoomi

[r035198x]

Just Google those codes to find out what they mean.

[Shashank1984]

Mate,
Here is the Explanation and User Response for this error.
Make sure you know this and go through the response.

C:\Documents and Settings\Admini strator>db2 ? sql1336n

SQL1336N The remote host "<hostname> " was not found.

Explanation:
The system cannot resolve the address of the remote host.
Possible causes are:

o An incorrect hostname value was specified when the TCP/IP
node was cataloged.
o The correct hostname was specified, but was not defined in
any TCP/IP name server accessible to your client node, nor in
the client's hosts file.
o The TCP/IP name server where the hostname was defined was not
available at the time you tried to connect.
o TCP/IP is not running.
o The remote host was cataloged on this client using the
CATALOG TCPIP6 NODE command. However, the remote host does
not support IPv6.

User Response:

Make sure that TCP/IP is running and that the hostname specified
when cataloging the TCP/IP node is a correct name, and that it is
defined in an accessible name server or in the local hosts
file.

If the remote host was cataloged on this client using the
CATALOG TCPIP6 NODE command but the remote host does not support
IPv6, then perform the following steps: (1) Use the UNCATALOG
command and (2) recatalog using the CATALOG TCPIP NODE command.

Federated system users: verify that the remote host is cataloged
correctly in the SYSCAT.SERVERS view.

sqlcode : -1336
sqlstate : 08001
=============== =========

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