473,146 Members | 1,822 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,146 software developers and data experts.

DB2 on z/OS different than on LUW ?

F
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

Jun 27 '08 #1
2 5751
BD
On May 26, 9:32*am, "F" <f...@hotmail.comwrote:
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

Jun 27 '08 #2
"F" <f@hotmail.comwrote in message
news:g1**********@registered.motzarella.org...
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?
Jun 27 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Neil | last post by:
Folks, I've got a problem at work, and I'm hoping that someone out there may have had something similar (although I doubt it!) or may be able to offer some advice. I'm in the process of...
16
by: Geoff Cox | last post by:
Hello, I publish some web pages using large fonts and would like to give the user the opportunity to print the pages using a smaller font. I believe that this is possible using different style...
1
by: Avanish Pandey | last post by:
Hello All We have 3 differen services (in 3 different server) Service A,B,C . We want to implement distributed transaction when call methods of B and C from A. Is it possible? if yes then how? ...
5
by: Hendrik Schober | last post by:
Hi, we just run into the problem, that "default" alignment in the project properies dialog seem to be different. We have a project that's a DLL, which is linked with a couple of LIBs. All are...
3
by: asanford | last post by:
I want to create an ASP.NET web application that receives a form POST message, inspects the data, and reroutes the request to one of many different servers. I wrote an IHttpModule which...
27
by: Ben Finney | last post by:
Antoon Pardon wrote: > I just downloaded your enum module for python > and played a bit with it. IMO some of the behaviour makes it less > usefull. Feedback is appreciated. I'm hoping to...
4
by: cantatahost | last post by:
Hello, Likely this has been asked before... We have a library (in DLL form) that we distribute. The interface to the library is all C, but within the library it uses C++ in many places. ...
3
by: Ryan Liu | last post by:
Hi, I have a big urgent problem to solve. I used to use Windows 2000 Chinese version, now I installed Windows XP (English) system. The problem is not about 2000 or XP, it is about English...
16
by: Stefano Sabatini | last post by:
Hi all, I'm facing this design problem. I have a table which defines the behaviour of an Object in a given state according to the type of event it is receiving. So for each couple...
5
by: Christopher Brewster | last post by:
I am running the same script on the same data on two different machines (the folder is synchronised with Dropbox). I get two different results. All the script does is count words in different...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
3
by: efe2023 | last post by:
Hello Everybody, There is SQL Server 2008 R2 database with MS Access front-end (linked ODBC tables). I can see all linked tables in MS Access and can add new rows. However, when trying to update...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: SumanSingh | last post by:
As a third-year college student, I'm eager to enhance my SQL skills. Can you recommend valuable resources or courses that would be beneficial for me to learn SQL effectively?
3
by: jimatqsi | last post by:
So, I had this bright idea today that didn't quite work out. Or maybe it is working out but requires me to change a habit. I'm working on a form that will be a sub-form of another form. During...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.