[comp.databases] DB2: Any Users in the Crowd ?

SYSPMZT@gecrdvm1.crd.ge.com (01/03/91)

Are there any DB2 users in this database group?  I'd like to contact others
using this product; there's a lot of crossover with entries on SQL for
Oracle and the like, but nothing specific to IBM's mainframe DB2.

Phil Z

bob@sactoh0.SAC.CA.US (Bob F. Breedlove) (01/05/91)

SYSPMZT@gecrdvm1.crd.ge.com writes:
> Are there any DB2 users in this database group?  I'd like to contact
others
> using this product; there's a lot of crossover with entries on SQL for
> Oracle and the like, but nothing specific to IBM's mainframe DB2.
 
 
Yes, there are DB2 users here -- at least one.  I have recently worked
on two large DB2 implementations.
-- 
Bob Breedlove  SYSOP: BOBsBBS (916/929-7511)
Author: CONFIG.EXE, RUN.EXE, CleanUp.EXE
        bob@sactoh0.SAC.CA.US

SYSPMZT@gecrdvm1.crd.ge.com (01/08/91)

In article <4585@sactoh0.SAC.CA.US>, bob@sactoh0.SAC.CA.US (Bob F. Breedlove)
says:
>
>Yes, there are DB2 users here -- at least one.  I have recently worked
>on two large DB2 implementations.
>--

Was that at DB2 2.2?  Any Distributed processing?  I'm interested in
feedback on DDF in use or planned, or other schemes used.  Nothing
specific, just a feeling for DDF as people start implementing the new
facility.  I'm planning to install DDF on our DB2's in the next
couple of months, mostly to see how well it performs.  I'd like
to contact others actually using it.

Thanks,
       Phil Z.

bbeckman@silver.ucs.indiana.edu (Beth Beckman) (01/13/91)

In article <91003.112623SYSPMZT@GECRDVM1.BITNET> SYSPMZT@gecrdvm1.crd.ge.com writes:
>Are there any DB2 users in this database group?  I'd like to contact others
>using this product; there's a lot of crossover with entries on SQL for
>Oracle and the like, but nothing specific to IBM's mainframe DB2.
>
>Phil Z

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
 
Thanks for any responses!
 
Beth Beckman   BBECKMAN@SILVER.UCS.INDIANA.EDU
Database Administrator

SYSPMZT@gecrdvm1.crd.ge.com (01/17/91)

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.