Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

db2 how to connect to remote database from my

Posted on 2014-12-28
3
Medium Priority
?
434 Views
Last Modified: 2014-12-28
Hi, how to  define the remote connection in my local db2 instance running on mac, I want to connect to  a db2 database running on port 5000 on some IP address. On my local mac I have db2 instance running, and db2 prompt
0
Comment
Question by:sniger
  • 2
3 Comments
 
LVL 46

Expert Comment

by:Kent Olsen
ID: 40520626
Hi sniger,

From the DB2 command line processor, use the CATALOG TCPIP NODE and the CATALOG DATABASE commands

  CATALOG TCPIP NODE nodename REMOTE {hostname | IP address} SERVER 50000
  CATALOG DATABASE dbname [as localname] AT NODE {nodename}

Good Luck!
Kent
0
 

Author Comment

by:sniger
ID: 40520781
So, I don't need connect command ?

How to SQL then dbname ?
0
 
LVL 46

Accepted Solution

by:
Kent Olsen earned 2000 total points
ID: 40520837
You do need the CONNECT command.  The 2 CATALOG statements (shown above) identify the server and database to your local client.  This is a 1-time thing.  The client stores the information locally so you can continue to connect to that database until you UNCATALOG it.

You then execute

  CONNECT TO localname

every time that you want to create a connection.

Good Luck!
Kent
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Integration Management Part 2
Suggested Courses

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question