If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Adding System in Client

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-23-10, 05:47
alwayssathya alwayssathya is offline
Registered User
 
Join Date: Aug 2010
Location: Chennai India
Posts: 161
Wink Adding System in Client

hi i have installed db2 client in my Xp system.

i want to add the system and the databases.
i tried using CA and when searching for the known system....
my server is not been shown and all my databases are in cloud on top of my server...

help me as how to add the system and database.

thanks in advance.
Reply With Quote
  #2 (permalink)  
Old 08-23-10, 09:11
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
You will need the following info:
  • ip address or host name of server
  • Port number of DB2 instance
  • database name on server
  • database name you want to use on the client (alias) if different

Then refer to the Command Reference Manual for the following commands:
  • catalog tcpip node
  • catalog database
You could also do this manually with the CA (instead of using discover).
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #3 (permalink)  
Old 08-24-10, 05:52
alwayssathya alwayssathya is offline
Registered User
 
Join Date: Aug 2010
Location: Chennai India
Posts: 161
Thumbs down

thanks

i have my server Ip say in 192.0.0 network
and my cloud Ip is 10.20... network where the DB2 is installed

when i give system name / Ip of the cloud it is not recognizing

if i give the Hostname and that ask for the service name... i don know how to find the service name ...

it is throwing an error as displayed
Attached Images
File Type: bmp client error.bmp (438.8 KB, 7 views)
Reply With Quote
  #4 (permalink)  
Old 08-24-10, 09:22
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
Ask someone who is a DBA for that remote database what the service name or port number is for that DB2 instance. This information can be found by logging on to the database server as the instance owner and typing the following command:

db2 get dbm cfg

TCP/IP Service name (SVCENAME) = 50000

If it is a number, then it is a port number, or if alphanumeric it is a service name resolved in /etc/services (or windows equivilent for windows based servers).

The default port number is 50000 in most cases (if you can't get someone to help you and want to guess).

If you cannot log on to the server as instance owner, try looking in the /etc/services file for the port number (should be near the bottom).
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On