RE: DB2/400 comparisons with other relational databases (specifically Oracle and SQL Server)

This is a multi-part message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Hi Nelson,

I think the phrase where you said: "I do nothing related to
allocating space for files, maintaining indexes, backing up, etc.  All
that
stuff is on auto-pilot." helps bolster my point. Sure we run a weekly
report to check on disk utilisation, but that takes my Technical Manager
about 5 secs to look at. We have a fairly mature management team and new
logicals on gigantic files and the like are discussed amongst us.

In an SAP/Oracle environment you have to ensure (wait for it) that all
the transactions from the Application Server have actually posted to the
database. You have a daily report of "corrupt" indexes which must be
sorted out and so on.

My advice would be not to take the Oracle job. Those poor guys really
have a hard time.

Alistair

-----Original Message-----
From: Smith, Nelson [mailto:NSmith@lincare.com]
Sent: 28 September 2001 15:07
To: 'midrange-l@midrange.com'
Subject: RE: DB2/400 comparisons with other relational databases
(specifically Oracle and SQL Server)


Hi Alistair,

I am an AS400 "DBA" here and at my former company, however, as you
already
know (but not Server Dave, obviously), none of my duties remotely
resemble
the duties of the SQL Server DBA's (yes, multiple) that we also have
here.
About the only thing I do that is actually related to the database is to
enforce programming and nameing standards on the other programmers and
consult with them on the best way to do things related to triggers,
constraints, etc. I also perform all database changes on the production
system, just to keep everyone's hands off them.  I do nothing related to
allocating space for files, maintaining indexes, backing up, etc.  All
that
stuff is on auto-pilot.  On a 720 development machine with about 20
programmers and a 740 production machine connected to over 500 remote
sites,
my "database" duties probably amount to no more than an hour or two a
week.

I've seen employment ads offering $120M or more for Oracle DBA's.  Are
those
systems so bad you have to pay that kind of money just to "maintain" it?
Sheesh!  Maybe I should switch over......

> -----Original Message-----
> From: Alistair Rooney [SMTP:AlistairR@tbsa.co.za]
> Sent: Friday, September 28, 2001 5:00 AM
> To:   midrange-l@midrange.com
> Subject:      RE: DB2/400 comparisons with other relational databases
> (specifically Oracle and SQL Server)
>
> This is a multi-part message in MIME format.
> --
> [ Picked text/plain from multipart/alternative ]
> Just thought I'd stick in my .2c worth. I've never had the need to
> "administer" our DB2/400 database. I have, however, seen my colleagues
> having to have downtime on a fairly regular basis with their Oracle
(on
> HP-UX) and SQL server machines because of "database" problems. Most
> medium to large sites will employ a DBA for Oracle or SQL Server.
> Question: Do any 400 sites employ a DBA and if so then what do you do
> with him?
>
> Alistair
>
> -----Original Message-----
> From: Chris Rehm [mailto:javadisciple@earthlink.net]
> Sent: 28 September 2001 10:24
> To: midrange-l@midrange.com
> Subject: Re: DB2/400 comparisons with other relational databases
> (specifically Oracle and SQL Server)
>
>
> On Friday 28 September 2001 12:28 am, Server Dave wrote:
> > Joe,
> > Without spending a great deal of time-this info is backed up in
print
> -two
> > sources
> > on Microsofts site.and is common knowlege too people "who know".
>
> Now that just gags me. 'common knowlege too [sic] people "who know"'.
> Ridiculous. Just admit you don't have the answers to the questions and
> move
> on. Your opinion is obvious and from your "source" I can see it comes
> from
> Microsoft's marketing info.
>
> Just say so.
>
>
> --
> Chris Rehm
> javadisciple@earthlink.net
>
> And thou shalt love the Lord thy God with all thy heart...
> ...Thou shalt love thy neighbor as thyself. There is none other
> commandment greater than these. Mark 12:30-31
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
> www.mimesweeper.com
> **********************************************************************
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.


************************************************************************
************************************************************************
************************************************************
This message originates from Lincare Holdings Inc. It contains
information which maybe confidential or privileged and is intended only
for the individual or entity named above.
It is prohibited for anyone else to disclose, copy, distribute or use
the contents of this message.
All personal messages express views solely of the sender, which are not
to be attributed to Lincare Holdings Inc., and may not be copied or
distributed without this disclaimer.
If you received this message in error, please notify us immediately at
MailAdmin@lincare.com or (800) 284-2006.
************************************************************************
************************************************************************
************************************************************
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************