(Srinidhi Hiriyannaiah, Sunil Perla and Dev Sarkar) Learn how to capture the changes made on source transactional databases such as IBM DB2 and Oracle, and replicate them to the Apache Hadoop Distributed File System in IBM InfoSphere BigInsights. Use change data capture replication technology in In

(Troy Coleman) An SQL statement can be executed by an application with either static or dynamic text. Each type of statement execution has its own benefits. The biggest reason to use static SQL is to avoid the overhead with preparing a statement for execution.

(Craig S. Mullins) Today’s posting is a re-blog of a post I wrote several years ago for another blog (that has since been discontinued). But I think the subject matter is important enough that it warrants re-blogging… So I touched it up and made a few changes here and there to make sure links still

(Nikunj Panchal and Subramanian Krishnan) The CryptoService Activity introduced in WebSphere Cast Iron 7.0 lets you encrypt and decrypt content with PGP. While it is possible to decrypt the content encrypted by Cast Iron in the application itself, there are times when a user might want to encrypt co

(Dave Beulke) These days, flexible computing power, application functionality, and data accessibility are paramount. Having the best application is only part of winning the constant IT battle of applying technology to increase the company’s bottom line.

(Roman Kharkovski) What are the primary reasons to use Message Oriented Middleware (MOM) in an application today? Why would you install, configure and manage this extra “layer” in your already complex architecture? Why not use HTTP, or sockets, or IIOP, or POP3, or Atom, etc. There are several usefu

(Kurt Struyf) Recently, in the previous article, “The Power’s in the Rebind,” I focused on performance enhancements available in IBM DB2 11 for z/OS data management software, particularly because of the rebind capability. Here, the focus is on some improvements that require an intervention from the

(Willie Favero) This post is going to be pretty short this afternoon. I’ve been talking with a lot more people lately that are messing around with LOBs. So when I saw this APAR show up that takes care of of the reuse of free space, I thought I would pass it along.

(Ember Crooks) When does case matter in DB2? Well, it doesn’t unless it does. Nice and clear, huh?

(Patric Becker and Frank Neumann) High availability systems are usually a requirement in business critical environments and can be implemented by redundant, independent components. A failure of one of these components will be detected automatically and their tasks are taken over by another component