Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / May 2008

Tip: Looking for answers? Try searching our database.

DB2 on z/OS different than on LUW ?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
F - 26 May 2008 17:32 GMT
Is DB2 on z/OS same as DB2 on LUW ? Will my DB2 DBA on one environment have
to retrain again on the other ?

Thanks
BD - 26 May 2008 18:56 GMT
> Is DB2 on z/OS same as DB2 on LUW ? Will my DB2 DBA on one environment have
> to retrain again on the other ?
>
> Thanks

I'd say that the lower-level stuff will be markedly different -
configuring the product on the OS, managing processes, etc.

I've got pretty limited experience in both, but I am already finding
several differences, even with higher-level admin tasks. The
differences I've found have been very specific, and unfortunately not
clearly documented (that I can find). That said, the volumes of
documentation for both platforms make it pretty difficult to find
specific information quickly.

Several SQL keywords which are useable in LUW are not useable in z/OS:
'ATOMIC', for example. There are some words which are 'reserved words'
on the mainframe environment, and cannot be used in SQL statements.

One of the more frustrating examples for me concerns materialized
query tables. In LUW, these can be configured to automatically update,
based on the changes to their 'master' tables. But this automatic
refresh functionality is, for all I can find, not supported under z/
OS. And I have not been able to identify a supported, nor even a
recommended, method for 'emulating' that kind of automatic update of
the MQT. The closest I could get was a notion involving triggers,
which invoked stored procedures, which invoked the update to the MQT.
You can't call a 'refresh table' statement directly from a trigger, I
discovered. I was forced to discard the idea entirely, because of the
ungainly hoops I'd have to jump through. May as well have created the
query tables manually and used manually coded triggers to update them.

Anyway - I rant. My suggestion to you would be to proceed forward,
with the db2 guide for Cross-Platform development close at hand, and
don't spend too much time wrestling with something that worked under
LUW and is not working under z/OS, before attempting to confirm that
what you are trying to do is simply not supported under z/OS.

Cheers,

BD
Mark A - 26 May 2008 23:36 GMT
> Is DB2 on z/OS same as DB2 on LUW ? Will my DB2 DBA on one environment
> have to retrain again on the other ?
>
> Thanks

There are significant differences at the database administration level, but
the DML (select, insert, update, and delete) is very similar and getting
closer with each new release.

The biggest problem is learning the operating systems. If the person is
proficient in z/OS (JCL, TSO, etc) and proficient in Linux/UNIX, then it
will not be hard to learn the differences in the database products.

Which one does the person know now?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.