All Blog Posts Tagged 'wrapper' (4)

Configure Federation Server ODBC Wrapper to Netezza

System and Software

AIX 5.3.0.0

InfoSphere Federation Server v9.7 fixpack 3

ODBC driver v4.5.4 provided by Netezza.

IBM branded Datadirect ODBC driver manager 6.0

Setup Steps

Configure connectivity from ODBC Driver to Netezza… Continue

Added by Yunfeng Sun on November 15, 2010 at 10:30pm — 1 Comment

Query Oracle nickname returns SQL1097N error

Problem

select * from ora_nick

SQL1097N The node name was not found in the node directory.

And there is following error in db2diag.log

2010-10-21-18.43.05.633000-420…

Continue

Added by Yunfeng Sun on October 26, 2010 at 10:30am — No Comments

Which db2fmp is for Federation?

Question

If a wrapper is created in fenced mode, the fenced library will be loaded into db2fmp process. But there are many db2fmp in my system, how can I know which db2fmp is used by Federation?

Answer

On UNIX/Linux , first use the "ps" to find all db2fmp process ID, then use the…

Continue

Added by Yunfeng Sun on October 13, 2010 at 9:22pm — No Comments

Questions about Federation in DPF environment

Questions:

We are installing federation server on a 40 node DPF (MPP) database.

1. Do I have to install federation on all of the nodes or just the coordinating node.

2. Do I need wrappers, servers, user mappings and nicknames on all of the nodes or just the coordinator node.

Answers:

1. Please install federation on all of the nodes because in a DPF(MPP) system, any partition could be potentially a…

Continue

Added by Yunfeng Sun on September 15, 2010 at 4:00am — No Comments