(Greg Flurry) Last month’s article shows you how to connect non-HTTP service requesters and providers to the IBM WebSphere Application Server V6 Service Integration Bus. This lets requesters and providers leverage the integration capabilities of an enterprise service bus. In this continuation we pi

DB2 Universal Database (DB2 UDB) FixPaks are general FixPaks that can be applied on all DB2 UDB products. This includes DB2 Connect, with the exception of Windows platforms.

(Jin Ji Wen and Shen Yu) In today’s rapidly changing business climate, collecting, organizing, and displaying valuable information effectively is key for an organization to be able to make good business decisions. The OLAP (Online Analytical Processing) Web application is the right choice to present

(Craig S Mullins) I received an e-mail from a reader asking an interesting question. She wanted to know if any of the DB2 unload utilities are able to include the column names in the same file as the unload output data. This was a requirement because one of the applications her company was planning

(Mike Faust) One thing that makes SQL such a powerful language is the ability to do statistical analysis and create a summary in a single SQL statement. This can be achieved through the use of aggregate or columnar functions, which allow you to create total- or subtotal-level summaries. Subtotal-lev

(Doug Doole) When storing multilingual data in a DB2 UDB database, Unicode is often the only encoding that can accommodate the entire range of data. While DB2 can store and process Unicode data, its collation (sorting) capabilities are restricted to binary collations and three cultural collation

(Lisa Vaas) Coinciding with IBM’s release of its freebie DB2 version— DB2 Universal Database Express-C (Community Edition)—on Jan. 30, partners rolled out an ecosystem to support it, with news coming from ActiveGrid, Mandriva, Zend Technologies and Net Integration Technologies.

(Allan Tham, Cengiz Satir and Edward Huang) IBM offers many information management products, solutions, and services. Deciding which fits your need best can be overwhelming. This series of articles introduces the IBM Content Management family products for a better understanding and positioning of ea

(Jean-Paul Lamontre) SQL Visual Explain tool, which comes with iSeries Navigator, is a very handy tool that helps you to improve the performance of your SQL statements. If you haven’t had the opportunity to try it, I highly recommend it. You can find the Visual Explain tool here. If you have used it

(Philip Gunning) Regardless of how well a RDBMS performs, the monitoring of SQL statements and resources is required to ensure continued good performance and to identify problem areas. Using the information gathered, adjustments can be made to instance and database configuration parameters, physical