Feel free to contact me directly with any follow up. I've used WC 8.1
extensively in converting from SQLServer to UDB and struggled through
most of your questions. IBM seems to still be in the process of
packaging/repackaging this product, so it was rather difficult getting
definitive answers from them.

OK, here goes. I'll reply in caps for readability. Please don't think
I'm shouting:
- What is the exact funcionality of warehouse server process ?
THE WAREHOUSE SERVER SERVICE ON WIN2000 CONTROLS BOTH WAREHOUSE CENTER
AND WAREHOUSE MANAGER PROCESSING AND INTER-AGENT COMMUNICATION.
- What is the relationship between warehouse server, warehouse center
GUI &
the control database of warehouse center ?
WAREHOUSE CENTER (WC) NEEDS TO BE INSTALLED ON THE MACHINE THAT WILL
RUN THE WC GUI AND MANAGE THE CONTROL DATABASE. WAREHOUSE MANAGER (WM)
IS REQURIED IF THE USE OF REMOTE AGENTS AND SOME OF THE SPECIALIZED
TRANSFORMATIONS ARE TO BE USED. IT IS QUITE POSSIBLE TO HAVE A FULL
FUNCTION "DTS REPLACEMENT" WITHOUT BUYING/INSTALLING WAREHOUSE
MANAGER. THAT'S ACTUALLY WHAT I DO...
Do they have to co-exist on the same box or can they run on
different
boxes / OSs WITH WAREHOUSE MANAGER YOU CAN HAVE REMOTE AGENTS ON
LINUX, ISERIES, OS390, OR OTHER WINTEL SERVERS.
- Can I have the agent running on Linux (where the app database is
sitting), store the control database as well on Linux
and use a Windows 2K UDB client for GUI purpose ? How about
warehouse
server process then ? NO, YOU WOULD MORE LIKELY RUN EVERYTHING ON THE
LINUX BOX OR HAVE A WINTEL SERVER THAT SENDS DATA TO THE LINUX BOX VIA
A WAREHOUSE MANAGER AGENT (OR JUST A REMOTE TARGET DATABASE REFERENCE.
IT ALL DEPENDS UPON WHERE YOU WANT THE EXTRACT/TRANSFORM/LOAD PROCESS
TO RUN.
Where do we
schedule the jobs ? ON THE MACHINE THAT MANAGES/CONTROLS THE
WAREHOUSE DB AND THE DBTOOLS CATALOG. THE SCHEDULER IS BAKED INTO WC -
AGAIN, NO NEED FOR WM UNLESS YOU WANT THE REMOTE AGENT CAPABILITY OR
SPECIALIZED TRANSFORMS.
=============================

I know this may be more confusing than what you started with. If so,
feel free to contact me at the email address below. I'm happy to
discuss over the phone as well. My experience with Warehosue Center
has actually made working my way thru these product "gray areas" quite
worthwhile. The biggest decision you'l have is whether you need to
purchase Warehouse Manager ($25K) or not and where to host your
warehouse ETL processing. Good luck


Pete Hazzard
Principal, Moshier Island Group
http://www.MoshierIslandGroup.com
phazzard (AT) MoshierIslandGroup (DOT) com


"Dave" <adavi (AT) comcast (DOT) net> wrote

Thanks Pete for your patient reply. It cleared some of my confusion.
I will get back to you if I need more info
Regards
Dave

"Pete H" <phazzard (AT) intellicare (DOT) com> wrote