| Author |
Message
|
| kumar.MBMQ |
 Posted: Tue Dec 17, 2013 4:56 am Post subject: BIP8272W: Data source specified is not associated with brkr |
 |
|
Voyager
Joined: 06 May 2011
Posts: 93
|
when I am running the command mqsicvp Broker1 -n oracledb on windows os above error is popping up.
DSN name is oracledb and working on MB8.003.
I am not sure ,
i gave below command it executes correctly
mqsisetdbparms Broker1 -n odbc::oracledb -u SYSTEM
-p bank12345.
plz suggest |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Tue Dec 17, 2013 5:40 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20768
Location: LI,NY
|
What is the content of the broker's odbc file. Is oracledb defined there? 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Dec 17, 2013 5:45 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| fjb_saper wrote: |
| What is the content of the broker's odbc file. Is oracledb defined there? |
It's windows. There is no ODBC "file".
kumar.MBMQ - you have not issued an mqsisetdbparms for the DSN. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Dec 17, 2013 6:05 am Post subject: Re: BIP8272W: Data source specified is not associated with b |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20768
Location: LI,NY
|
| kumar.MBMQ wrote: |
i gave below command it executes correctly
mqsisetdbparms Broker1 -n odbc::oracledb -u SYSTEM -p bank12345.
plz suggest |
Have you tried issuing the command without odbc:: ?
| Code: |
| mqsisetdbparms Broker1 -n oracledb -u SYSTEM -p bank12345 |
Is your DSN name oracledb ?
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| kumar.MBMQ |
| Posted: Tue Dec 17, 2013 6:35 am Post subject: |
|
|
Voyager
Joined: 06 May 2011
Posts: 93
|
mqsisetdbparms Broker1 -n oracledb -u SYSTEM -p bank12345
this is working .
thanks, |
|
| Back to top |
|
|
| kumar.MBMQ |
| Posted: Tue Dec 17, 2013 7:08 am Post subject: |
|
|
Voyager
Joined: 06 May 2011
Posts: 93
|
In my flow i have mqinput _>compute-> mqout . in compute node I have :
CALL CopyEntireMessage();
PASSTHRU 'CREATE TABLE xe1.Customers (
CustomerNumber INTEGER,
FirstName VARCHAR(256),
LastName VARCHAR(256),
Street VARCHAR(256),
City VARCHAR(256),
Country VARCHAR(256)
)' TO Database.oracledb;
where oracledb is the dsn on windows os and xe1 is the oracle connection, Customers is the table name I want to create. but I am getting warning
unresolvable dataase table reference. can I ignore this ? but the table is not created even in db . |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Tue Dec 17, 2013 7:41 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
You really should not be creating a table from within a broker flow.
Why can't you create the table using any of the ORacle tools available?
Remember you need special privs on oracle to create a table. These are different to those needed to insert/delete/update.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| kumar.MBMQ |
| Posted: Tue Dec 17, 2013 8:55 am Post subject: |
|
|
Voyager
Joined: 06 May 2011
Posts: 93
|
i am checking the simple connectivity between broker and database.
but I am getting warning
unresolvable dataase table reference. can I ignore this ? but the table is not created even in db . |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Tue Dec 17, 2013 9:36 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| kumar.MBMQ wrote: |
\
but I am getting warning
unresolvable dataase table reference. can I ignore this ? but the table is not created even in db . |
Is this at runtime or in the Toolkit?
As the DB is oracle WHY oh WHY are you not doing a select on the 'DUAL' table if all you want to do is check connectivity?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
|
|
