Results 1 to 6 of 6

Thread: Linux DB2 Host

  1. #1
    Join Date
    Jun 2008
    Posts
    5

    Unanswered: Linux DB2 Host

    What is the default host and port for DB2 9 Express-c?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The default port is 50000. The host is the TCP/IP host name of the server where DB2 is installed (assuming you are using a TCP/IP connection), so I don't think you can say there is a default.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jun 2008
    Posts
    5
    Can i use localhost? My operating system is Ubuntu hardy heron, does this OS use TCP/IP?

  4. #4
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Quote Originally Posted by the_transltr
    Can i use localhost? My operating system is Ubuntu hardy heron, does this OS use TCP/IP?
    Yes, it uses TCP/IP. And yes, for a local connection you can use the "localhost" host name, or the IP address 127.0.0.1, or any name you have given to your system in the /etc/hosts file.
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    for a local connection, why would we need tcpip. you can catalog the node with local instance, no need to go through tcpip..
    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

  6. #6
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You can and you want to use TCP/IP via a loopback connection on localhost if you are developing, for example, and want to stay as close as possible to production/customer environments where no local connection via IPC mechanisms is used.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •