{"id":14,"date":"2008-10-23T13:36:59","date_gmt":"2008-10-23T12:36:59","guid":{"rendered":"http:\/\/www.askthegerman.com\/?p=14"},"modified":"2023-02-13T07:37:15","modified_gmt":"2023-02-13T06:37:15","slug":"differences-between-db2-vs-oracle","status":"publish","type":"post","link":"https:\/\/www.askthegerman.com\/?p=14","title":{"rendered":"Differences between DB2 and Oracle"},"content":{"rendered":"<blockquote>\n<h4>General Differences between DB2 and Oracle<\/h4>\n<\/blockquote>\n<ul>\n<li>A DB2-Instance can serve several independent&nbsp; DB2-databases <\/li>\n<li>One DB2-Instance is referenced by an OS-User with similar name <\/li>\n<li>The home directory of the OS-User is the instance home directory <\/li>\n<li>DB2 does not know about user administration <\/li>\n<li>DB2 user are authenticated by Operating System Users or <br \/>  Directory Services e.q. NIS, LDAP,AD <\/li>\n<li>There is one Alertlog per Instance called db2diag.log <\/li>\n<li>A DB2-database is started on demand by the first connection <\/li>\n<li>there is no ROLLBACK-\/UNDO-Management in DB2\n<ul>\n<li>Oracle:&nbsp;&nbsp; Multi Version Read Consistency <\/li>\n<\/ul>\n<ul>\n<li>DB2:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ANSI standard Isolation levels<br \/>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Repeatable Read, Read Stability, Cursor Stability<br \/>  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; and Uncommitted Read (Dirty Read) <\/li>\n<\/ul>\n<p>Further Information about: <a title=\"DB2 Online Documentation\" target=\"_blank\" href=\"http:\/\/www-128.ibm.com\/developerworks\/db2\/library\/techarticle\/dm-0401gupta\/index.html\" rel=\"noopener\">DB2 Online Documentation<\/a> <\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>General Differences between DB2 and Oracle A DB2-Instance can serve several independent&nbsp; DB2-databases One DB2-Instance is referenced by an OS-User with similar name The home directory of the OS-User is the instance home directory DB2 does not know about user administration DB2 user are authenticated by Operating System Users or Directory Services e.q. NIS, LDAP,AD [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,6,5],"tags":[13,256,258,12,11,257,9,10],"class_list":["post-14","post","type-post","status-publish","format-standard","hentry","category-database","category-db2","category-oracle","tag-ad","tag-database","tag-db2","tag-ldap","tag-nis","tag-oracle","tag-rollback","tag-undo"],"_links":{"self":[{"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=\/wp\/v2\/posts\/14","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=14"}],"version-history":[{"count":16,"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=\/wp\/v2\/posts\/14\/revisions"}],"predecessor-version":[{"id":382,"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=\/wp\/v2\/posts\/14\/revisions\/382"}],"wp:attachment":[{"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=14"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=14"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=14"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}