| Author |
Message
|
| iamhappy |
 Posted: Wed Nov 09, 2011 5:01 am Post subject: mqsi |
 |
|
Novice
Joined: 15 Sep 2011
Posts: 16
|
i am using mqsi since 1 year whenever i use database in my application.but now i want to know what is the exact reason to use mqsi commands before running any application.  |
|
| Back to top |
|
 |
| vmcgloin |
| Posted: Wed Nov 09, 2011 5:50 am Post subject: |
|
|
Knight
Joined: 04 Apr 2002
Posts: 560
Location: Scotland
|
Please be more specific about your question. Referring to specific documentation you have read & do not understand might help us to know what you are asking.  |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Nov 09, 2011 2:53 pm Post subject: Re: mqsi |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| iamhappy wrote: |
| i want to know what is the exact reason to use mqsi commands before running any application. |
You must source the mqsi profile before running any WMB runtime commands, since the mqsi profile sets up environment-specific parameters for your operating platform.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| iamhappy |
| Posted: Wed Nov 09, 2011 9:38 pm Post subject: |
|
|
Novice
Joined: 15 Sep 2011
Posts: 16
|
I was getting following errors :
1..."( TestBroker.default ) Database error: SQL State ''08001''; Native Error Code '-30082'; Error Text ''[IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001 ''.
The error has the following diagnostic information: SQL State ''08001'' SQL Native Error Code '-30082' SQL Error Text ''[IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001 ''"
2..."( TestBroker.default ) Database error: ODBC return code '-1' from data source ''EMPLOYEE''.
The broker received an error when executing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database about this error.
Use the following messages to determine the cause of the error. Typical causes are incorrect data source or table names. Correct either the database or the broker configuration. "
When i set mqsi commands (mqsicreateconfigurableservice ,mqsichangeproperties,mqsisetdbparms )then i get no errors and it runs sucessfully
so i wanted to know more about mqsi because there is no explanation in redbooks or anywhere on google about "WHY" |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Nov 09, 2011 9:53 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| iamhappy wrote: |
....
The broker received an error when executing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database about this error.
Use the following messages to determine the cause of the error. Typical causes are incorrect data source or table names. Correct either the database or the broker configuration.[/b] "
When i set mqsi commands (mqsicreateconfigurableservice ,mqsichangeproperties,mqsisetdbparms )then i get no errors and it runs sucessfully
so i wanted to know more about mqsi because there is no explanation in redbooks or anywhere on google about "WHY" |
Now this is a correctly asked question.
Why does it work this way?.... Well because a lot of people have thought about it and have architected it this way...
mqsisetdbparms allows you to set user and password for multiple databases... This gives you more flexibility than just giving the broker user authorizations in all DBs. You could as such have 2 different DSN going to the same DB with a different user and different permissions....
Setting up a configurable service allows you to change targets between environments....
It's all been done with the intention to allow you to deploy across environments without changing code but keeping the environment specificities separate.
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
