Raghu On Tech

Pro tips on managing data at scale

Using MON_GET_PKG_CACHE_STMT To Identify Waits

  As a DBA I worked on a number of ...
Read More

DB2 Load From Cursor Command Generator

  Problem: Very often I work on moving data from ...
Read More

DB2 Finding Top 10 Most Active Tables ?

  Problem: How would you generate a report of the ...
Read More

Db2 SQL And SQL Tuning

  Its been a couple of months since I posted ...
Read More

DB2 Finding Duplicate Rows

  Problem: As a DBA, you may get asked by ...
Read More

Slow Hash Joins In pureScale

  Problem: I was contacted by fellow team members saying ...
Read More

DB2 Server Build Best Practices!

  The reason I am posting this article is I ...
Read More

How To Find Redundant/Unused Indexes ?

  Problem Statement: A redundant index in my book can ...
Read More

Alternative(s) To db2cluster command To Display GPFS Configuration

  While working in a pureScale environment, I learned that ...
Read More

What Are Column Group Statistics ?

  In this blog post I am going to talk ...
Read More

How To Measure Tablespace Utilization In DB2 ?

  Problem: You would like to find out quickly how ...
Read More

DB2 How To Measure Transaction Log Write Time ?

  Transaction Logging: In this short blog post I am ...
Read More

DB2 pureScale Cluster Slowness During Index Creation

  Problem: I work at a place where performance of ...
Read More

How To Find Missing Indexes On Foreign Key Columns ?

Problem Statement: You are trying to figure out if there ...
Read More

Linux Tips And Tricks For DBA’s

In this blog post I am going to discuss few ...
Read More

How To Perform Db2 Alternate Restore Using NetBackup ?

Task Description: You need to restore a Db2 database backup ...
Read More

Troubleshoot Db2 Backup Issues With Veritas NetBackup

Problem Statement: So you are a database administrator and you ...
Read More

How To Configure DB2 To Use NetBackup ?

Task Description: Configure Db2 LUW database and transactions log backups ...
Read More

How To Perform DB2 Loads in HADR Environment ?

Problem Statement: You need to run DB2 LOAD utility in ...
Read More

DB2 How to Lower High Water Mark For DMS Tablespaces ?

Problem Statement: Prior to DB2 V9.7, its a struggle to ...
Read More

Download db2utils

For Java runtime Environment 6(1.6):  For Java runtime Environment 7(1.7):  ...
Read More

How To Deep Compare Two Db2 Environments?

What is DB2 Deep Compare ? Have you ever tried ...
Read More
Shares
Share This

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close