DB2 EE Config when DS on Linux, DB2 on AIX

StephenB · Post by **StephenB** » Tue Jan 22, 2008 11:56 am

Hi,

I'm needing to perform a "sparse" lookup, and I've read that the DB2 Enterprise Edition is required (currently only DB2 UDB API is configured). The concern I've got is DataStage 8 is installed on Linux and DB2 8 is installed on a separate AIX machine.

Is there a way to get the DB2 Enterprise Connector working with this setup?

I've heard there is a way to make DataStage see the database as "local." Has anyone had success with this, and if so would it work in this situation?

Any suggestions/experiences would be appreciated.

Thanks, Stephen

Teej · Post by **Teej** » Tue Jan 22, 2008 1:26 pm

This is not allowed.

For Enterprise stages (not referring to ODBC stages), you MUST keep the operating systems the same.

Sorry. You will need to use ODBC (or the equivalent technology) to work in this type of environment.

StephenB · Post by **StephenB** » Tue Jan 22, 2008 1:32 pm

Teej wrote:This is not allowed.

For Enterprise stages (not referring to ODBC stages), you MUST keep the operating systems the same.

Sorry. You will need to use ODBC (or the equivalent technology) to work in this type of environment.

Thanks, that helps.

Does the ODBC Enterprise Stage support "sparse" lookups?

Teej · Post by **Teej** » Tue Jan 22, 2008 1:48 pm

I have not tried it personally for 8.x, but I do not see why it shouldn't work.

Just make sure that your SQL statements allow for such queries (i.e. have a where clause for the key fields you're doing a lookup on.)