What kind of a mainframe blog doesn't mention DB2's 25th birthday? I hang my head in shame. DB2 celebrated its birthday on the 7th July this year, and like a forgetful relative, I don't send a card until a 4 month later. But, finally, here is my take on 25 years of DB2.
DB2 - which stands for DataBase 2 - first saw the light of day as an MVS application in 1983. It is a relational database and uses SQL (Structured Query Language) - pronounced SQL by mainframers and "sequel" by non-mainframers, apparently. Where did it come from? In the 1970s, Ted Codd created a series of rules for relational databases, which DB2 was very loosely based on. However, originally, DB2 did break many of Codd's rules. There was also a VM product called SQL/DS, which was similar in nature.
As well as MVS (or z/OS as it's called in its current incarnation), DB2 is available on other platforms. During the 1990s versions were produced for OS/2 (if you remember that one) Linux, Unix, and Windows. There have been a variety of naming conventions over the years. Things like DB2/VSE and DB2/6000, which were replaced by DB2 for VSE and then DB2 UDB (Universal DataBase). This current naming convention can make it harder to work out whether a mainframe version of DB2 or a server version of DB2 is being discussed in any article on the topic. Interestingly, although mainframe and server versions of DB2 are currently very similar in functionality, they are written in different languages. The mainframe version is written in PL/S and the server version in C++.
In the early days, the big competition was Oracle and Informix. Well, IBM bought Informix in 2001, and happily runs Oracle on a zLinux partition. There is also a 31-bit version of Oracle available for z/OS.
Of course, DB2 isn't IBM's only database. It has its relational IMS DB. People interested in IMS DB will be interested in the Virtual IMS Connections user group at www.virtualims.com.
As they say, other mainframe databases are available, including: CA-Datacom, CA-IDMS, Cincom's SUPRA, Computer Corporation of America's Model 204, Select Business Solutions' NOMAD, and Software AG's Adabas.
DB2 is currently at Version 9, which you might remember was code-named Viper before its launch.
Happy belated birthday DB2.
Saturday, November 22, 2008
Arcati Mainframe Yearbook ..IIs Back for 2009
I used this attention-grabbing headline so I can tell you that the Arcati Mainframe Yearbook is back for another year - or it will be very soon. The celebrated Arcati Mainframe Yearbook is one of the very few vendor-independent sources of information for mainframe users.
The Arcati Mainframe Yearbook has been the de facto reference work for IT professionals working with z/OS (OS/390) systems since 2005. It includes an annual user survey, an up-to-date directory of vendors and consultants, a media guide, a strategy section with papers on mainframe trends and directions, a glossary of terminology, and a technical specification section. Each year, the Yearbook is downloaded by 10,000 to 15,000 mainframe professionals. Last year's issue is still available at www.arcati.com/newyearbook08.
At the moment, the compilers of the Yearbook are hoping that mainframers will be willing to complete the annual user survey, which is at www.arcati.com/usersurvey09. The more users who fill it in, the more accurate and therefore useful the survey report will be. All respondents before the 5th December will receive a PDF copy of the survey results on publication. The identity and company information of all respondents is treated in confidence and will not be divulged to third parties.
Anyone reading this who works for a vendor, consultant, or service provider, can ensure their company gets a free entry in the vendor directory section by completing the form at www.arcati.com/vendorentry. This form can also be used to amend last year's entry.
As in previous years, there is the opportunity for organizations to sponsor the Yearbook or take out a half page advertisement. Half-page adverts (5.5in x 8in max landscape) cost $500 (UK£250). Sponsors get a full-page advert (11in x 8in) in the Yearbook; inclusion of a corporate paper in the Mainframe Strategy section of the Yearbook; logo/link on the Yearbook download page on the Arcati Web site; a brief text ad in the Yearbook publicity e-mails sent to users. Price $1700 (UK£850).
So, get cracking and complete the user survey so it's the most comprehensive survey ever.
The Arcati Mainframe Yearbook 2009 will be freely available for download early in January next year.
The Arcati Mainframe Yearbook has been the de facto reference work for IT professionals working with z/OS (OS/390) systems since 2005. It includes an annual user survey, an up-to-date directory of vendors and consultants, a media guide, a strategy section with papers on mainframe trends and directions, a glossary of terminology, and a technical specification section. Each year, the Yearbook is downloaded by 10,000 to 15,000 mainframe professionals. Last year's issue is still available at www.arcati.com/newyearbook08.
At the moment, the compilers of the Yearbook are hoping that mainframers will be willing to complete the annual user survey, which is at www.arcati.com/usersurvey09. The more users who fill it in, the more accurate and therefore useful the survey report will be. All respondents before the 5th December will receive a PDF copy of the survey results on publication. The identity and company information of all respondents is treated in confidence and will not be divulged to third parties.
Anyone reading this who works for a vendor, consultant, or service provider, can ensure their company gets a free entry in the vendor directory section by completing the form at www.arcati.com/vendorentry. This form can also be used to amend last year's entry.
As in previous years, there is the opportunity for organizations to sponsor the Yearbook or take out a half page advertisement. Half-page adverts (5.5in x 8in max landscape) cost $500 (UK£250). Sponsors get a full-page advert (11in x 8in) in the Yearbook; inclusion of a corporate paper in the Mainframe Strategy section of the Yearbook; logo/link on the Yearbook download page on the Arcati Web site; a brief text ad in the Yearbook publicity e-mails sent to users. Price $1700 (UK£850).
So, get cracking and complete the user survey so it's the most comprehensive survey ever.
The Arcati Mainframe Yearbook 2009 will be freely available for download early in January next year.
Subscribe to:
Posts (Atom)