(Pitipong JS Lin, Li Fan, Yin Long, Stefa Etchegaray Garcia and Jyotishko Biswas) This IBM Redpaper publication presents the process and steps that were taken to move from an R language forecasting solution to an IBM SPSS Modeler solution. The paper identifies the key challenges that the team faced

(Craig S. Mullins) Perhaps the single most important aspect of SQL tuning is indexing. All developers should know all of the indexes that exist on any table upon which they write SQL statements. When an index exists on a column (or columns), DB2 can use the index to reduce I/O instead of scanning th

(Scott) 100% of our studio audience learned something! Today’s presentations were GREAT and included topics on MON_GET_DATABASE, Configuring UOW Event Monitor, IBM Performance Analysis Suite, Connecting DB2 LUW to Microsoft Access, SQL Injection and Exception Handling via Stored Procedures, taming a

(Sherif Ali, Jagdish Komakula, Isa Torres, David Van de Pol and Donald Vines) This article series addresses a recent trend among many IT organizations to move their existing Java EE applications from Full Platform Java EE servers, such as WebLogic Server, Oracle Application Server, and JBoss Applica

(Thuan Bui, Marcia Miskimen, Somil Kulkarni and Shannon Rouiller) IBM Data Server Manager is a new, integrated tool for managing performance and administering DB2 for Linux, UNIX, and Windows databases. This tutorial starts with a brief introduction of Data Server Manager and a high-level explanatio

(Ember Crooks) While using SQL to look at statistics overall is often useful, sometimes we need to look at or report on only a specific subset of tables.

(Joe Pluta) In previous articles (parts 1 and 2), we began to explore DB2’s pureXML capabilities. While DB2 provides exceptional XML data-handling, it’s not enough to simply be able to store and retrieve XML data. In any real world business application, you’ll also need to integrate that XML data wi

(Mike Collins, Zi Hui Duan, Andreas Fried, Ben Hoflich, Chris Richardson and Torsten Wilms) This IBM Redbooks publication provides performance tuning tips and best practices for IBM Business Process Manager (IBM BPM) V8.5.5 (all editions) and IBM Business Monitor V8.5.5.

(Roman Kharkovski) This article describes results of the persistent messaging performance tests that I carried out in the last 2 months using IBM MQ v8.0 (formerly WebSphere MQ) and Apache ActiveMQ 5.11.

(Lockwood Lyon) Many companies have implemented big data applications. These applications consist of a very large data store, hybrid hardware and software to store and access the data, and a sophisticated software interface that accepts the queries of business analysts, accesses the data store, and