About Data Federation

A sample of response file which you can use for installing Federation Server wappers against an existing DB2 copy

Shirley_Huang ‎ 4,653 Views

If you do not have GUI tools in your Unix/Linux system, you need to install Federation Server in silent mode. For silent installation, a response file is needed.
In this paper, a sample of response file will be provided in case that you need to install Federation Server wappers against an existing DB2 copy. You could re-use it after setting your installation location.
Before using this response file, you need to take notice that the version of Federation Server and DB2 copy should be the same. For example, the DB2 copy in your system is v97fp6, you can use this response file to install Federation server v97fp6.

For Federatoin Sever V97:

The sample of response file:

### response file for IBM InfoSphere Federation Server ###
-G licenseAccepted=true
-W installTypeSelectionLinuxx86_64.selectedType="db2"
-P installLocation="/opt/ibm/db2/V9.7"
-P db2.active=false
-P rw.active=true
-P odbc.active=true
-P oracle.active=true
-P sqlserver.active=true
-P sybase.active=true
-P teradata.active=true
-P jdbc.active=true
-P nw.active=true
-P application.active=true
-P scientific.active=true
-P structured.active=true
-W detectWrapperLinuxx86_64.fpVisible=false
-W languagePackLinuxx86_64.selectedLanguages=EN
-W rwconfigureInstanceOptionLinuxx86_64.configure=false
-W nwconfigureInstanceOptionLinuxx86_64.configure=false
### end of response file ###

To use the file, you need:
Step 1: Set the value of keyword 'installLocation' to the location of the DB2 copy according to your environment.
Step 2: The sample is for Linuxx86_64.If your system is not Linuxx86_64, you should change these 5 keywords according to your system type. You can file the correct keywords from image_path/federation/samples/xx.rsp provided in the images.

installTypeSelectionLinuxx86_64.selectedType
detectWrapperLinuxx86_64.fpVisible
languagePackLinuxx86_64.selectedLanguages
rwconfigureInstanceOptionLinuxx86_64.configure
nwconfigureInstanceOptionLinuxx86_64.configure

Step 3: Save the content in a file such as fs.rsp.
Step 4: Lauch silent installation by "iisetup -options 1.rsp -silent". Before that, please make sure the instance and DAS are stoped.

For Federation Server V10:

The sample of response file:

### response file for IBM InfoSphere Federation Server ###
LICENSE_ACCEPTED=TRUE
installType=db2
USER_INSTALL_DIR=/opt/ibm/db2/V10.1
db2Active=false
rwActive=true
nwActive=true
odbcActive=true
jdbcActive=true
oracleActive=true
sybaseActive=true
teradataActive=true
applicationActive=true
sqlserverActive=true
scientificActive=true
structuredActive=true
fixpackActive=false
selectedLanguages=
rw_configure=false
nw_configure=false
installNow=true
### end of response file ###

To use the file, you need:
Step 1: Set the value of keyword 'USER_INSTALL_DIR' to the location of the DB2 copy according to your environment.
Step 2: Save the content in a file such as fs.rsp.
Step 3: Lauch silent installation by "iisetup -f fs.rsp -i silent". Before that, please make sure the instance and DAS are stoped.

IFS connect to Oracle server via OCM

Jany_sky Tags: federation oracle ocm server ‎ 6,525 Views

This is small summary for Federation Server connect to Oracle server via OCM.

1) install CMAN manually

select customer type install and then choose install Oracle Net Services --> Oracle Connection Manager

2) config CMAN

config file $ORACLE_HOME/network/admin/cman.ora
you can get template from $ORACLE_HOME/network/admin/samples/cman.ora
and find log: $ORACLE_HOME/network/log/cman_nisco_li_alert.log
Example:
cman_abc.cn.ibm.com=
(configuration=
(address=(protocol=tcp)(host=abc.cn.ibm.com)(port=1630))
(rule_list=
    (rule=
       (src=*)(dst=*)(srv=*)(act=accept)
       (action_list=(aut=off)(moct=0)(mct=0)(mit=0)(conn_stats=on))
     )
     (rule=
       (src=abc)(dst=127.0.0.1)(srv=cmon)(act=accept)
      )
)
)
Note:
1. address: please set oracle server's hostname and port number for CMAN, default is 1630.
2. rule_list and parameter_list: these are some connection rules and parameters, you can get detail info from samples
   $ORACLE_HOME/network/admin/samples/cman.ora.
3) Run CMAN using cmctl
[oracle@abc bin]$ cmctl
CMCTL for Linux: Version 11.1.0.6.0 - Production on 04-FEB-2013 13:38:38
Copyright (c) 1996, 2007, Oracle. All rights reserved.
Welcome to CMCTL, type "help" for information.
CMCTL> help
The following operations are available
An asterisk (*) denotes a modifier or extended command:

administer      close*          exit            quit
reload          resume*         save_passwd     set*
show*           shutdown        sleep           startup
suspend*

You can use administer to start CMAN.
4) Connect to oracle using CMAN
Config oracle client $ORACLE_HOME/network/admin/tnsnames.ora
Example:
PAWCMAN =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = abc.cn.ibm.com)(PORT = 1630))
    (ADDRESS = (PROTOCOL = TCP)(HOST = abc.cn.ibm.com)(PORT = 1521))
    (SOURCE_ROUTE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orapawpa)
    )
)
Note:

(SOURCE_ROUTE = yes) is requried.

5) IFS connect to Oracle server using CMAN
Take AIX script for example:

1. create oracle wrapper
CREATE WRAPPER "WRAPPER1" LIBRARY 'libdb2net8.a' OPTIONS(DB2_FENCED 'Y')

2. create server for PAWCMAN
create server "SERVER1" type oracle version 11.0 wrapper "WRAPPER1" authorization "J15USER12" password "J15USER12" options (node 'PAWCMAN', password 'Y', pushdown 'Y')

3. create user mapping
create user mapping for user server "SERVER1" options ( REMOTE_AUTHID 'J15USER12', REMOTE_PASSWORD 'J15USER12' )

4. Then you can create other federated objects like nickname

Which IBM Products Give You Data Federation for Free?

DavidT Tags: db2 federation informix infosphere_warehouse oracle ‎ 6,656 Views

With the move towards integrated software stacks, you may not always be aware of all the technologies you have in products you own. IBM's data federation technology is no exception. It's found in so many IBM products that many people aren't sure whether they have it or not. To cut down on confusion (I hope), I put together a quick reference that shows the products that allow federation, but are not data federation products themselves. How do they do this? They include a subset of IBM's InfoSphere Federation Server. In this post, I focus on those that allow federation though SQL. This includes distributed joins, which are queries that join tables from different databases.

These products fall in to three groups:

DB2 editions
InfoSphere Warehouse editions
DB2 Connect editions

Not all of them allow federation of all Federation Server data sources. Therefore, I have tables that show which data sources are allowed in the various editions. For those about to ask... yes, IBM has many more products that include data federation for specialized use instead of general SQL access. For example, IBM InfoSphere Data Replication. However, those are not discussed in this post. Maybe a future one :)

InfoSphere Federation Server

Here a few quick points about Federation Server. First, this product contains all IBM data federation technology on UNIX and Windows. It provides the data federation found in the other products discussed in this post. Next, for mainframes, DB2 z/OS access is provided in Federation Server at no additional cost. However, if you need to federate classic mainframe data sources - IMS, VSAM, ADABAS, or IDMS - through Federation Server, you will need to buy IBM's Classic Federation Server for z/OS.

DB2 9.7 for Linux, UNIX, and Windows

The following table shows which data sources you're allowed to federate in the various DB2 editions. Two things to note:

I limit this table to 9.7 since the list has changed from release to release.
DB2 editions can be extended to allow more data sources. Do this by installing InfoSphere Federation Server with the DB2 install.

*DB2 9.7 editions and the data sources they can federate*
Data Source Allowed	Express-C	Express	Workgroup	ESE	Advanced ESE	IBM DEDE	Comments
DB2 LUW
InfoSphere Warehouse
DB2 z/OS and i							Requires a licensed copy of DB2 Connect in addition to the DB2 edition.
Informix							For details, see Is Informix Federation Free?
WebSphere MQ
Web services
Oracle
Classic z/OS - IMS, VSAM, Adabase, IDMS							Requires purchase of Classic Federation Server on z/OS.
All others

InfoSphere Warehouse on UNIX and Windows

The following table shows which data sources you're allowed to federate in the various InfoSphere Warehouse editions. Three things to note:

I limit this table to 9.7 since the list has changed from release to release.
InfoSphere Warehouse allows access to any Federation Server data source through its SQW component. I do not show that in the table.
InfoSphere Warehouse editions can be extended to allow more data sources. Do this by installing InfoSphere Federation Server with the InfoSphere Warehouse install.

*InfoSphere Warehouse 9.7 editions and the data sources they can federate*
Data Source Allowed	Developer	Departmental	Dept Base	Dept Advanced	Base WH Feature	Enterprise WH Feature	Enterprise	Enterprise Base	Enterprise Advanced	Comments
DB2 LUW
InfoSphere Warehouse
DB2 z/OS and i										Requires a licensed copy of DB2 Connect in addition to the ISW edition.
Informix										For details, see Is Informix Federation Free?
Oracle
All others

DB2 Connect 9.7

The following table shows which data sources you're allowed to federate in the various DB2 Connect editions. Two things to note:

I limit this table to 9.7 since the list has changed from release to release.
DB2 Connect editions can be extended to allow more data sources. Do this by installing InfoSphere Federation Server with the DB2 Connect install.

*DB2 Connect 9.7 editions and the data sources they can federate*
Data Source Allowed	Personal	App Server	Enterprise	Unlimited for z	Unlimited for i	Comments
DB2 LUW
InfoSphere Warehouse
DB2 z/OS and i
Informix						For details, see Is Informix Federation Free?
All others

Using Off-the-Shelf Apps with IBM Data Federation

DavidT Tags: virtualization soa data db2 federation ipad ios ‎ 7,685 Views

I get a lot of questions about which tools work with IBM's data federation technology. Many people forget that IBM data federation is based on DB2 technology and any DB2 client app can be used with it. For example, if you need SOA for data virtualization, you can use IBM's InfoSphere Information Services Director with IBM's data federation to provide reusable services for SOA. The list goes on.

What about third-party tools (i.e., something not from IBM)? You can create reports in Microsoft Excel going through an ODBC driver. Better yet, one of my favorite is examples is accessing virtualized data from an iPad. For example, in the screen shot below (click to enlarge), I've used impathic's DB2 Mobile Database Client to access virtualized data and feed it into an Apple Numbers speadsheet. This took no special coding. All I had to do was (1) purchase and install the apps, (2) point impathic's client to my federation server, and (3) issue a query. From an iOS perspective, this means that IBM's data federation can help you get data for everything from DB2 and IMS on the mainframe to Oracle and Teradata appliances.

I'll show more examples as I have time.

(click to enlarge)

Is Web Services Federation Free with DB2?

DavidT Tags: web web_services warehouse db2 federation database infosphere ‎ 6,093 Views

IBM's Federation Server has an interface to web services that lets you federate and query web services using SQL. IBM announcement letter 209-134 shows that this Federation Server capability was included in the following DB2 LUW 9.7 editions at no additional cost:

Enterprise Server Edition
Workgroup Server Edition
Express Edition

DB2 Advanced ESE (AESE) also has this capability builds on top of DB2 ESE. However, as per the announcement letter, web services federation is not included in Express-C or Personal Edition.

Good news for you InfoSphere Warehouse fans - IBM announcement letter 209-129 shows this capability is in all InfoSphere Warehouse 9.7 editions.

--

Feed for Blog Entries Feed for Blog Comments

Blogs