{"id":2965,"date":"2012-02-12T19:36:25","date_gmt":"2012-02-13T01:36:25","guid":{"rendered":"http:\/\/bucktownbell.com\/?p=2965"},"modified":"2012-10-17T11:31:53","modified_gmt":"2012-10-17T16:31:53","slug":"db2-the-secret-database","status":"publish","type":"post","link":"http:\/\/bucktownbell.com\/?p=2965","title":{"rendered":"DB2 &#8211; the secret database"},"content":{"rendered":"<blockquote><p>Certainly, according to the Winter Corporation\u2019s 2005 survey, the largest OLTP (On-Line Transaction Processing) databases in the world are hosted on DB2. The volume prize goes to the Land Registry at 23.1 TB and the prize for the number of rows goes to UPS \u2013 89.6 billion; both run on DB2.<\/p><\/blockquote>\n<p>via <a href=\"http:\/\/www.theregister.co.uk\/2006\/01\/18\/db2_neglected\/\">DB2 &#8211; the secret database \u2022 The Register<\/a>.<\/p>\n<blockquote><p>DB2 has always ruled in the mainframe environment: on that platform it has no peer. In 1996 (ten years ago!) IBM made all the right technical moves to expand the use of DB2 down to the mini and even the PC markets. DB2 was produced in three versions. These have had various names over the years &#8211; UDB (Universal DataBase) was often used but it now being gently dropped by IBM. The most useful names I\u2019ve come across are:<\/p>\n<p>\u2022 DB2 for z\/OS (Mainframe)<\/p>\n<p>\u2022 DB2 for iSeries (AS400 as was)<\/p>\n<p>\u2022 DB2 for LUW (Linux, UNIX and Windows)<\/p><\/blockquote>\n<p>Dated 18 January 2006.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Certainly, according to the Winter Corporation\u2019s 2005 survey, the largest OLTP (On-Line Transaction Processing) databases in the world are hosted on DB2. The volume prize goes to the Land Registry at 23.1 TB and the prize for the number of &hellip; <a href=\"http:\/\/bucktownbell.com\/?p=2965\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[156,490,489,250],"class_list":["post-2965","post","type-post","status-publish","format-standard","hentry","category-technical","tag-databases","tag-ibm","tag-mainframes","tag-oldnews"],"_links":{"self":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts\/2965","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2965"}],"version-history":[{"count":3,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts\/2965\/revisions"}],"predecessor-version":[{"id":7577,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts\/2965\/revisions\/7577"}],"wp:attachment":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2965"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2965"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2965"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}