RE: Question about UDB on iSeries

Rick,

I generally do most things in Ops Nav, though my more experienced
developers are more comfortable in the green screen environment. 

Jim

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rick baird
Sent: Wednesday, December 01, 2004 8:11 PM
To: Midrange Systems Technical Discussion
Subject: Re: Question about UDB on iSeries

Jim,

That's good to hear.   Question:  do you develop your database
exclusively via ops nav?

On Wed, 1 Dec 2004 17:00:57 -0600, Reinardy, James
<jreinardy@xxxxxxxxxxxxxxx> wrote:
> I am currently managing a corporate IS department that uses the 
> iSeries for its primary business application.  However, my background 
> is much more rooted in Sybase, SQL Server and in particular Oracle.  
> My experience with DB2/400 is that it now competes feature for feature

> with the other databases, but this may be a a recent development. I 
> believe that IBM has been playing catch up with the SQL functions of 
> DB2/400 compared to the competition, including its own UDB product, 
> but is just about there now with v5r2 and beyond.  I have been pretty 
> successful at introducing new techniques to my department by assuming 
> since Oracle has it, there is probably a similar feature in DB2/400.  
> We discovered SQL triggers, SQL views and the SQL tools in Operations
Navigator that way.
> I have yet to be disappointed to find that there was not a feature I 
> was looking for.
> 
> I will admit to some misgivings about the proprietary nature of the 
> hardware and OS compared to the Oracle world I am used to, but I have 
> no complaints about the robustness of the software, including the
database.
> 
> Jim Reinardy
> 
> 
> 
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Joe Pluta
> Sent: Wednesday, December 01, 2004 4:35 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: Question about UDB on iSeries
> 
> > From: Dave Odom
> >
> > UT the reality is, it and DB2 are not usually used in the same 
> > environments and for the same types of applications and reasons as 
> > the
> 
> > mainframe.
> 
> I'm interested in this statement!  Do mainframes not do CICS-type 
> applications anymore?  Because for the life of me I can't discern the 
> difference between CICS-based order entry in COBOL and green-screen 
> order entry in RPG IV (or NEP-MRT order entry in RPG II, for that 
> matter).
> 
> If your contention is that mainframes are used more for data 
> warehousing on multi-terabyte databases, then I guess you're probably
right there.
> The iSeries is only just beginning to target that environment, 
> although from what I understand EVIs and the like make the iSeries a 
> pretty nice platform for those things.
> 
> > There are reasons why mainframe shops and mid-range shops using 
> > RDMBs like DB2 and Oracle went with those
> engines
> > and platforms and not with the iSeries.
> 
> What are the reasons?
> 
> > In addition, most iSeries shops I know of, since they have been 
> > influenced by Rochester and tend to move only in that environment 
> > and have done so for decades, don't have an unbiased view of how 
> > different
> 
> > the DB2/400 implementation is from the rest of IBM and why that is 
> > not
> 
> > necessarily good.
> 
> Actually, we didn't even know we were running DB2 until we were told 
> so by IBM.  Until then we were just running OS/400 (or CPF).  We just 
> knew we had the fastest database on the planet for the type of 
> navigational access that best describes business logic.
> 
> > One of the questions that should be answered is, "but with all that,

> > can DB2/400 be used wisely and in keeping with the
> tenets
> > usually found in the rest of the RDBMs world and why is that 
> > important
> 
> > to my business?"
> 
> Can you provide these tenets?  Or better yet point out where they are 
> published.  Can I see them online somewhere?  Download them?
> 
> Joe
> 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

> list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, 
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take 
> a moment to review the archives at
http://archive.midrange.com/midrange-l.
> 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

> list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, 
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take 
> a moment to review the archives at 
> http://archive.midrange.com/midrange-l.
> 
>
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.