The local and Remote binding in DB2 is a real time concept. It occurs when you deal with remote packages created elsewhere not in your local region.
Category: DB2 V11
What is DB2 PLAN, and why do we need it? Below, you will find detailed…
Point 1 – The best example for cursor WITH HOLD is, just imagine, you are…
Before going into advanced SOL, I want to give some information on data modelling :…
Pages and Pagesets of tablespaces in DB2. Explained how these are related and its differences.
CPU reductions and performance improvements for certain OLTP, heavy insert, select query workloads, and when…
The “COALESCE” function is one of the frequently used functions in DB2. Before going into…
How DB2 manages indexes. There are two popular indexes present in DB2. How to differentiate these two indexes explained in simplified way.
Knowing Primary Key on which column of Table it is defined is a tricky in mainframe zo/s DB2. This SQL query helps to find column name of table on which it is defined. Very useful query for mainframe developers working on DB2.
Srinimf 