8/29/2016
8/25/2016
How to setup logical data partitioning in DB2?
How to setup Logical Data Partition Step by Step:
What is Data Partitioning:
Present days databases and data warehouses become larger, this is somewhat complicated to maintain growth of the database. To avoid this and to manage the growth of the data IBM introduce the concept called "Database Partitioning Feature", "Table Partitioning" and Multi Dimensional Clustering".
In this article we are going look at "Database Partitioning Feature".
8/13/2016
Data concurrency in DB2 deep dive
DB2 concurrency basics
In a
multi-user database environment, transactions are usually executed
simultaneously. Each transaction has the potential to interfere with any other
transaction that is running. Without any appropriate locking mechanism, the
following undesirable effects may occur:
Lost
updates: Two
applications, A and B, might both read the same row from the database, and both
calculate new values for one of its columns based on the data these
applications read. If A updates the row with its new value and B then also
updates the row, the update performed by A is lost.