Can DB2 Enterprise Stage be used in Heterogeneous Env
Moderators: chulett, rschirm, roy
Re: Can DB2 Enterprise Stage be used in Heterogeneous Env
Either the questions were too vague, too tough or too easy!
-
stefanfrost1
- Premium Member
- Posts: 99
- Joined: Mon Sep 03, 2007 7:49 am
- Location: Stockholm, Sweden
As far as I know and understand this... (I have only been utilizing DB2 and DB2EE-stages in heterogeneous environments)
When using the DB2EE-stage and plain user-defined SQL; At runtime the DB2EE-stage will operate in sequential mode and thereby operating via the client. This part works in theory without the explained steps, however there are mechanisms that are used at connection and that probably will fail while executing. Write and Load will not work since it executes via orchdbutil, which is operating locally on the DB2 machine...
Seems that you've got the system up and running so why not try what you are suggesting and post your findings....
When using the DB2EE-stage and plain user-defined SQL; At runtime the DB2EE-stage will operate in sequential mode and thereby operating via the client. This part works in theory without the explained steps, however there are mechanisms that are used at connection and that probably will fail while executing. Write and Load will not work since it executes via orchdbutil, which is operating locally on the DB2 machine...
Seems that you've got the system up and running so why not try what you are suggesting and post your findings....
-------------------------------------
http://it.toolbox.com/blogs/bi-aj
my blog on delivering business intelligence using agile principles
http://it.toolbox.com/blogs/bi-aj
my blog on delivering business intelligence using agile principles