(W. H. Inmon) There are lots of ways to look at big data. One way is to look at the sheer volume of data. Some types of data are more voluminous than others. The trading of stock on any of the stock exchanges is one example. When looking at every trade of every share, a day’s worth of trading would

(Robert Catterall) Recently, a mainframe DB2 DBA put a question to me: when should DB2 for z/OS native SQL procedures be used versus Java stored procedures, and vice versa?

(Kelly Schlamb) When I tell my friends I’ll be going to Vegas for IBM Insight, there’s a bit of eye rolling along with a sarcastic “yeah, sounds like hard work… say hi to the blackjack dealer for me”.

(Madhavi Kota and Aparna Srinivasan) This article series shows you how to enable dynamic authentication connectors in WebSphere Cast Iron Studio. Part 1 shows you how to dynamically provide the connection parameters and connection pool options for authentication in WebSphere Cast Iron for SAP and HT

(Joe Geller) How many copies of your databases do you have? I’m talking about both how many test databases with test data as well as full copies of your production data. In many shops, developers are well behaved and get along nicely. They share test databases. If they have to have their own data t

(Joe Pluta) The more integrated the IBM i gets, the more ways it needs to touch other systems. Tools abound that allow us to stretch beyond the boundaries of traditional DB2 data into everything from XML to PDF to ZIP files.

(Yan Feng Han and Hao Zhang) Temporal tables were introduced in IBM DB2 10 for z/OS and enhanced in V11. If you have to maintain historical versions of data over several years, temporal tables can be helpful for period-based data. In this tutorial, explore how your applications can use temporal tabl

(Ahmed Fattah) Some industry professionals believe data integration is an extremely challenging problem that may never be completely solvable. Because cloud-based analytics solutions are very likely to encompass distributed data, processes, and line-of-business users, it will probably require a grea

(Alex Woodie) As an IBM i system administrator, it’s your job to ensure that data in DB2 for i is available where it’s needed. No server is an island these days, not even the IBM i-based Power Systems servers, and so that means replicating data to external databases is a requirement.

(Lockwood Lyon) Big data applications are now fairly commonplace in large organizations. They typically begin as part of an information technology (IT) project that will extract, store and analyze large amounts of existing data in order to reduce costs, predict customer buying patterns, speed produc