| Author |
Message
|
| joicedony |
 Posted: Mon Feb 04, 2013 5:01 am Post subject: Database Access on WMB 8.0 |
 |
|
Newbie
Joined: 31 May 2010
Posts: 8
|
Team,
Currently i am using WMB V6. Now i am moving to WMB V8, whereas facing some issues on basic Databse operation, Message Set execution using workflows.
So request anyone to support on this and share some information on this.
It will be great/appreciated if you have any docuements.
Regards,
Joice.V |
|
| Back to top |
|
 |
| zpat |
| Posted: Mon Feb 04, 2013 5:42 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
Yes, IBM have provided WMB v8 documentation.
If you have a problem, you need to be more specific - stating "some issues" is utterly unhelpful. |
|
| Back to top |
|
|
| joicedony |
| Posted: Mon Feb 04, 2013 5:48 am Post subject: |
|
|
Newbie
Joined: 31 May 2010
Posts: 8
|
Thanks for your reply,
I am facing the following error.
Description Resource Path Location Type
Unresolvable database table reference "Database.DB2ADMIN.TEST_EMP". Databse_Ins_Upd_Compute.esql /DB_INS_UPD line 24 ESQL Loading Failure of Referenced File
.
Here is the query i am using,
SET queueName =THE(SELECT ITEM A.CHANNEL_ID FROM Database.db2admin.TBL_TXN_UBP AS A
WHERE A.SERVICE_TYPE = service_type
AND A.TRAN_REF = tran_ref);
Please provide your support. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Feb 04, 2013 5:57 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| joicedony wrote: |
Thanks for your reply,
I am facing the following error.
Description Resource Path Location Type
Unresolvable database table reference "Database.DB2ADMIN.TEST_EMP". Databse_Ins_Upd_Compute.esql /DB_INS_UPD line 24 ESQL Loading Failure of Referenced File
.
Here is the query i am using,
SET queueName =THE(SELECT ITEM A.CHANNEL_ID FROM Database.db2admin.TBL_TXN_UBP AS A
WHERE A.SERVICE_TYPE = service_type
AND A.TRAN_REF = tran_ref);
Please provide your support. |
Did you happen to read the documentation? Or, attend the required training class?
There you will learn how to configure your database connection and test it.
http://publib.boulder.ibm.com/infocenter/wmbhelp/v8r0m0/index.jsp?topic=%2Fcom.ibm.etools.mft.doc%2Fan07235_.htm
We don't "provide our support" to people who choose not to read or attend.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| NealM |
| Posted: Mon Feb 04, 2013 8:17 am Post subject: |
|
|
Master
Joined: 22 Feb 2011
Posts: 230
Location: NC or Utah (depends)
|
Read up on the mqsicvp command's three forms, try it out starting with the 3rd form and see if you have your ODBC connections set up properly.
And most likely next you will need to read about the mqsisetdbparms command....
(update) Oops. Sorry for being redundant. |
|
| Back to top |
|
|
| amitkarma |
| Posted: Sun Feb 17, 2013 10:15 pm Post subject: Database connectivity issue |
|
|
Novice
Joined: 17 Feb 2013
Posts: 10
|
Is MS Access database compatible with WMB 8v ???
Last edited by amitkarma on Sun Feb 17, 2013 10:50 pm; edited 1 time in total |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Sun Feb 17, 2013 10:37 pm Post subject: Re: Database connectivity issue |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| amitkarma wrote: |
| Is MS Access databese compatible with WMB 8v ??? |
What does the Documentation say?
If you don't like the answer then feel free to raise a RFP.
_________________
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 |
|
|
| JosephBCT |
| Posted: Tue Feb 26, 2013 1:40 am Post subject: |
|
|
Novice
Joined: 07 Feb 2013
Posts: 23
|
Now its working fine. Due to my DB2 database, i am not able to connect. After resolved the DB2 issues now its fine.
Thanks for all your comments. |
|
| Back to top |
|
|
| mayheminMQ |
| Posted: Tue Feb 26, 2013 8:46 am Post subject: |
|
|
Voyager
Joined: 04 Sep 2012
Posts: 77
Location: UK beyond the meadows of RocknRoll
|
So did you do anything different or was the documentation provided by IBM sufficient?
Would like to know how you got around the problem, if there was one.
_________________
A Colorblind man may appear disadvantaged but he always sees more than just colors... |
|
| Back to top |
|
|
| JosephBCT |
| Posted: Tue Feb 26, 2013 10:02 pm Post subject: |
|
|
Novice
Joined: 07 Feb 2013
Posts: 23
|
Difference is, checked the DB2 Schema, previledges for the DB User as well as the Services of the WMB and DB2.
Once Sync all the ablove my DB issues are solved. |
|
| Back to top |
|
|
|
|
