(Harishkumar Baburao Pathangay) Conceal/Mask/Hide your critical business logic in Database using Obfuscation of DDLs.
Tag: IBM
DB2 to the Cloud: A Case Study
(Philip Nelson) Let me introduce you to the infrastructure of a project I’ve been working on recently:
TechTip: DB2 for i HTTP Functions, Part 2: Request and Response Header Fields
(Michael Sansoterra) In the first tip, I introduced the new suite of HTTP functions in DB2 for i 7.1 and demonstrated the HTTPGETCLOB and HTTPGETBLOB scalar functions. I’ll continue the topic by considering how to include and retrieve HTTP header information with each request. This tip assumes you h
Query Acceleration for Business using Informix Warehouse Accelerator
(Whei-Jen Chen, Nigel Campbell, Martin Fuerderer, Frederick Ho, Holger Kirstein, Keshava Murthy and Ramanathan Sivaguru) IBM Informix Warehouse Accelerator (IWA) is a state-of-the-art in-memory database designed to exploit affordable innovations in memory and processor technology and trends in novel
DB2 Tips n Tricks Part 10 – Find Paths used by Database from Backup image
(Harishkumar Baburao Pathangay) How to Find Storage and Table space Paths used by Database from Backup image only.
Column Organized Table Storage in DB2 10.5 with BLU Acceleration
(Chris Eaton) I’ve blogged on competitors and the advantages of BLU acceleration over those competitors so now it’s time to dig deeper into the technology inside of BLU. This week we will talk about columnar storage, next week we will look deeper into the simplicity in BLU and then in subsequent blo
Developing a distributed WS-AT transaction using an IBM BPM Advanced Integration Service, Part 2: Configuring the transaction support
(Carlo Randone and Marco Antonioni) Leveraging the capabilities of the Advanced Integration Services (AIS) in IBM Business Process Manager V8.0.1 Advanced, this series describes the implementation of a distributed WS-AT scenario involving two databases (Microsoft SQL Server and IBM DB2) installed on
Big Data Disaster Recovery: 4 Reasons Why DB2 Cloning is Excellent
(Dave Beulke) Big Data disaster recovery is a big issue. Of course, any Big Data business sponsor vows that the entire Big Data database is necessary, and demands it be included in the disaster recovery plans.
DB2 Naming Standards
(Ember Crooks) Last week, I read this article by Craig Mullins: http://bitonthewire.wpengine.com/articlesection/default.aspx?TargetID=70585. Go read it, this blog entry will still be here when you get back.
Why low cardinality indexes negatively impact performance
(Ember Crooks) Low cardinality indexes can be bad for performance. But, why? There are many best practices like this that DBAs hear and follow but don’t always understand the reason behind. This article empowers DBAs to understand the logic behind why low cardinality indexes can be bad for performan