Remote database

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • wdelacruz
    New Member
    • Mar 2008
    • 1
    #1

    Remote database

    Hi..
    I have a server in which exists a db2(8.1.2) database, and i'm installing a software in other server in the same net that connects with this database, but it doesn't connect with the db2 database.
    I guess that this happens because the db2 database is no set to be a remote database. If this is the problem...how could i enable the remote functionality in the db2 database?

    Thanks in advance...
    Tags: None
    • docdiesel
      Recognized Expert Contributor
      • Aug 2007
      • 297
      #2
      Hi,

      what OS are you using on the DB2 server? Window$, AIX or Linux? The easiest test you could do is open a shell or command line window on the client (where your application is running) and try a
      Code:
      telnet address.of.your.server  port.of.db2
      where address.of.your .server may be the DNS name or the IP address and port.of.db2 is the TCP port you gave DB2 for hosting during the installation process. If telnet is getting no conection, your DB2 server isn't setup correctly.

      Check the DB2 variables then, especially the variable DB2COMM. It should be "tcpip". Have a look at the cfg of your instance. The setting for db2svcename should be a name that's to be found in /etc/services or an integer value, usually 50000.

      Regards,

      Bernd

        Comment

        Previous template Next
        Working...