Re: Question about UDB on iSeries

On Tue, 30 Nov 2004 08:05:34 -0600, McKown, John
<john.mckown@xxxxxxxxxxxxxx> wrote:
> Please keep in mind that I know **ZERO** about the iSeries and UDB. We are 
> considering a conversion from z/OS on zSeries to i5OS on iSeries. The company 
> doing the presentation basically said that everything that we need, with a 
> few exceptions, is integrated into the i5OS on the iSeries. In particular UBD 
> is integrated (so we don't need to buy it). But I was wondering if any 
> iSeries people out there have an opinion about the lack of requirement for 
> any extra software to support UDB on iSeries. Such as performance monitors, 
> reorganization utilities, anything at all? I'm confused (as usual) about why 
> UDB on iSeries does not require any such software while it appears, to me, 
> that DB2 on z/OS really requires a lot of extra cost software. This is the 
> whole reason that we are considering this conversion. z/OS simply requires 
> too much extra cost software compared to other platforms.
> 

John, you might want to just ask specific questions re the as400
database.  Database files are called physical files on the 400. 
Indexed views of the database file are called logical files.  To
create a database file you either use SQL or code the file description
in a language called DDS ( data description specs ) in a source member
and the run the CRTPF ( create physical file ) command to create the
database file from those DDS specs.   To create an index, a logical
file, code another source member with some DDS and run the CRTLF
command.

hth,

Steve Richter


> > --
> > John McKown
> > Senior Systems Programmer
> > UICI Insurance Center
> > Information Technology
> >
> > This message (including any attachments) contains confidential information 
> > intended for a specific individual and purpose, and its content is 
> > protected by law.  If you are not the intended recipient, you should delete 
> > this message and are hereby notified that any disclosure, copying, or 
> > distribution of this transmission, or taking any action based on it, is 
> > strictly prohibited.
> >
> --
> 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.
> 
>