(Troy Coleman) For years IBM has been warning people that DB2 private protocol would go away. With DB2 V9, it became official — DB2 private protocol has been deprecated. As a result, you need to plan a migration path to convert all your existing plans and packages from DB2 private protocol to DRDA.

(Prakash C. Singh) Sometimes people around you ask a simple question: What is the size of a particular database or a particular table?

(Dave Beulke) The new release of IBM DB2 9.7 for Linux, UNIX, and Windows offers many advantages for better performance, better maintenance, and lower total cost of ownership, especially for large and robust databases. But after exploring the new version myself, what strikes me most about the featur

(Kent Milligan) As documented in a previous TechTip, the Database Monitor is a great tool for collecting SQL performance data. However, you must apply great care when using this tool because it can cause significant disk activity on your system and quickly consume disk space. Recently, IBM introduce

(Leons Petrazickis) SQL6031N Error IN the db2nodes.cfg file at line number “1”. Reason code “10”.

(Kathryn Zeidenstein, Cliff Leung, Tony Leung and Ray Willoughby) As good as IBM DB2 is at optimizing query performance, tuning SQL statements sometimes requires skilled human intervention. There are those who have built careers around their deep knowledge of how to tune SQL to achieve optimized per

(Robert Catterall) Last week, a friend who works for a big DB2-using company in the American Midwest sent me a question concerning the migration of native SQL procedures from DB2 subsystem A to subsystem B (e.g., from a development to a test subsystem, or from test to production). This person’s orga

Curt Cotner, VP & CTO for IBM Data Management, interviewed by Rav Ahuja about new features in DB2 9 for z/OS. (video)

(Wei Liu) IBM InfoSphere Data Architect (IDA) is a comprehensive development environment for data modeling and integration. IDA enables users to discover, model, visualize, and relate diverse and distributed data assets. IDA is an integrated data management offering from IBM and is tightly integrate

(Gene Cobb) In my previous article “OmniFind, Part I: Add Sizzle to Your SQL with OmniFind Text Search Server for DB2 for i,” I introduced IBM OmniFind Text Search Server for DB2 for i , a new IBM i 6.1 product that provides the ability to perform both basic and sophisticated text searching against