SEO

I have the opportunity to get UDB training however, It's all OS/390 and
I am using DB2 on Unix. I really have no idea what the differences
between DB2 on different platforms is. If I learn the optimzer and
tools on one platform, is that knowledge transferable?

Thanx for any guidance. Randy

<gastcom@sympatico.ca> wrote in message
news:1140102257.891305.175360@g47g2000cwa.googlegr oups.com...
>I have the opportunity to get UDB training however, It's all OS/390 and
> I am using DB2 on Unix.

I see by your email address that you are in Canada. There is plenty of UDB
training for Unix available in Canada. IBM Canada, ProTech, and various
other companies all offer UDB training for various platforms, including
Unix.

You can find information about IBM Canada's training services at
http://www-304.ibm.com/jct03001c/ser...entID=a0001419.
Use the search engine to find courses for DB2 on Windows/Linux/Unix.

You can find information about ProTech's training services at
http://www.protechpts.com/. Use the search engine to find courses for DB2 on
Windows/Linux/Unix.

If you do a Google search, I'm sure you can find other companies operating
in Canada that offer DB2 training for Unix.

> I really have no idea what the differences
> between DB2 on different platforms is. If I learn the optimzer and
> tools on one platform, is that knowledge transferable?
>
There are a _lot_ of similarities between the various versions of DB2: DB2
for Z/OS, DB2 for Windows, Unix and Linux; DB2 for AS/400; etc. but there
are also a number of important differences.

Even the version numbers are not fully synchronized; I think the latest
version of DB2 for AS/400 is Version 5 while the latest versions of DB2 for
Z/OS and Windows/Unix/Linux is Version 8; although they all have _roughly_
the same functionality. Also, every new version of DB2 on a given platform
has different functionality than the functionality for the previous version.

Mastering DB2 on one platform is a huge head start for mastering DB2 on
another platform but each platform has its differences, mainly due to the
platform itself. I think the optimizers are quite similar across the board
these days. The syntax for SQL is also quite similar across the board,
although you'll certainly see differences between the CREATE TABLESPACE
statement in Z/OS and the one in Windows/Unix/Linux due to the different
file systems. But there are still important differences; I still remember
being quite startled by how different DB2 for AS/400 was when I first saw it
and worked with it; it wasn't completely different but the way things were
done certainly didn't seem too close to what I knew from other platforms.

If your shop has DB2 on only one platform with no plans to expand to other
platforms, I'd suggest getting your training on that platform so that you
don't have to mentally translate between what you learned and what you use
at work. If you later need to do DB2 work on other platforms, you will have
to learn a few things about the differences on the new platform but not
necessarily too many.

If you are using DB2 on multiple platforms, I'm not sure what to suggest.

You may want to take the same courses for each platform you use; for
instance, you might want a full SQL course for each platform you use. But
you'd see quite a lot of overlap and that might feel like a waste of time
and money to you and/or your management. If you don't mind picking up a
manual, you might try taking SQL for the platform you use most, then use the
manuals for the other platforms to help you write SQL on those platforms;
there will be some differences in the syntax and capabilities of the
statement but probably not too many in most cases. Ditto for courses on
other subjects like administration or programming.

I hope this helps,

--
Rhino

<gastcom@sympatico.ca> wrote in message
news:1140102257.891305.175360@g47g2000cwa.googlegr oups.com...
>I have the opportunity to get UDB training however, It's all OS/390 and
> I am using DB2 on Unix. I really have no idea what the differences
> between DB2 on different platforms is. If I learn the optimzer and
> tools on one platform, is that knowledge transferable?
>
> Thanx for any guidance. Randy
>

Both DB2 for z/OS and DB2 for Linux, UNIX, Windows (LUW) are officially
called DB2 UDB.

But they are different products, especially at the DBA level. If you need
training for DB2 for LUW, do NOT attend a class offered for DB2 for z/OS.

That is great information, Thanx

Great info Rhino !!

Great info Rhino !!

"Raj" <span3d@yahoo.com> wrote in message
news:1140200810.528305.224270@z14g2000cwz.googlegr oups.com...
> Great info Rhino !!
>
You're welcome :-)

--
Rhino