How can I create a as400 alias in Optim Configuration?
This topic has been locked.
5 replies Latest Post - 2012-12-02T22:28:02Z by SystemAdmin
Pinned topic Create a as400 alias in Optim 8.1
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-12-02T22:28:02Z at 2012-12-02T22:28:02Z by SystemAdmin
Ducatiman 27000213JK58 PostsACCEPTED ANSWER
Re: Create a as400 alias in Optim 8.12012-09-10T22:21:43Z in response to osestoThere's several different methodologies in using Optim against AS400 systems. Are you doing Archiving/Data growth? or Decom or TDM/DP.
Traditionally we've used DB2 Federation Server and created Nicknames for the Loogical and Physical files.
Let us know specifics and maybe we can make a better recommendation
bluey01 110000ENQX1 Post
Ducatiman 27000213JK58 Posts
osesto 270005J74G9 PostsACCEPTED ANSWER
Re: Create a as400 alias in Optim 8.12012-09-14T17:50:17Z in response to DucatimanYeah, Federation Server seems to be the answer, but it still not perfect because if you are doing the following tasks:
1. Use Discovery to obtain the tables to be masked and exporting them to Optim Designer. The connection is accomplished with jt400.
2. In Optim Designer I create Extract/mask and Insert Optim Distributed Services with those exported files.
3. The final step is executing those Optim services by exporting them to Optim Directory Proyect which require the as400 db alias properly configured.
The problem is that I have to create the correct nicknames in the federation server for each table discovered.
Sorry for my poor english.
SystemAdmin 110000D4XK304 PostsACCEPTED ANSWER
Re: Create a as400 alias in Optim 8.12012-12-02T22:28:02Z in response to osestoHi ,
I am new to Optim and currently working for TDM project. We have AS400 application and backend data base is DB2 , In this case can Optim directly connect to DB2 data base through ODBC or DB2 drivers to create Alias in Optim? , Why we need to use Federation server? and also why we need to use ISeries? Can any one please advise me.
In my project Optim is installed in mid-rage.