Autonomicity in Universal Database DB2

Abstract

Functionality, complexity, heterogeneity and dynamism in computing environment are increasing day by day. This enhanced utility of computers has a profound impact on the systempsilas brittleness, manageability and security. Self-management is important in systems, networks, communication as well as in Database Management Systems (DBMSs). Autonomic computing reduces the problems and increases accuracy and efficiency of the DBMSs. Recent years have seen an upsurge in research related to incorporation of autonomic computing within the computing systems. IBM is working on autonomic computing in systems and DBMSs from last many years. The paper discussed the autonomic features and tools in DB2 from the literature available up to 2002. Our paper presents an extension of that paper which covers available autonomic features, components, utilities and tools up till now. A comparison of DB2 with Oracle is presented w.r.t autonomic computing. We have also identified the optional and essential human intervention (HI) in autonomic components, utilities and tools of IBM Universal Database DB2 that reveals the degree of autonomic computing in these.