(Scott Hayes) In the next few blog posts, we’ll take a look at formulas for time metrics so that we can understand “where the time goes” and uncover bottlenecks. Since both OLTP and Data Warehouse databases perform a great deal of I/O read activity, we’ll begin by looking at metrics for computing im

(Michael Sansoterra) Stored procedures are great tools for easily delivering the results of one or more queries (aka result sets) to a client/server or Web application. (For a brief outline of this technique from the client side, see “Retrieve Multiple Result Sets from a Stored Procedure.”) However,

(Robert Catterall) Poor DB2 Connect. It’s a good piece of code. It really is. It gets SQL requests from off-mainframe requesters (PCs, for example, as well as Linux, UNIX, and Windows-based application servers) to DB2 for z/OS using DB2’s Distributed Relational Database Architecture protocol (aka DR

(Mohankumar Saraswatipura and Swetha Prasad) The self tuning memory manager (STMM) is a revolutionary memory tuning feature that was first introduced in IBM DB2 9. The STMM eases the task of memory configuration by automatically setting optimal values for most memory configuration parameters, includ

(Vasfi Gucer, Ana Godoy, Fabrizio Salustri, Ghufran Shah and John Willis) IBM Tivoli Monitoring Version 6.2 is a powerful monitoring product from IBM , that is easily customizable and provides real-time and historical data that enables you to quickly diagnose and solve issues via the IBM Tivoli Ente

(Ajay Aggrwal) IBM Database tools for Microsoft Visual Studio 2005 introduces a new set of Web service-oriented features that expose the latest DB2 pureXML functionality. The new release provides the means for a dramatic increase in developer productivity. The new IBM Database Add-ins for Visual Stu

(Willie Favero) DB2 9 for z/OS went generally available (GA) on March 16, 2007; that’s over 8 months ago. Have you started to make plans to upgrade yet? You haven’t? Why not? Do you have any idea how much functionality you are missing out on. Sure, DB2 Version 8 may be one of the more significant DB

(Willie Favero) I thought I would do a little self promotion today and let anyone who is within driving distance of Costa Mesa, CA that I will be presenting next week at LA Area DB2 User Group meeting on December 6, 2007. I’m hoping that I will get to see a lot of friends from the LA area at the […]

(Michael Pastore) Today’s enterprises create a lot of digital content, and there’s no shortage of places to keep it. The content we create finds its way to company intranets, project workspaces, desktop PCs, and networked storage. It’s structured, it’s unstructured, it’s in e-mails, and it’s on hard

(Timothy Prickett Morgan) The bits are barely cool on z/VSE V4.1, which started shipping in March after a January launch this year, and IBM is already putting out a technology preview of its VSE V4.2 operating system. In general, technology previews mean Big Blue is getting ready to ship a product i