Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    ISERIES - DATASOURCE IS NOT UNIQUE USING DB2 CONNECT
Go
New
Search
Notify
Tools
Reply
  
ISERIES - DATASOURCE IS NOT UNIQUE USING DB2 CONNECT
 Login/Join
 
Gold member
posted
I am testing a new JDBC driver to connect DM from my Linux Server to an iSeries Database. The driver has been installed and I am able to perform a test connection to the iSeries. The URL I am passing is: jdbc:datadirect:db2://DATA:446;locationName=DATA;alternateId=PRDWSYSDTA. I am now trying to create synonyms from this database. I am able to retreive a list of all the objects in the PRDWSYSDTA schema but if I select one and attempt to add it as a synonym I get the following message:
(FOC1567) CREATE SYNONYM: DATASOURCE 'ASSET_FACT' IS NOT UNIQUE. ASSET_FACT is the object that I selected from the list. It appears the issue is that when it goes to create the synonym it's not looking for this object in just the PRDWSYSDTA schema but is also referencing other schemas/libraries on the server and this object does exist in some other schemas/libraries. I tested this theory by trying to add a synonym for an object that I knew only existed in PRDWSYSDTA and I was able to create that without any errors. I am not sure if there is more I can do on the URL string to force the synonym creation function to only reference objects in PRDWSYSDTA or if there is something else I need to change. If anyone else has encountered this same error I'd appreciate hearing how you were able to get around it.

Thanks,
Bob Cook


WebFOCUS 7.6.8
WebFOCUS Client and Server running on RedHat Linux, Developer Studio on Windows XP
All output formats
 
Posts: 52 | Registered: May 13, 2009Reply With QuoteReport This Post
Expert
posted Hide Post
Hi Bob,

We have similar issues reported without resolution. There may be a system/config issue here or product issue. To pursue further, we will need you to open a case with Information Builders' Customer Support Services. You may either call at 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1950 | Location: New York | Registered: November 16, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    ISERIES - DATASOURCE IS NOT UNIQUE USING DB2 CONNECT

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.