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 6 2647
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
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
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
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
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
"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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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...
|
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...
|
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...
|
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...
|
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.
| |
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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...
|
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();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |