Datawarehouse on DB2 vs Oracle

From: Anwar Kassam 237-3892 <kassama_at_cuug.ab.ca>
Date: Tue, 14 Jun 1994 22:33:52 GMT
Message-ID: <CrEs0H.FK8_at_cuug.ab.ca>

I am working on a project to build a datawarehouse. The question I have is should we use mainframe DB2 as a corporate datastore or use a database server on a UNIX machine to build the datawarehouse. We have ORACLE's gateway to talk to DB2 on the mainframe.

I am lookinf for the following information:

Is UNIX based DBMS server more cost effective compared to mainframe DB2? Can UNIX evnvironment handle 30 Gigabytes of information? Can it support 100 concurrent users?
How long would it take to load 30 gigabytes of information? Has anyone used POWERBUILDER or ACCESS to talk to DB2 via ORACLE's DB2 gateway?

Will appreciate any information or experience you have building a datawarehouse. Thanks in advance.

Please reply kassama_at_cuug.ab.ca Received on Wed Jun 15 1994 - 00:33:52 CEST

This message: [ Message body ]
Next message: Phil Scarr: "SQL*Net v2 for Windows?"
Previous message: Carl Gohringer: "Re: Help with Forms 4.0 Error"
Next in thread: Michael Sallwasser: "Re: Datawarehouse on DB2 vs Oracle"
Reply: Michael Sallwasser: "Re: Datawarehouse on DB2 vs Oracle"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message