| Author |
Message
|
| Harshalw |
 Posted: Mon Sep 08, 2008 9:28 pm Post subject: How to create a data source name for db2 on AIX |
 |
|
Voyager
Joined: 23 Jul 2008
Posts: 77
|
Hi,
I am working on wmb 6.1 on AIX. I know how to create a db2 database connection on windows. However on AIX how do i do that ?
For WMB 6.1 we dont have odbc.ini also. I know the database name.
Can i specify databse name in data source property of compute node and give mqsisetdbparms cmd on AIX with the same database name ?
Please let me know this soon.
Thanks
Harshal. |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Mon Sep 08, 2008 10:40 pm Post subject: Re: How to create a data source name for db2 on AIX |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi Harshalw,
| Harshalw wrote: |
| For WMB 6.1 we dont have odbc.ini also. I know the database name. |
We don't have an odbc.ini ? odbc.ini is more a database file and not WMB...
Try doing a CREATE CATALOG from the Db2 cmd, that should add it in the correct location.
And also check the '.profile' in the home directory, the file location could be there.
Regards. |
|
| Back to top |
|
|
| Harshalw |
| Posted: Tue Sep 09, 2008 12:39 am Post subject: |
|
|
Voyager
Joined: 23 Jul 2008
Posts: 77
|
yes got it..
I made some change in odbc.ini
#######################################
#### List of data sources stanza ######
#######################################
[ODBC Data Sources]
DB2V8DB=IBM DB2 version 8 ODBC Driver
###########################################
###### Individual data source stanzas #####
###########################################
# DB2 version 8 stanza
[DB2V8DB]
Driver=<Your DB2 v8 install directory>/lib/libdb2.a
Description=DB2V8DB DB2 ODBC Database
Database=PPRDSHAD
what will be the mqsisetdbparams -
mqsisetdbparms Mqsi_Broker -n pprdshad -u pads -p duff1beer
or
mqsisetdbparms Mqsi_Broker -n DB2V8DB -u pads -p duff1beer |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Tue Sep 09, 2008 1:03 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi Harshalw,
The ODBC Datasource in Windows and the ini file on Unix are for creating the actual datasource for a database...WMB has nothing to do with that.
The mqsisetdbparms is only to provide the userId password for connecting to a datasource.
I think from the above, you should be able to figure out which of your commands is correct...sorry, I could tell you directly, but then you wouldn't learn 
Regards |
|
| Back to top |
|
|
| Harshalw |
| Posted: Tue Sep 09, 2008 8:37 am Post subject: |
|
|
Voyager
Joined: 23 Jul 2008
Posts: 77
|
|
| Back to top |
|
|
|
|
