DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
metadatamen



Group memberships:
Premium Members

Joined: 26 Oct 2016
Posts: 34

Points: 356

Post Posted: Thu Oct 26, 2017 1:42 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

Is it possible to have a separate IADB for each IA project instead of pointing to same IADB from all IA projects?

We do have multiple engine for each IA projects bur wondering if we could have separate IADB also.

I did create a separate IADB and configuring it in one of the IA project but I was getting an error stating that the configuration is wrong though the connection was made successful in IMAM for this new IADB.

Could someone please advise what more configuration that we need to do to make this work.
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2653
Location: USA
Points: 19683

Post Posted: Fri Oct 27, 2017 7:01 am Reply with quote    Back to top    

Yes. We have started creating a new and separate analysis database for each IA project. It makes managing disk space and clean-up easier. When a project is completed, we can just drop its analysis database.

Here is a good starting point.

https://www.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.productization.iisinfsv.install.doc/topics/wsisinst_pln_overviewiadbprep.html

The high level steps are to run a shell script that executes a DDL script to create a new IADB. Then you have to create connections to the database, including a JDBC connection from WAS. I am not sure why but unfortunately the instructions say you have to restart WAS. Get all that tested and working before going into IMAM and before creating the new IA project. Then you have to go into the new IA project properties and point it to the new analysis database and validate.

Where are you running into a problem and what is the error?

Here are a few related links:

https://www.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.ia.administer.doc/topics/New_config_steps_super.html

And the JDBC part:

http://www-01.ibm.com/support/docview.wss?uid=swg27041740

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
Rate this response:  
Not yet rated
metadatamen



Group memberships:
Premium Members

Joined: 26 Oct 2016
Posts: 34

Points: 356

Post Posted: Thu Nov 09, 2017 9:15 am Reply with quote    Back to top    

Thank you! We did this successfully.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
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



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours