Path: utzoo!attcan!telly!problem!compus!lethe!yunexus!ists!helios.physics.utoronto.ca!news-server.csri.toronto.edu!bonnie.concordia.ca!uunet!zaphod.mps.ohio-state.edu!rpi!crdgw1!gecrdvm1!syspmzt
From: SYSPMZT@gecrdvm1.crd.ge.com
Newsgroups: comp.databases
Subject: Re: DB2: Any Users in the Crowd ?
Message-ID: <91016.134008SYSPMZT@GECRDVM1.BITNET>
Date: 16 Jan 91 17:40:08 GMT
References: <91003.112623SYSPMZT@GECRDVM1.BITNET>
 <1991Jan13.021007.27386@bronze.ucs.indiana.edu>
Organization: General Electric Corporate Research & Development
Lines: 33


In article <1991Jan13.021007.27386@bronze.ucs.indiana.edu>,
bbeckman@silver.ucs.indiana.edu (Beth Beckman) says:
>
>Yes, Indiana University purchased DB2 last November, and we are in the process
>of implementating it.  I am also VERY interested in establishing contacts with
>other DB2 users.  I would especially be interested in someone who is:
>
>    1.  Using CA-Top Secret with DB2 (Security software)
>    2.  Using the Focus/DB2 Interface
>    3.  Charging back customers for DB2 DASD and/or CPU cycles
>
We use CA's ACF2 for security, and so far they've been responsive
with secondary authids support (DSN3@ATH and DSN3@SGN), which we've
implemented.  Assuming Top Secret provides this support, that is
definitely the way to go from the start, from your highest level up.

We also use the Focus DB2 Interface, and all I can say is that it's
quite anti-climactic from my standpoint (systems programmer) in that
you simply bind a dynamic SQL plan and never touch the thing again.
The real issues are the same as with QMF: what the users do with the
thing afterwards, and I don't know that Focus has a governor to limit
the work done in QMF.

As far as chargeback, we run with Accounting Trace 1 on, and charge
via a MICS component for the cpu as cut on the 100 & 101 SMF records.
DASD is the standard stuff- the high level in the storage group
VCAT is used to charge back.  DASD people hate DB2 because they
always complain that it doesn't fit any of the SMS schemes- the
only qualifier that can be changed is the first level.  But that's
adequate for billing.

Phil Z.