| Author |
Message
|
| EricL |
 Posted: Fri Jan 05, 2018 1:35 pm Post subject: storage after mqsisetdbparms commands |
 |
|
Centurion
Joined: 10 Oct 2014
Posts: 102
|
Hi,
As we know, command "mqsisetdbparms" is used in IIB to setup different types of external connections, like ldap, odbc etc, e.g:
mqsisetdbparms <INodeName> -n ldap::ldaptest
mqsisetdbparms <INodeName> -n odbc::USERDB2
...
My question is, after these commands executed, where is the data stored?
How to check all existing settings on the node created by "mqsisetdbparms" issued before?
Thanks in advance !
Eric |
|
| Back to top |
|
 |
| mpong |
| Posted: Fri Jan 05, 2018 2:12 pm Post subject: |
|
|
Disciple
Joined: 22 Jan 2010
Posts: 164
|
/var/mqsi/registry/BROKER_NAME/CurrentVersion/DSN
or
mqsireportdbparms BROKER_NAME -n dsn::xxxx -p yyyy |
|
| Back to top |
|
|
| EricL |
| Posted: Fri Jan 05, 2018 7:43 pm Post subject: |
|
|
Centurion
Joined: 10 Oct 2014
Posts: 102
|
Thanks for your reply....
Think path /var/mqsi/registry/BROKER_NAME/CurrentVersion/DSN is on unix platform, any idea corresponding path on windows?
Further more, any idea how to remove some of the existing settings? |
|
| Back to top |
|
|
| EricL |
| Posted: Sat Jan 06, 2018 6:57 am Post subject: |
|
|
Centurion
Joined: 10 Oct 2014
Posts: 102
|
On windows, corresponding path is:
C:\ProgramData\IBM\MQSI\registry\IIBNODE1\CurrentVersion\DSN |
|
| Back to top |
|
|
| gbaddeley |
| Posted: Sun Jan 07, 2018 2:19 pm Post subject: |
|
|
Jedi Knight
Joined: 25 Mar 2003
Posts: 2538
Location: Melbourne, Australia
|
Its better to use the 'report' command to retrieve this information. Unless its documented, IBM can move and change the internal storage format at any time without informing you.
_________________
Glenn |
|
| Back to top |
|
|
| abhi_thri |
| Posted: Mon Jan 08, 2018 12:29 am Post subject: |
|
|
Knight
Joined: 17 Jul 2017
Posts: 516
Location: UK
|
| EricL wrote: |
Thanks for your reply....
Think path /var/mqsi/registry/BROKER_NAME/CurrentVersion/DSN is on unix platform, any idea corresponding path on windows?
Further more, any idea how to remove some of the existing settings? |
Hi, You can delete existing entries using the same command but with the delete flag,
mqsisetdbparms <integrationNodeName> -n <resource> -d [-f] |
|
| Back to top |
|
|
| zpat |
| Posted: Mon Jan 08, 2018 12:45 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
| gbaddeley wrote: |
| Its better to use the 'report' command to retrieve this information. Unless its documented, IBM can move and change the internal storage format at any time without informing you. |
The report command is relatively new (I think I raised an RFE to have the feature added).
_________________
Well, I don't think there is any question about it. It can only be attributable to human error. This sort of thing has cropped up before, and it has always been due to human error. |
|
| Back to top |
|
|
|
|
