Date:         Fri, 7 Jun 1996 12:34:38 -0400
Reply-To:     Zul Habib <zhabib@onramp.ca>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Zul Habib <zhabib@ONRAMP.CA>
Subject:      Re: Using SAS with DB2-Tables
Comments: To: Thomas Kregeloh <100577.1775@COMPUSERVE.COM>

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
>tables.
>Any comments / experiences etc. are very welcome.
>
>Thomas Kregeloh, Hamburg
>
 
Thomas;
 
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
   optimizer.
 
Good luck.
 
 
 
Zul Habib
 
==============================================================
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
Email: zhabib@onramp.ca
==============================================================