473,714 Members | 2,462 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DB2 on z/OS Mainframe

F
I understand at a high level database concepts and have come from SQL Server
and Windows

Is there any good link thats high level that compares Windows to z/os
mainframe terminology ? I hear the mainframe guys talking about control
blocks, DL/I,etc. etc..

Also would love DB2 comparison with SQL Server

BTw, are there differences between DB2 on LUW different from DB2 on z/OS ?

Thanks

Jun 27 '08 #1
6 2642
F wrote:
I understand at a high level database concepts and have come from SQL
Server and Windows

Is there any good link thats high level that compares Windows to z/os
mainframe terminology ? I hear the mainframe guys talking about control
blocks, DL/I,etc. etc..

Also would love DB2 comparison with SQL Server

BTw, are there differences between DB2 on LUW different from DB2 on z/OS ?

Thanks
You will find some info out there on comparing DB2 with SQL Server.
Here's the main DB2 migration website:

http://www-306.ibm.com/software/data/db2/migration/

As for z/os concepts and terminology, you are talking about a different
world. There is just no one book or one link or one class. Some of what
you have heard is not really necessary to understand in the z/OS
environment as a DB2 DBA because there are others who's job it is to
manage that environment. There is a macro-level systems world (TSO,
SMP/E, DB2, IMS, z/OS, etc.) a micro-level systems world (control
blocks, storage, virtual memory, etc.) and a world within DB2. Perhaps
there is a z/OS textbook ... but I'm not sure you really need it as a
DB2 DBA.

Larry Edelstein
Jun 27 '08 #2
F
Thanks Larry.

Btw, what are the roles and responsibilitie s of a DB2 DBA on Z/OS ? I want
to put out a job description. Any reference that you can suggest that might
be a good fit ?
"Larry" <la***@nospam.n etwrote in message
news:Ic******** *************** *******@comcast .com...
>F wrote:
>I understand at a high level database concepts and have come from SQL
Server and Windows

Is there any good link thats high level that compares Windows to z/os
mainframe terminology ? I hear the mainframe guys talking about control
blocks, DL/I,etc. etc..

Also would love DB2 comparison with SQL Server

BTw, are there differences between DB2 on LUW different from DB2 on z/OS
?

Thanks
You will find some info out there on comparing DB2 with SQL Server. Here's
the main DB2 migration website:

http://www-306.ibm.com/software/data/db2/migration/

As for z/os concepts and terminology, you are talking about a different
world. There is just no one book or one link or one class. Some of what
you have heard is not really necessary to understand in the z/OS
environment as a DB2 DBA because there are others who's job it is to
manage that environment. There is a macro-level systems world (TSO, SMP/E,
DB2, IMS, z/OS, etc.) a micro-level systems world (control blocks,
storage, virtual memory, etc.) and a world within DB2. Perhaps there is a
z/OS textbook ... but I'm not sure you really need it as a DB2 DBA.

Larry Edelstein
Jun 27 '08 #3
F wrote:
I understand at a high level database concepts and have come from SQL
Server and Windows

Is there any good link thats high level that compares Windows to z/os
mainframe terminology ? I hear the mainframe guys talking about
control blocks, DL/I,etc. etc..
Comparing Windows to z/OS is like comparing a Piper Cup aeroplane to a 747.
You did ask a similar rather broad question on z/OS on March 9th, did you
read my response (from the next day) where I pointed you to the "z/OS Basic
Skills Information Center":
http://publib.boulder.ibm.com/infoce...oc/lcmain.html
(please read my original response for more detailed info)
>
Also would love DB2 comparison with SQL Server
Given you already have knowledge from SQL Server, you would have to read
some documentation on DB2 for that.
Which documentation depends on the type of info you want to compare
(sysadmin/dbadmin/developer) but a good starting point would be the "DB2
Information Center":
- for DB2 on z/OS:
http://publib.boulder.ibm.com/infoce...v2r2/index.jsp
- for DB2 on LUW:
http://publib.boulder.ibm.com/infoce...w/v9/index.jsp
>
BTw, are there differences between DB2 on LUW different from DB2 on
z/OS ?
On sysadmin/dbadmin level: very much so, for a developer (i.e. on the SQL
level): not many.

HTH.

--
Jeroen


Jun 27 '08 #4
F wrote:
Thanks Larry.

Btw, what are the roles and responsibilitie s of a DB2 DBA on Z/OS ? I
want to put out a job description. Any reference that you can suggest
that might be a good fit ?
Craig Mullins has written quite a few articles and even a book on this very
subject:
http://www.craigsmullins.com/dba_book.htm
(the book is not specific for DB2, but Craig's background is mainly DB2 on
z/OS)
The Table of Contents for the book might give you some ideas:
http://www.craigsmullins.com/dba_toc.htm

HTH.

--
Jeroen
Jun 27 '08 #5
F wrote:
Thanks Larry.

Btw, what are the roles and responsibilitie s of a DB2 DBA on Z/OS ? I
want to put out a job description. Any reference that you can suggest
that might be a good fit ?
"Larry" <la***@nospam.n etwrote in message
news:Ic******** *************** *******@comcast .com...
>F wrote:
>>I understand at a high level database concepts and have come from SQL
Server and Windows

Is there any good link thats high level that compares Windows to z/os
mainframe terminology ? I hear the mainframe guys talking about
control blocks, DL/I,etc. etc..

Also would love DB2 comparison with SQL Server

BTw, are there differences between DB2 on LUW different from DB2 on
z/OS ?

Thanks

You will find some info out there on comparing DB2 with SQL Server.
Here's the main DB2 migration website:

http://www-306.ibm.com/software/data/db2/migration/

As for z/os concepts and terminology, you are talking about a
different world. There is just no one book or one link or one class.
Some of what you have heard is not really necessary to understand in
the z/OS environment as a DB2 DBA because there are others who's job
it is to manage that environment. There is a macro-level systems world
(TSO, SMP/E, DB2, IMS, z/OS, etc.) a micro-level systems world
(control blocks, storage, virtual memory, etc.) and a world within
DB2. Perhaps there is a z/OS textbook ... but I'm not sure you really
need it as a DB2 DBA.

Larry Edelstein

Perhaps

http://articles.techrepublic.com.com...1-6036261.html, or just
google "Roles and Responsibilitie s" "DB2 DBA" and "z/OS".

Good luck.

Larry Edelstein
Jun 27 '08 #6
"F" <f@hotmail.comw rote in message
news:fu******** **@registered.m otzarella.org.. .
>I understand at a high level database concepts and have come from SQL
Server and Windows

Is there any good link thats high level that compares Windows to z/os
mainframe terminology ? I hear the mainframe guys talking about control
blocks, DL/I,etc. etc..

Also would love DB2 comparison with SQL Server

BTw, are there differences between DB2 on LUW different from DB2 on z/OS ?

Thanks
Control blocks and DL/I refer to database software than runs on z/OS, but
not DB2 database software.

The biggest obstacle for a SQL Server DBA with no mainframe experience is
learning the z/OS operating system, including TSO, JCL, CICS, etc. It also
helps to know something about the programming language being used by the
developers you are supporting, which is usually COBOL.

From a administrative (DBA) point of view, DB2 for z/OS is significantly
different from DB2 for Linux, UNIX, Windows. At the programming level (DML)
they are fairly close to the same.
Jun 27 '08 #7

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

Similar topics

4
18855
by: Erik-Jan Bakker | last post by:
Hi I am not a javascript expert and I have a problem that the guru's in this newsgroup probably can solve quickly. ;-) I've made a webpage with three frames: top, left and mainframe. I defined this in a frameset called index.htm. Each frame is loaded with a specific page: top:title.htm, left:menu.htm and mainframe:start.htm. So far so good...
4
5038
by: karpagam | last post by:
Since WebServices are a standardized way to invoke a method of another application over the internet, is there a way to integrate two different applications running on different platforms (Say a .NET client application, used for implementing the presentation logic, and a mainframe application that contains the business logic). Is there a way to call the .NET web service from the mainframe application / expose the buiness logic in the...
1
2255
by: uli2003wien | last post by:
Dear group, i am a seasoned DB2-veteran (6 years exp.) on the Windows- and Linux-Server platform. Once in a while i had a look into DB2 on the mainframe but mostly only watching other people do the job. Currently i have an offer to go into a very big shop which runs DB2 on the mainframe (OS is not yet specified, but they talk about VSAM, so it will be no UNIX on mainframe). From my knowledge DB2 on Linux or Windows is a different...
1
2179
by: Thureen | last post by:
I just started using the mainframe (z/OS) 2 days ago, so I am very inexperienced in it. However, I need to write c++ programs for mainframe. Right now, the other mainframe programmers have showed me a complicated (seemed very complicated and painful to me) on how to compile, link, and execute using JCL (job control language) on the mainframe. However, I don't know JCL and those JCL files are quite confusing to figure how to edit them for...
3
5392
by: dinoo | last post by:
Hi, I need help here. I am converting an vb application to c#. The existing application connects to the mainframe server using FTP and downloads a file (dataset). Is it possible in .NET to avoid FTP and use any providers to connect to the mainframe server and download a file. I would appreciate if someone can give a reference to a link or code.
0
8711
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9314
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9020
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7953
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6636
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5948
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4726
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3158
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2523
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.