New Era in Distributed Computing with Blockchains and Databases

A new era is emerging in the world of distributed computing with the growing popularity of blockchains (shared, replicated and distributed ledgers) and the associated databases as a way of integrating inter-organizational work. Originally, the concept of a distributed ledger was invented as the underlying technology of the cryptocurrency Bitcoin.

Read more ...

IBM Claims Big Breakthrough in Deep Learning

A Fortune article by Barb Darrow. Few interesting highlights: IBM used 64 of its own Power 8...
Read more ...

DB2 Backup Tuning

One of my colleague Mukesh V Desai did backup tuning for a pureScale customer and just by making...
Read more ...

DB2 pureScale Utility Scripts

Most of the utility scripts here are given for Linux using bash shell. You can use them after...
Read more ...

Data Server Manager 2.1.4

DSM new release announced on June 22, 2017
Read more ...

DB2 11.1 BLU with DPF Monitoring scripts

I just wrapped a very large PoC for BLU with DPF with very high ingestion rate (110K messages per...
Read more ...

db2haicu disable / enable and scripting

It is recommended that you always update RSCT / TSA from db2 software media and not from IBM Fix...
Read more ...

DB2 pureScale – No Product License found

In db2diag, you may see this message - No product license found. Sample output:...
Read more ...

DB2 pureScale instance creation hangs after GPFS

Hang Issue due to SMAP While creating DB2 pureScale instance, it appears that the node becomes...
Read more ...

DB2 pureScale Health Check

More and more customers are now asking for some way to check the health of the DB2 pureScale...
Read more ...

How to detect log full condition

I have seen working with hundreds of customers a chronic LOG FULL condition and the shortcut...
Read more ...

Kernel upgrade and impact on pureScale

In Linux environment, it is a common practice to upgrade the kernel for security patches,...
Read more ...

GPFS Disk Cleanup

During pureScale instance creation, you might run into instance creation failed condition. Under...
Read more ...

SQL fishing using WLM

The SQLs while DB2 is up and running can be captured in different ways such as: Query column...
Read more ...

Automatic Client Reroute – Templates

Here are two templates that one can use to make Automatic Client Reroute to work properly in a...
Read more ...

Rebuild TSA Resources in HADR Environment

This is about how to rebuild TSA resources in HADR environment if you have used db2haicu in past...
Read more ...

DB2 11.1 Rebuild TSA Resources

When you get errors like this: "SQL1517N db2start failed because the cluster manager resource...
Read more ...

DB2 pureScale Install Problem Determination

RSCT License Issue $ db2start 128 SQL1677N  DB2START or DB2STOP processing failed due to a DB2...
Read more ...

DB2 purescale Install GPL Error

GPL Compile Problem When you try to install DB2 pureScale on Linux platform (RHEL or SLES), you...
Read more ...

db2start add member fails

If you try to add a member to a running cluster, you may get the following db2start error. ERROR:...
Read more ...

Core DB2

When my manager interviewed me in June 2004, I proclaimed that I was an expert in DB2. After many years working in IBM, I am still learning. It is a joy working in IBM with many talents. I learn new IBM’s technology and then demonstrate them to our customers.

High Availability

I help many customers to fine tune and monitor High Availability & Disaster Recovery (HADR). I also help them implement Tivoli System Automation with HADR for the automation of failover. This is one of my favorite topic.

DB2 pureScale

When DB2 pureScale feature arrived in 2008, I have been working since then on this technology. I have built pureScale systems from ground up and did several Proof of Concepts and numerous pureScale presentations to our customers. This technology fascinates me.

BLU

BLU for DPF – do columnar databases in a shared nothing architecture. This is the topic on which I am very passionate and I share this knowledge with customers through Proof of Concepts, Proof of Technology, demo etc.