• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 533
  • Last Modified:

DB2 Drivers Windows Server - Database port number

We are trying to install DB2 Drivers on a windows server but are being asked for the database port number. Where would I find the port number?
0
IT SSM
Asked:
IT SSM
1 Solution
 
giltjrCommented:
That will be on the DB2 server, its the TCP ports that it is listening on.
0
 
Kent OlsenData Warehouse Architect / DBACommented:
Hi OST-IS,

Most of the DB2 parameters that you'll care about can be found with these two commands:

db2>  get dbm cfg
db2>  get db cfg

In this case, the parameter that you want is returned by the first command.  It will look something like this:

 TCP/IP Service name                          (SVCENAME) = db2c_DB2

The value will be the port number as is defined in the etc/services file, or the absolute port number.

Until you get the DB2 command line processor set up on your desktop, that will have to be run on the server side.


Good Luck,
Kent
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now