ERP systems

Kathleen S. Jones

ERP systems
We are a large school district but compared to companies out there, we are
a small company. Our largest table at this time is around 20 million
rows. We are starting to look at an ERP system - we are still in the
planning stages so no product has been chosen. But since it takes up to a
year to get new positions approved, I wanted to find out from small
companies out there using an ERP system like Peoplesoft or SAP how many
database staff is needed. Thanks to anyone willing to share their
thoughts.

Kathy Jones
Central Information Services
Clark County School District
O/S390 DB2 DBA
NT DB2 DBA
702-799-5040 x366
[login to unmask email]



Michael Ebert

Re: ERP systems
(in response to Kathleen S. Jones)
Hi Kathy,

we're not really a small company, but we're not a big SAP user either
(approx. 250 GB in production). I'm taking care of the DB2 V6 on OS/390
side of 5 SAP 4.6C systems as the DBA (the systems stuff is done by a
colleague on the MVS side). This takes up only a minor part of my time
(I'm using selfmade maintenance job generators). Don't let people frighten
you about SAP. It's just an application (written & maintained by people
with little mainframe DB2 skills). Compared to our legacy systems, it has
some nice properties that make handling easy: all one schema so no GRANTs
to take into account, no explicit RI, no partitioned TSs (yet), no
Utilities being run as part of user jobs (and incorrectly restarted by Ops
when they fail)... so the DBA is in full control. I'd recommend being DB2
V7 for user-impact-free Online REORGs.

Dr. Michael Ebert
DB2 Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany



We are a large school district but compared to companies out there, we are
a small company. Our largest table at this time is around 20 million
rows. We are starting to look at an ERP system - we are still in the
planning stages so no product has been chosen. But since it takes up to a
year to get new positions approved, I wanted to find out from small
companies out there using an ERP system like Peoplesoft or SAP how many
database staff is needed. Thanks to anyone willing to share their
thoughts.

Kathy Jones
Central Information Services
Clark County School District
O/S390 DB2 DBA
NT DB2 DBA
702-799-5040 x366
[login to unmask email]

Kathleen S. Jones

ERP systems
(in response to Michael Ebert)
Thanks to all that have responded. I am keeping your suggestions in a
notebook and will use them to decide how many more DBA positions to ask
for when they decide which way we are going. This list is very much
appreciated here at Clark County School District. My senior data base
analyst and I are the only data base personnel and we are both newbies so
at times this list is a life saver. Thanks again to all who responded.

Kathy Jones
Central Information Services
Clark County School District
O/S390 DB2 DBA
NT DB2 DBA
702-799-5040 x366
[login to unmask email]



David Baldon

Re: ERP systems
(in response to Kathleen S. Jones)
On Tue, 10 Dec 2002 09:43:16 -0800, Kathleen S. Jones
<[login to unmask email]> wrote:

>We are a large school district but compared to companies out there, we are
>a small company. Our largest table at this time is around 20 million
>rows. We are starting to look at an ERP system - we are still in the
>planning stages so no product has been chosen. But since it takes up to a
>year to get new positions approved, I wanted to find out from small
>companies out there using an ERP system like Peoplesoft or SAP how many
>database staff is needed. Thanks to anyone willing to share their
>thoughts.
>
>Kathy Jones
>Central Information Services
>Clark County School District
>O/S390 DB2 DBA
>NT DB2 DBA
>702-799-5040 x366
>[login to unmask email]
>
>
>
the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can

Hello Kathy,
There are a number tools available to help you manage your ERP once you
have decided which one to purchase. While tools can initially seem
expensive they can save you money in the long run by reducing the number of
staff required to maintain the ERP. As an example a very large German
company with one of the largest SAP installations in the world use our
tools and they have a staff of about 6 DBA's.

I recommend visting our web site (www.bmc.com) and doing a search on SAP or
Peoplesoft or Siebel to get an idea of what we have available. We have
products that cover all aspects of maintaining DB2. Of course there are
other vendors with tools for ERP's as well. Another option would be to
search the archives of this LIST to find recommendations from other
companies. I know this type of question is asked on a fairly regular basis
so you should get a pretty good idea of what people think.

Regards...David



Leslie Pendlebury-Bowe

Re: ERP systems
(in response to David Baldon)
Kathy

I will second what Michael is saying. Although we are one of the largest
S.A.P sites in the world we run on a limited number of DBAs (3) and 390
people too. If I was to be honest there is a limited amount of tools you
need to assist you and some basic home grown Rexx or alike will do the job
(note we are not talking millions of lines of code, just a few thosand and
your done).

SAP is just "another" app and it has some brilliant features and some quirky
ones too.

One other thing is we support other things way from SAP ... so I'd say we
have adedicated workforce of about 2 DBAs on SAP .. and they do not work
flat out on it all the time.....

Les


-----Original Message-----
From: Dr. Michael Ebert [mailto:[login to unmask email]
Sent: Wednesday, December 11, 2002 12:25 PM
To: [login to unmask email]
Subject: Re: ERP systems



Hi Kathy,

we're not really a small company, but we're not a big SAP user either
(approx. 250 GB in production). I'm taking care of the DB2 V6 on OS/390 side
of 5 SAP 4.6C systems as the DBA (the systems stuff is done by a colleague
on the MVS side). This takes up only a minor part of my time (I'm using
selfmade maintenance job generators). Don't let people frighten you about
SAP. It's just an application (written & maintained by people with little
mainframe DB2 skills). Compared to our legacy systems, it has some nice
properties that make handling easy: all one schema so no GRANTs to take into
account, no explicit RI, no partitioned TSs (yet), no Utilities being run as
part of user jobs (and incorrectly restarted by Ops when they fail)... so
the DBA is in full control. I'd recommend being DB2 V7 for user-impact-free
Online REORGs.

Dr. Michael Ebert
DB2 Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany



We are a large school district but compared to companies out there, we are
a small company. Our largest table at this time is around 20 million
rows. We are starting to look at an ERP system - we are still in the
planning stages so no product has been chosen. But since it takes up to a
year to get new positions approved, I wanted to find out from small
companies out there using an ERP system like Peoplesoft or SAP how many
database staff is needed. Thanks to anyone willing to share their
thoughts.

Kathy Jones
Central Information Services
Clark County School District
O/S390 DB2 DBA
NT DB2 DBA
702-799-5040 x366
[login to unmask email]





***********************************************************************************************
The information contained in this message or any of its attachments may be confidential and is intended for the exclusive use of the addressee(s). Any disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited without the express permission of the sender. The views expressed in this email are those of the individual and not necessarily those of Sony or Sony affiliated companies. Sony email is for business use only.

This email and any response may be monitored by Sony United Kingdom Limited.
(04)
***********************************************************************************************