473,322 Members | 1,314 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,322 software developers and data experts.

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 2628
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 responsibilities 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.netwrote 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 responsibilities 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 responsibilities 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.netwrote 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 Responsibilities" "DB2 DBA" and "z/OS".

Good luck.

Larry Edelstein
Jun 27 '08 #6
"F" <f@hotmail.comwrote in message
news:fu**********@registered.motzarella.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
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...
4
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...
1
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...
1
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...
3
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.