ChannelDB2

Vinay Kumar Bommana's Blog (8)

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…

Continue

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…

Continue

Added by Vinay Kumar Bommana on September 24, 2017 at 6:53am — No 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 needs to have some disk and memory space for the…

Continue

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

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 …

Continue

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

ReadMore

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…

Continue

Added by Vinay Kumar Bommana on July 4, 2016 at 1:33pm — 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.... …

Continue

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

Featured Downloads

Try BLU Acceleration on Cloud

© 2018   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service