Date: Fri, 7 Jun 1996 12:34:38 -0400
Reply-To: Zul Habib <email@example.com>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Zul Habib <zhabib@ONRAMP.CA>
Subject: Re: Using SAS with DB2-Tables
On Wed, 5 Jun 1996 22:16:03 GMT, Thomas Kregeloh wrote:
>I am building a large data warehouse for an insurance company. The
>DWH will be held on an MVS-Host.
>It is intended to use DB2 instead of SAS-Tables for all of the
>Any comments / experiences etc. are very welcome.
>Thomas Kregeloh, Hamburg
I recently completed a DWH assignment for a client who required
DB2 tables on MVS environment. Access to DB2 via SAS and SQL
works great. However, I did come across a few things to
watch out for...
1) In our tables, using SQL Pass-through instead of SAS Access
improved performance greatly (SQL Pass-through required
1/3 of the cpu time).
2) If you require to join tables which are large, do not
mix SAS Tables and DB2 Tables in a join. If you do,
SAS will bring the DB2 table into core and look after
the join, instead of letting DB2 handle the work.
DB2 would be able to optimize the join via DB2
Habib Consultants Limited
Toronto, Ontario, Canada
SAS Institute (Canada) Inc. "Quality Partner"
IBM DB2 DAP (Developers Program)
Tel: (905) 770-5750
Fax: (905) 770-5163