All Blog Posts (287)

Installing DB2 Express C 9.7 on Ubuntu

1. Ubuntu Install

First step is to install Ubuntu server. We will use version 8.04 LTS, because this version is recommended and tested for DB2 version 9.7. LTS means Long Term Support and Ubuntu server 8.04LTS is maintained until April 2013. Projected end of support date… Continue

Added by Radim Kolar on June 24, 2020 at 5:30pm — No Comments

Basic concepts that are useful to design and implement a successful backup strategy in db2

The following concepts are critical to designing and implementing a successful backup strategy:

  • --> Balanced table spaces are the primary factor
  • --> Difference between system managed space (SMS) and database managed space (DMS)             tablespaces
  • --> What pages are included in an incremental or delta backup…


Added by Vinay Kumar Bommana on September 24, 2017 at 6:57am — No Comments

Basic concepts that are useful to design and implement a successful backup strategy in db2

The following concepts are critical to designing and implementing a successful backup strategy:

  • --> Balanced table spaces are the primary factor
  • --> Difference between system managed space (SMS) and database managed space (DMS)             tablespaces
  • --> What pages are included in an incremental or delta backup…


Added by Vinay Kumar Bommana on September 24, 2017 at 6:53am — No Comments

Step by Step installation of DB2 V10.5 on Linux


There are total three types of installations in DB2. Those are:

==> Using DB2SETUP (GUI)

==> Using Command Prompt

==> Using Response file

This article lets you know steps to install DB2 using db2setup (GUI). 

Disk and memory requirements:

Each product needs to have some disk and memory space for the…


Added by Vinay Kumar Bommana on April 10, 2017 at 3:00am — 1 Comment

Learn how to use R with Databases

R is a powerful language for data analysis, data visualization, machine learning, statistics. Originally developed for statistical programming, it is now one of the most popular languages in data science.

If you are a database professional (Data Engineer, DBA, Database Developer, etc.) and looking to leverage the power of R to analyze and visualize data in relational databases (RDBMSes), Big Data U (BDU) has a free, self-paced online course to get you going quickly:…


Added by Rav Ahuja on February 27, 2017 at 12:40pm — No Comments

How Will Logging Process happen in DB2?

What is a Log:

Log is nothing but a transaction log. A transaction log is a file which stores the history of actions executed by a database management system, which is used to recover at the time of crashes.

All databases maintain log files that keep records of database changes.

Types of logging strategy choices:

1. Circular logging

2. Retain log records …


Added by Vinay Kumar Bommana on January 27, 2017 at 10:54am — No Comments

What are the DB2 LUW DBA daily activities?

Just like a high performance sports car, a database requires some checks to keep it running optimally. This article is broken down into tasks or checks that can be run at different intervals on your DB2 LUW database, to do just that. Read more

Added by Vinay Kumar Bommana on September 8, 2016 at 5:04am — No Comments

DB2 Important Commands


Added by Vinay Kumar Bommana on September 1, 2016 at 10:44am — No Comments

Overview of LOCK ISSUES in DB2

How many of you know that locks will also use memory? Yes they uses a a certain amount of…


Added by Vinay Kumar Bommana on July 4, 2016 at 1:33pm — No Comments

Maximize Your Data Infrastructure Investments with DB2

IBM's  conversations with clients have revealed a consistent challenge across several organizations – the need to drive incremental value from existing infrastructure investments.   If you are looking for innovative ways to leverage your investments and the ability to deploy workloads across on premise and in the cloud without loss of performance in a secure manner, IBM is hosting a Webinar on June 14th

I wanted to share with you details of the DB2  Webinar on 14th June at…


Added by Sajan K on June 7, 2016 at 10:13am — No Comments

DB2 11.1 release simplifies deployment and key management

Matt Huras - Chief Architect, DB2 for Linux, Unix and Windows has shared this great article discussing some of the high-value, core advances in security, availability and performance with the recently announced DB2 11.1 for Linux, UNIX and Windows.

This article is Part 1 of a 2-part Blog series.  The article discusses the following

  • Core Database Advances with DB2 11.1
  • Enhancements to Enterprise Key Management…

Added by Sajan K on April 28, 2016 at 4:00am — No Comments

Service class time component

Hi everyone,

In order to analize system performance I tried to discover how time is spent within my database system.

According to the documentation, TOTAL_RQST_TIME=TOTAL_WAIT_TIME + TOTAL_*_PROC_TIME.

By querying the service class table function (MON_GET_SERVICE_CLASS) I'm disappointed by the fact that there is a big difference between total_rqst_time and the sum of all other values.

It seems that with "normal" DML statements these two values are quite…


Added by Alessandro Oppici on April 24, 2016 at 2:58am — No Comments

Performance monitoring tools and methodology

Operational monitoring of system performance

Operational monitoring refers to collecting key system performance metrics at periodic intervals over time. This information gives you critical data to refine that initial configuration to be more tailored to your requirements, and also prepares you to address new problems that might appear on their own or following software upgrades, increases in data or user volumes, or new application deployments.... …


Added by Vinay Kumar Bommana on March 9, 2016 at 11:30pm — No Comments

DB2 LUW Migration from AIX P6 Box to P8 Box (In 7 Minutes..)

Have you come across a scenario where you need to migrate your databases db2 LUW from AIX P6 Box to P8 box and you couldn't perform a redirected restore as this could be time consuming activity.

Below is link where you can learn quickly how to migrate db2 luw in 7 minutes

DB2 LUW Migration from AIX P6 Box to AIX P8 Box.

DB2 LUW migration from AIX P6…


Added by Rohit Kumawat on March 9, 2016 at 5:49am — No Comments

DB2 + transactional + Data + Performance Techniques

I have a table A with 30,000 Records.

Module B  selects the data from the table A.

This  module B is  called  via online(CICS) and Batch mode.

This Module  is called 30 million times in day. 20% of traffic is via Online mode and 80% of traffic is via Batch Mode.

In a second this Table is referred 30 times and in a minute 4500 times.

Each time Module B is triggered it selects data from Table A.

Whenever I do a select to table A. IO is caused and by…


Added by Satya on January 18, 2016 at 11:16am — No Comments

Existe Particionamiento de la base de datos en mi servidor ¿cómo me doy cuenta?

Mis Comentarios Técnicos

Empezaremos esta entrega hablando de unos de las implementaciones tal vez menos conocidas, es la referida al particionamiento en un servidor. En especial nuestro interés es más bien estratégico y queremos enseñarles como sabe usted que esta ante una instalación de este tipo. Para ello hemos estructurados dos partes, en la primera aprenderemos a darnos cuenta que estamos antes este tipo de instalación y entender su arquitectura estratégica y la segunda, donde…


Added by SENDEROPRESS on December 13, 2015 at 5:37pm — No Comments

What's new on the BLU Acceleration hub?

Lots of new content is available on, a site that is focused on BLU Acceleration in-memory computing for fast reporting and analytics from the transaction environment or a warehouse environment.  Here is a summary of some content you may want to check out:

  • What's new for BLU Acceleration in DB2 10.5 "Cancun Release", especially BLU Shadow Tables that let you perform operational reporting in the…

Added by Cindy Russell on September 26, 2014 at 9:41am — No Comments

Oracle Toplink Setup in DB2

Oracle Toplink:-

Oracle TopLink supports access to any data store accessible through standard JDBC using standard SQL.

Additionally TopLink offers database platforms that allow for specific functionality to be exposed such as

native SQL, sequencing, out-join syntax, custom date/timestamp operators and formats, and schema import

and generation with the mapping editors.

To setup Oracle Toplink please follow the below steps :-

1.We need to identify the…


Added by Ramya on September 18, 2014 at 5:41am — No Comments

How to overcome DB2 database corruption issues

IBM is one of the many companies who manufacture server line of products. IBM DB2 is one of the most commonly used server type. For each of the major operating systems, IBM has a specific DB2 product. However, in the recent past it has been seen that IBM has developed a platform-independent server product. In addition to the relational model, it supports object-based features and non-relational structures like XML.

The DB2 performs various management related operations like create,… Continue

Added by Mark Willium on July 8, 2014 at 11:00pm — No Comments

How to create Federated Procedures in DB2 10.5

This post is useful for DB2 developers, administrators, database architects to learn how to access Oracle database

stored procedures from DB2 database sources.

A federated system is a special type of distributed database management system (DBMS).

A federated system consists of a DB2® database system that operates as a federated server, a database that acts

as the federated database, one or more data sources, and clients (users and applications) that access the…


Added by Ramya on June 24, 2014 at 4:01am — No Comments

Monthly Archives













Featured Downloads

Try BLU Acceleration on Cloud

© 2021   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service