(Scott Hayes) In this blog post, I will describe the most important cost metric that you MUST measure, and work to improve, to become a Performance Hero in your organization. This cost metrics is "Bufferpool Logical Reads per Transaction (BPLRTX)".

(Adekunle O Adio and Nicholas Geib) IBM’s Migration Toolkit (or MTK) is a free-to-use, free-support tool that helps you move off competitor databases and on to IBM data servers, both DB2® and Informix® Dynamic Server. If you’re new to MTK, check out these earlier articles.

(Bibhas Bhattacharya) Stored procedures are generally used to: –Build a library of common and non-trivial queries in a central location. –Locate read/write intensive queries inside the database server for maximum performance.

(ahk2chan) In order to use the DB2 explain tool, which shows you the access plan of a query, you need to setup the tables used by the tool.

(Ameet Kulkarni and Keri Tuttle) Experience a fast way to create and deploy components for IBM portal applications. During this tutorial, you will learn how to build a blog component in an easy-to-use, intuitive visual environment. You will then deploy your component and create a portal application.

(Vasfi Gucer, David Campbell, John M Crawford, Ignacio Fernandez, Nick Freer, Scott W Graham, Johan Raeymaeckers, Marc Remes, Ghufran Shah, Andrea Rodrigues Mendonca, Marc Remes, Fabrizio Salustri and Ghufran Shah) This IBM Redbooks publication is designed to focus on migration of a data center fr

(Catherine Griffen, Ruo Bo Huang, Zhang Sen and Marc Fiammante) This article shows how to automatically transform UML activity diagrams into WebSphere® Business Modeler processes. Requirements analysis is frequently performed using UML, creating activity diagrams to describe business processes. Howe

(ahk2chan) syscat.tables view let you look at DB2 table specific information. One piece of the information is when is the last time DB2 statistics were generated for a particular table, and the field is STATS_TIME. This field will be updated once DB2 runstat command is executed.

(Justin Whitney) As acronyms go, the ASP (Application Service Provider) has been dying a slow death. But as a distribution model, its ashes have given birth to a more robust concept based on rich interactivity and a more easily updateable codebase: Software as a Service, or SaaS.

(Serge Rielau) Porting an application with CONNECT BY, NVL, or other vendor specific SQL to DB2? Do not despair. DB2 Viper 2 for Linux, UNIX, and Windows understands. This article describes syntax and semantics added to DB2 to speak that other tongue.