9/24/2017

9/24/2017

By Vinay Kumar



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

9/21/2017

9/12/2017

4/17/2017

4/10/2017

4/10/2017

By Vinay Kumar



15 comments

Step by Step installation of DB2 V10.5 on Linux

Installation:

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 need to have some disk and memory space for the installation.
Lets take a look at that.

2/18/2017

2/18/2017

By Vinay Kumar



No comments

Performance information that we have to take from users

Performance information that users can provide

We can notice the system tuning is required when first we get a complaint from the users. 

Performance_Tuning_DB2


When we do not have enough time to change the performance tuning objectives, we can know the performance statistics by asking few questions to the users who complains us about the performance degrade.

we can usually determine where to start looking for a problem by asking a few simple questions.
Those are..

1/27/2017

1/27/2017

By Vinay Kumar



2 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

ads