ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WMQI access to user datatables on z/OS

Post new topic  Reply to topic
 WMQI access to user datatables on z/OS « View previous topic :: View next topic » 
Author Message
barbara812
PostPosted: Thu Apr 24, 2003 6:22 am    Post subject: WMQI access to user datatables on z/OS Reply with quote

Newbie

Joined: 09 Jan 2003
Posts: 6
Location: Germany

Hi there,
I try to access a user datatable from a database node on z/OS (WMQI 2.1, CSD03) and get the following error message in the usertrace:

2003-04-24 10:02:45.203824 13 DatabaseException BIP2322E: Database error: SQL State '42705'; Native Error Code '-950'; Error Text '{DB2 for OS/390}{ODBC Driver}
DSNT408I SQLCODE = -950, ERROR: THE LOCATION NAME SPECIFIED IN THE CONNECT STATEMENT IS INVALID OR NOT LISTED IN THE COMMUNICATIONS DATABASE DSNT418I SQLSTATE = 42705 SQLSTATE RETURN CODE

The datatables are in the same database as the broker tables itself.
Other message flows on z/OS, which don't access databases, have been successfully tested. The specific message flow with the database access has successfully been tested on NT.

Is there an entry missing anywhere for the DB2 database on z/OS?
What's the name of the "data source", I have to reference in the database node: the db2 subsystem or the database name?

Thanks for any help,

Barbara
Back to top
View user's profile Send private message
migstr
PostPosted: Thu Apr 24, 2003 7:40 am    Post subject: Reply with quote

Apprentice

Joined: 05 Jun 2002
Posts: 34
Location: New York

Hi,
Make sure your datasource is your DB2 Subsystem name. This has happened to me when testing with NT broker/database then moving to 390 broker/database, if I forget to change data source.
I posted a reply similar : http://www.mqseries.net/phpBB2/viewtopic.php?t=8507
_________________
Thanks, Margaret
-------------------------------------------------------
IBM Certified Specialist - MQSeries, Websphere MQ Integrator
IBM Certified Solutions Expert - MQSeries, Websphere MQ Integrator
IBM Certified Developer - MQSeries
Back to top
View user's profile Send private message
barbara812
PostPosted: Thu Apr 24, 2003 8:25 am    Post subject: Reply with quote

Newbie

Joined: 09 Jan 2003
Posts: 6
Location: Germany

Thanks, Margaret.

I had already changed the data source name to the DB2 subsystem on z/OS when the problem occured.

How does WMQI determine the correct database name, as only data source and data table names are mentioned in the message flow. Which configuration parameter determines the database?

Thanks,

Barbara
Back to top
View user's profile Send private message
migstr
PostPosted: Thu Apr 24, 2003 9:16 am    Post subject: Reply with quote

Apprentice

Joined: 05 Jun 2002
Posts: 34
Location: New York

Hi,
Database name does not come into play on 390 WMQI Broker/DB2.
Is it possible that your DB2_LOCATION is not the same as your DB2_SUBSYSTEM name? Sometimes I think of these as the same and they are really not. We have DB2_SUBSYSTEM A which has many DB2_LOCATIONs A1 ,A2, A3
So really we use the DB2_LOCATION in DATASOURCE; at least this is how we have it set up.
Also, check your odbc ini file on USS to see how it is set up with subsystem and datasources. You can also run an ODBC trace from there by setting APPLTRACE=1
_________________
Thanks, Margaret
-------------------------------------------------------
IBM Certified Specialist - MQSeries, Websphere MQ Integrator
IBM Certified Solutions Expert - MQSeries, Websphere MQ Integrator
IBM Certified Developer - MQSeries
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WMQI access to user datatables on z/OS
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.