Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Why it is called DB2 ?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Nov 06, 2008 5:36 pm    Post subject: Why it is called DB2 ?
Reply with quote

Hi ALL,

I have been having been wondering about this for a long time.
I google'd but, i couldn't find the answer. what i want to know is......

Why it is CALLED DB2 ?
I know DB - DataBase.
I want to know the reason for the number "2".
First when i heard about the number. I thought, it was the version number.
Later came to know that, it is not the version number

My another question is, which is the first DATABASE ?

I got this from wikkipedia,

ORACLE
Quote:
Larry Ellison and his friends and former co-workers Bob Miner and Ed Oates started the consultancy Software Development Laboratories (SDL) in 1977. SDL developed the original version of the Oracle software.

1979: SDL changed its company-name to "Relational Software, Inc." (RSI) and introduced its product Oracle V2 as an early commercially-available relational database system.


This i got from a blog,
Quote:
In 1980, Oracle version 2 was released and with it RSI became the first ever company to release a commercial relational database using SQL.

IBM DB2
From wikkipedia,
Quote:
DB2 has a long history and is considered by many to have been the first
database product to use SQL (also first developed by IBM).

The name DB2 was first given to the Database Management System or DBMS in 1983 when IBM released DB2 on its MVS mainframe platform.


My 2 basic questions.....
What is the reason the letter 2 in DB2 ?
Which is the first DATABASE(ORACLE or DB2 or is there somthing else) ?

Since, i am working on DB2, i am getting questions such as this....

Please clarify and clear my doubt ?
I know this sounds little childish to ask ?


Please ENLIGHTEN me,
Sushanth Bobby
Back to top
View user's profile Send private message

Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1232
Location: Israel

PostPosted: Thu Nov 06, 2008 5:59 pm    Post subject: Reply to: Why it is called DB2 ?
Reply with quote

In Israel, we had (back in the 80's) a product called DB1.
AFAIK, it still exist today, being the database used by Sapiens, a 4th generation language.

That may be why IBM had to choose DB2!?
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1232
Location: Israel

PostPosted: Thu Nov 06, 2008 6:07 pm    Post subject:
Reply with quote

Oh, I forgot to say that DB1 does not use SQL, so the following is still valid:
Quote:
DB2 has a long history and is considered by many to have been the first
database product to use SQL (also first developed by IBM).
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Nov 06, 2008 6:11 pm    Post subject:
Reply with quote

Oh THANK YOU! THANK YOU! THANK YOU!
MARSO.............

For this precious information.....

Sushanth
Back to top
View user's profile Send private message
Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Thu Nov 06, 2008 6:15 pm    Post subject: Reply to: Why it is called DB2 ?
Reply with quote

Some DB2 History

http://wiki.ibmdatabasemag.com/index.php/DB2_History_--_A_Timeline#DB2_Debuts
Back to top
View user's profile Send private message
Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Thu Nov 06, 2008 6:20 pm    Post subject: Reply to: Why it is called DB2 ?
Reply with quote

Quote:
Name


http://it.toolbox.com/blogs/db2zos/what-is-in-a-name-9138
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Nov 06, 2008 6:35 pm    Post subject:
Reply with quote

Thank You Prasanth,
Those links were all interesting ones.......

Sushanth
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8117
Location: East Dubuque, Illinois, USA

PostPosted: Thu Nov 06, 2008 6:44 pm    Post subject:
Reply with quote

Quote:
Which is the first DATABASE(ORACLE or DB2 or is there somthing else) ?
IMS dates back to 1968. SYSTEM 2000 dates back to the late 60's or early 70's (I'm not sure how far back). IDMS was based on an earlier product developed in the early 60's. Hierarchical and network database structures were well understood by the mid to late 60's so several database software products were available. Relational databases for a mainframe didn't come around until 1983 with DB2, and DB2 was based on research IBM did on System R in the early to mid 70's.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Thu Nov 06, 2008 7:41 pm    Post subject: Reply to: Why it is called DB2 ?
Reply with quote

IIRC in the IBM world the precursors of database systems were
BOMP - born to support bill of material processing
and it's offpring
D-BOMP

BOMP was originally designed as a file access method for MRP ( material requirement and planning )
from some MRP blogs Gene Thomas invented BOMP in 1961
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Nov 07, 2008 1:19 am    Post subject:
Reply with quote

Hello,

Quote:
Which is the first DATABASE(ORACLE or DB2 or is there somthing else)
Oracle and DB2 are rather late-comers to the database engine game.

Before DB2, IBM had an offering called SQL/DS (which may have been IBM's first sql-based db).

As mentioned, IMS has been around since the late 60's. So were/are TOTAL, Datacom, Model204, and IDMS. I believe Adabas arrived in the early 70's.
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Fri Nov 07, 2008 6:12 am    Post subject:
Reply with quote

I heard many years ago that DB2 was given the number 2 because IMS was considered to be DB1 although it was never called that.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Nov 07, 2008 2:06 pm    Post subject:
Reply with quote

Thank You Guyz,
Sushanth Bobby
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Could we identify the called modules ... elixir1986 COBOL Programming 5 Fri Jul 14, 2017 1:53 am
No new posts How does a called pgm know if its cal... Graeme Westerman COBOL Programming 5 Tue Nov 29, 2016 9:25 pm
No new posts Cobol list of programs being called biswajit.dattagupta COBOL Programming 5 Tue Nov 01, 2016 2:10 am
This topic is locked: you cannot edit posts or make replies. How to supply called sub-program from... dchristensen JCL & VSAM 25 Wed Sep 14, 2016 11:36 pm
No new posts How to get the program name of callin... pkmurali COBOL Programming 8 Mon Aug 01, 2016 3:36 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us