| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| in the odbc64.ini, for remote db2, where are the serverName? |
« View previous topic :: View next topic » |
| Author |
Message
|
| thomaszheng |
 Posted: Wed Mar 08, 2006 10:48 am Post subject: in the odbc64.ini, for remote db2, where are the serverName? |
 |
|
Acolyte
Joined: 01 Mar 2006
Posts: 62
|
Hi,
Where the database host name(Ip address) and port number are specified for DB2 remote database in the odbc64.ini file like the flowing:
Solaris
[ODBC Data Sources]
WBRKBKDB=IBM DB2 ODBC Driver
MYDB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 5.0 64bit Oracle Wire Protocol
SYBASEDB=DataDirect 5.0 64bit Sybase Wire Protocol
[WBRKBKDB]
Driver=libdb2Wrapper64.so
Description=WBRKBKDB DB2 ODBC Database
Database=WBRKBKDB
[MYDB]
Driver=libdb2Wrapper64.so
Description=MYDB DB2 ODBC Database
Database=MYDB
[ORACLEDB]
Driver=<Your installation directory>/DD64/lib/UKor820.so
Description=DataDirect 5.0 Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName
SID=<Your Oracle SID>
CatalogOptions=0
ProcedureRetResults=1
EnableStaticCursorForLongData=0
ApplicationUsingThreads=1
ServerName=<YourServerName>
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
[SYBASEDB]
Driver=<Your installation directory>/DD64/lib/UKase20.so
Description=DataDirect 5.0 Sybase Wire Protocol
Database=<sybasedb>
ServerName=<YourServerName>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<YourServerName,YourPortNumber>
SelectUserName=1
[ODBC]
Trace=0
TraceFile=<A Directory with plenty of free space>/odbctrace.out
TraceDll=<Your installation directory>/DD64/lib/odbctrac.so
InstallDir=<Your installation directory>/DD64
UseCursorLib=0
IANAAppCodePage=4 |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Mar 08, 2006 11:32 am Post subject: Re: in the odbc64.ini, for remote db2, where are the serverN |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| thomaszheng wrote: |
Hi,
Where the database host name(Ip address) and port number are specified for DB2 remote database in the odbc64.ini file like the flowing: |
They aren't.
They are specified in the DB2 node catalog.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| thomaszheng |
| Posted: Wed Mar 08, 2006 11:36 am Post subject: |
|
|
Acolyte
Joined: 01 Mar 2006
Posts: 62
|
| how about the data source used by broker itself, not node? |
|
| Back to top |
|
|
| vk |
| Posted: Wed Mar 08, 2006 12:36 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
The odbcini only needs a stanza for each database that the broker should connect to. In the stanza, we need to give only the database alias name.
The actual database name, IP address and port number are given in the db2 CATALOG NODE and CATALOG DATABASE commands.
Regards,
VK. |
|
| Back to top |
|
|
| thomaszheng |
| Posted: Thu Mar 09, 2006 12:59 am Post subject: |
|
|
Acolyte
Joined: 01 Mar 2006
Posts: 62
|
Thanks!!
for tcpip, just run the "CATALOG TCPIP NODE" on the client machine is enough"?
best
thomas zheng |
|
| Back to top |
|
|
| vk |
| Posted: Thu Mar 09, 2006 5:06 am Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
CATALOG TCPIP NODE will catalog the server hosting the remote database
After this command, you have to run CATALOG DATABASE command specifying the node name in the above command, to catalog the remote database at this node.
Regards,
VK. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
