|
The DB/2 Resource – Directory & Links
From Mainframes.in – Home of Legacy & Mainframes Online
|
|
The DB/2 section of Mainframes.in provides a listing of WWW resources for DB/2 database. Mainframes.in is a comprehensive online resource for legacy and mainframe systems.
..
..
Add Links: If you have a web site that you wish to include in this directory, do let us know the details by sending a note about your URL to narsi@esource.in. We’ll quickly review the web site, and if found relevant, add it to the database. We look forward to web site owners and link exchange partners to submit URL. Thanks!
Contents derived from the Wikipedia article on DB2
IBM DB2
Jump to: navigation, search DB2 is IBM's line of RDBMS (or, as IBM now calls it, data server) software products within IBM's broader Information Management software line. Although there are different "editions" and "versions" of DB2 which run on devices ranging from handhelds to mainframes, most often DB2 refers to IBM's flagship relational database management system DB2 Enterprise Server Edition or the top of the line DB2 Data Warehouse Edition (DB2 DWE) which runs on Unix, Windows or Linux servers.
Contents
1 History 2 Editions 3 Competition 4 Technical information 5 Leadership 6 See also 7 References 8 External links
History DB2 has a long history and was what some consider to be the first database product to use SQL.
The name DB2 was first given to the Database Management System or DBMS in 1982 when IBM released SQL/DS and DB2 on its mainframe platform. Prior to this, the product was named System Relational, or System R, which launched in 1978. DB2 has its roots back to the beginning of the seventies where Dr. E.F. Codd, working for IBM, described the theory of relational databases and in June of 1970 published the model for data manipulation. To apply the model Codd needed a relational database language which he named Alpha. IBM didn't believe in Codd's idea's potential, leaving its implementation to a group of programmers who weren't under Codd's supervision, violating several fundamentals of the relational model; the result was Structured English QUEry Language or SEQUEL. SEQUEL was already a trademarked name, so IBM renamed the acronym to SQL, short for Structured Query Language. The acronym SQL still stands to this day.
Historically, it is interesting to note that when Informix acquired Illustra and made their database engine an object-SQL DBMS by introducing their Universal Server, both Oracle and IBM followed suit by changing their database engines to be capable of object-relational extensions. Moreover, in 2001, IBM bought Informix and in the following years incorporated Informix technology into the DB2 product suite. Technically, today, DB2 can be considered to be an object-SQL DBMS.
For many years DB2 was exclusively available on IBM mainframes. Later IBM brought DB2 to other platforms, including UNIX and Windows servers, then Linux (including Linux on zSeries) and PDAs. This process was mainly undertaken through the 1990s. The inspiration for DB2's implementation details came in part from IBM DL/1 and IBM IMS, both initially hierarchical and then later network (or CODASYL) databases. DB2 is also embedded in the i5/OS operating system for IBM System i (iSeries, formerly the AS/400), and versions are available for z/VSE and z/VM. An earlier version is available for OS/2 and is called DB2/2.
Over the years DB2 has driven numerous hardware enhancements, particularly on IBM System z with such features as Parallel Sysplex data sharing. In fact, DB2 UDB Version 8 for z/OS now requires a 64-bit system and cannot run on earlier processors, and DB2 for z/OS maintains certain unique software differences in order to serve its sophisticated customers. Although the ultimate expression of software-hardware co-evolution is the IBM mainframe, to some extent that phenomenon occurs on other platforms as well, as IBM's software engineers collaborate with their hardware counterparts.
In mid 2006, IBM announced "Viper," the codename for DB2 9 on distributed platforms and for V9.1 on z/OS. IBM claims that the new DB2 will be the first relational database to "natively" store XML. Other enhancements include OLTP-related improvements for distributed platforms, business intelligence/data warehousing-related improvements for z/OS, more self-tuning and self-managing features, additional 64-bit exploitation (especially for z/OS), stored procedure performance enhancements for z/OS, and continued convergence of the SQL vocabularies between z/OS and distributed platforms.
DB2 9 began shipping worldwide on July 28, with pricing starting at $4,874 per processor or $165 per user (minimum of 5 users) for DB2 9 Express.[1]
Editions DB2 is available in several "editions," i.e. licensing arrangements. By opting for a reduced-feature "edition," IBM allows customers to avoid paying for database features which they do not need. Sample editions include the Workgroup, Workgroup Unlimited, and Enterprise Server Edition. At the high-end, is DB2 Data Warehouse Enterprise Edition, or DB2 DWE for short. This edition is intended for mixed workload (OLTP and data warehousing) or business intelligence (BI) implementations. DB2 DWE includes several "BI" features such as ETL, data mining, OLAP acceleration, and in-line analytics.
DB2 for z/OS is available under its own licensing terms. Starting with Version 8, IBM brought DB2for z/OS and for the other platforms into much closer alignment. (Previously there were significant differences in SQL vocabularies, for example.) DB2 for z/OS has some exclusives — notably Multi-Level Security (MLS), extremely large table sizes, and hardware-assisted compression — owing to its special environment and the demanding needs of its customers. DB2 for z/OS has always been known for its leading OLTP performance and capabilities, but the z/OS version is now starting to acquire BI features as well, such as materialized query tables (MQTs). Oracle's CEO Larry Ellison commented that DB2 for z/OS is the one competitive database he respects and admires[2].
On January 30th, 2006, IBM released a no-charge edition of DB2 called DB2 9 Express-C. This was an expected response to the recently announced free versions of Oracle 10g and Microsoft SQL Server. Express-C will have no limit on number of users or database size. It is deployable on Windows and Linux machines with up to two processors and up to 4GB of memory.
Competition Historically, prime position in the database management software market has tightly alternated between DB2, Oracle and Teradata. On May 3, 2004, IBM's head of database development and sales, Janet Perna, claimed their main competitors were Oracle in the context of advanced transaction handling and Teradata in the context of decision-making systems (e.g. data warehousing). However, there are competitors in smaller markets, including Microsoft SQL Server (which is only available for Microsoft Windows), open source products such as PostgreSQL and MySQL, and niche players such as Sybase.
DB2 for z/OS arguably has fewer direct competitors, but Oracle is attracting customers to its Linux on zSeries products, although apparently not at the expense of DB2. CA-Datacom and Software AG's Adabas are competing relational databases for z/OS, and there are certain niche products as well (Model 204, SUPRA SQL[1], NOMAD, etc.) Oracle has a 31-bit RDBMS available for z/OS. Non-relational databases that "compete" include IMS, VSAM (arguably), and CA-IDMS, among others.
IBM and DB2 are frequently at or near the top of the TPC-C and TPC-H industry benchmarks published on the Transaction Processing Performance Council's website.
In 2006 IBM stepped up its competition in the emerging data warehouse appliance market by releasing a product line of pre-configured hardware/software systems combining DB2 Data Warehouse Edition with either IBM system p (AIX) or IBM system x (Linux)servers. This family of "warehouse appliance-like" systems was given the name: IBM Balanced Configuration Unit (BCU) and it aimed at the Netezza, DATAllegro, etc. warehouse appliance market but differentiates in that it uses the full-featured version of DB2 instead of a single-purpose warehouse-oriented RDBMS.
Technical information DB2 can be administered from either the command-line or a GUI. The command-line interface requires more knowledge of the product but can be more easily scripted and automated. The GUI is a multi-platform Java client that contains a variety of wizards suitable for novice users.
DB2 has APIs for .NET CLI, Java, Python, Perl, PHP, Ruby on Rails, C++, C, REXX, PL/I, COBOL, RPG, FORTRAN, and many other programming languages. DB2 also supports integration into the Eclipse and Visual Studio .NET integrated development environments.
Leadership Janet Perna was General Manager of IBM Software Group's Information Management division until her retirement from IBM in July, 2005. She was replaced by Ambuj Goyal[2].
See also Geneva ERS
References ^ IBM press release June 8, 2006 ^ "In Larry's Own Words", October, 2003
External links DB2 product family home page DB2 Data Warehouse Edition home page DB2 resources for developers Ambuj Goyal's IBM Research home page DB2 Portal for Mainframe Users DB2usa - Links to DB2 for z/OS documents available on the web DB2 XML Wiki (pureXML) DB2 Discussion Forum
IBM[hide] Hardware Products: Cell microprocessor | Cloudscape | Mainframe | PC | POWER Software Products: AIX | DB2 | Lotus Notes | OS/2 | WebSphere | Workplace See also: IBM India | IBM PC compatible | IBM Public License | List of IBM acquisitions and spinoffs | List of IBM products
Annual Revenue: $91.1 billion USD (FY 2005) | Employees: 329,373 (2005) | Stock Symbol: NYSE: IBM | Website: www.ibm.com
Preceding: SQL/DS, Datalog Subsequent:
Topics in database management systems (DBMS) ( view • talk • edit ) Concepts Database | Database model | Relational database | Relational model | Relational algebra | Primary key - Foreign key - Surrogate key - Superkey Database normalization | Referential integrity | Relational DBMS | Distributed DBMS | ACID
Objects Trigger | View | Table | Cursor | Log | Transaction | Index | Stored procedure | Partition Topics in SQL Select | Insert | Update | Merge | Delete | Join | Union | Create | Drop Comparison of syntax
Implementations of database management systems Types of implementations Flat file | Deductive | Dimensional | Hierarchical | Object oriented | Temporal
Products db4o | dBASE | Oracle | Caché | OpenLink Virtuoso | Sybase | Ingres | MySQL | SQLite | Microsoft SQL Server | PostgreSQL | InterBase | Firebird | DB2 | Informix | Helix database | Teradata | Comparison - relational | Comparison - object-relational Components Query language | Query optimizer | Query plan | ODBC | JDBC Lists List of object-oriented database management systems List of relational database management systems List of truly relational database management systems
End of Wikipedia content, http://en.wikipedia.org/wiki/IBM_DB2
Main Sections @ Mainframes.in
Legacy Operating Systems > Midrange, Mainframe Legacy Databases > DB2, IMS DB/DC, VSAM, CA/IDMS, Unidata Legacy Programming & Development
Legacy Hardware > Mainframe Hardware, Midrange Hardware
Legacy & Non-legacy > Legacy & Contemporary OS, Legacy & Contemporary Databases, Legacy & Networking, Legacy & Contemporary Programming Languages, Legacy & Mainframe Migration
..
..
Other IT Resources
eIT.in – IT & Software Directory & Resources
Software > Operating Systems, Databases, Programming & Development, Mainframe & Legacy, Internet & Web
Hardware, Networking & Communications, IT Strategy & Design, IT in Industries, IT in Functions, IT Infrastructure, Tech Support, IT Industry & Trade Network, IT News & Updates
Mainframes.in provides directory and web links resources for the legacy, mainframes and midrange systems. It is intended to be useful for mainframe programmers & developers, midrange programmer & developer, legacy & mainframe databases software development, administrators & DBAs, application developers, mainframe strategy architect, legacy design specialists and architects, mainframe & legacy migration consultants and analysts, administration, maintenance & support professionals, mainframe & legacy outsourcing consultant, legacy solutions programming developers & coders, project management & functional analyst, and for mainframe, midrange, system administrators, testing & quality control engineers. It will make an effort to provide resources on tutorial/tutorials, guide/guides, tips, faq/faqs on these mainframe and legacy topics.
Reference
GeoDig – Get Local!
Have you checked out the GeoDig directories for over 30 countries? GeoDig provides useful local and regional web resources for over 200 cities around the world. See the list of cities and countries for which GeoDig provides locality-specific web resources.
North America USA - Alabama (AL) > Birmingham; Alaska; Arkansas (AR) > Little Rock; Arizona (AZ) > Phoenix, Las Vegas, Tucson; California (CA) > Los Angeles, San Francisco, Sacramento, Fresno, Bakersfield; Colorado, CO > Denver; Connecticut, CT > Hartford; District of Columbia, DC > Washington DC; Delaware (DE) > Wilmington; Florida > Miami, Orlando, Tampa, Orlando, Sarasota, West Palm Beach, Jacksonville; Georgia > Atlanta; Hawaii > Honolulu; Idaho; Illinois > Chicago; Indiana > Indianapolis; Iowa; Kansas (KS); Kentucky (KY) > Louisville; Louisiana (LA) > New Orleans, Baton Rouge; Maine; Maryland (MD) > Baltimore; Massachusetts > Boston, Springfield; Michigan > Detroit, Grand Rapids; Minnesota > Minneapolis-St. Paul; Mississippi (MS); Missouri (MO) > Kansas City, St. Louis; Montana; Nebraska (NE) > Omaha; Nevada (NV) > Las Vegas; New Hampshire; New Jersey (NJ) > Jersey City, Newark; New Mexico (NM) > Albuquerque; New York > New York, Buffalo, Rochester, Albany, Syracuse; North Carolina (NC) > Raleigh-Durham, Charlotte, Greensboro; North Dakota; Ohio> Columbus, Cincinnati, Cleveland, Toledo, Youngstown, Dayton; Oklahoma (OK) > Oklahoma City, Tulsa; Oregon > Portland; Pennsylvania > Philadelphia, Allentown, Pittsburgh, Harrisburg, Scranton, ; Rhode Island (RI) > Providence; South Carolina (SC) > Greenville; South Dakota; Tennessee (TN) > Knoxville, Memphis, Nashville; Texas > Austin, Dallas, Houston, San Antonio, El Paso, Austin, McAllen; Utah (UT) > Salt Lake City; Vermont; Virginia (VA) > Norfolk, Richmond; Washington > Seattle; West Virginia; Wisconsin (WI) > Milwaukee; Wyoming Canada - Vancouver, Montreal, Toronto, Calgary, Ottawa-Gatineau, Edmonton, Quebec City, Winnipeg, Hamilton, London
Europe - UK - London, Glasgow, Manchester, Birmingham, Liverpool, Sheffield, Leeds, Bristol, Edinburgh, Leicester; France - Paris, Marseille, Lyon, Toulouse, Nice, Nantes, Strasbourg, Montpellier, Bordeaux; Germany - Frankfurt (Frankfurt am Main), Munich (München), Berlin, Düsseldorf, Hamburg, Cologne (Köln), Essen, Dortmund, Stuttgart, Bremen, Duisburg, Hannover, Nürnberg (Nuremberg), Dresden, Leipzig; Italy - Milan (Milano), Rome (Roma), Napoli (Naples), Torino (Turin), Palermo, Bologna, Firenze (Florence), Genova (Genoa); Spain - Madrid, Barcelona, Valencia, Sevilla, Zaragoza, Malaga, Murcia, Las Palmas, Bilbao; Scandinavia - Finland - Helsinki (Helsingin), Espoo, Tampere (Tampereen), Vantaa, Turku, Oulu, Sweden - Stockholm, Goteborg (Göteborg), Malmo (Malmö), Uppsala, Vasteras (Västerås), Denmark - Copenhagen (Københavns), Aarhus (Århus), Odense, Aalborg (Ålborg), Norway - Oslo, Bergen, Stavanger, Trondheim; Benelux - Belgium - Brussels (Brussel), Antwerp (Antwerpen), Ghent (Gent, Gand), Charleroi, Liège (Liege), Netherlands - Amsterdam, Rotterdam, Utrecht, Eindhoven, Tilburg, ‘s-Gravenhage (sGravenhage), Groningen, Luxembourg - Luxembourg City; Portugal – Lisbon; Greece – Athens; Hungary – Budapest; Poland – Warsaw; Switzerland - Zürich (Zurich), Geneva (Geneve, Genève), Basel, Bern (Berne), Lausanne; Austria - Linz, Vienna (Wien), Graz, Linz, Salzburg, Innsbruck; Ireland – Dublin
Asia - India - Mumbai, New Delhi, Bangalore; China & Hong Kong - Hong Kong, Beijing, Shanghai, Tianjin, Wuhan, Shenyang, Guangzhou, Harbin, Xian; Japan - Tokyo, Osaka, Yokohama, Nagoya, Sapporo, Kyoto, Kobe, Fukuoka, Kawasaki, Hiroshima; South Korea - Seoul, Pusa, Taegu, Incheon, Taejeon, Taiwan - Taipei; Malaysia - Kuala Lumpur; Singapore; Russia - Moscow, St Petersburg
Middle East - Turkey - Istanbul, Israel - Tel Aviv
Oceania - Australia - Sydney, Melbourne, Brisbane, Perth, Adelaide
Africa - South Africa - Johannesburg, Cape Town, Durban
|
Web Co-ordinator: Narasimhan Santhanam ( narsi@esource.in )
© 2004 – 05, From Mainframes.in – Home of Legacy & Mainframes Online