Re: Question (pre-newbie) about DB2

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

It's different in that the system does things like runstats and reorg
and things. SQL syntax should be basically the same. You have all the
stuff you would expect - collections, tables, views, etc. They're
implemented physically differently, but that's true for all databases.

I've taught classes for companies transitioning from z to i, and the
folks that knew DB2 and SQL didn't have a problem with the change. You
may find that you don't need/want to do things the same way, but you
pretty much can.

On Wed, Dec 3, 2008 at 9:12 AM, McKown, John
<John.Mckown@xxxxxxxxxxxxxxxxx> wrote:
> I know that the DB2 which runs on z/OS is different from the DB2 which
> runs on Linux/Windows. DB2 on "distributed" systems is called UDB. Is
> the DB2 on the i the same as UDB, or is it a i-only variant? I ask
> because I had heard that DB2 on the i was different from the other DB2
> versions. From what my manager is saying, it looks like we are very
> likely to move from our z to an i sometime in late 2009 or early 2010. I
> don't know if this means that __I__ will get retrained or axed.
>
> John McKown
>
> Systems Engineer IV
>
> IT
>
>
>
> Administrative Services Group
>
>
>
> HealthMarkets(r)
>
> Administrative Services Group
>
> 9151 Boulevard 26 * N. Richland Hills * TX 76010
>
> (817) 255-3225 phone * (817)-961-6183 cell
>
> john.mckown@xxxxxxxxxxxxxxxxx * www.HealthMarkets.com
>
>
>
> Confidentiality Notice: This e-mail message, including any attachments,
> is for the sole use of the intended recipient(s) and may contain
> confidential or proprietary information. Any unauthorized review, use,
> disclosure or distribution is prohibited. If you are not the intended
> recipient, please contact the sender by reply e-mail and destroy all
> copies of the original message.
>
>
>
>
> --
> 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.