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 ...

DB2 Load From Cursor Command Generator

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

DB2 Finding Top 10 Most Active Tables ?

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

Db2 SQL And SQL Tuning

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

DB2 Finding Duplicate Rows

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

Slow Hash Joins In pureScale

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

DB2 Server Build Best Practices!

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

How To Find Redundant/Unused Indexes ?

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

Alternative(s) To db2cluster command To Display GPFS Configuration

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

What Are Column Group Statistics ?

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

How To Measure Tablespace Utilization In DB2 ?

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

DB2 How To Measure Transaction Log Write Time ?

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

DB2 pureScale Cluster Slowness During Index Creation

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

How To Find Missing Indexes On Foreign Key Columns ?

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

Linux Tips And Tricks For DBA’s

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

How To Perform Db2 Alternate Restore Using NetBackup ?

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

Troubleshoot Db2 Backup Issues With Veritas NetBackup

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

How To Configure DB2 To Use NetBackup ?

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

How To Perform DB2 Loads in HADR Environment ?

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

DB2 How to Lower High Water Mark For DMS Tablespaces ?

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

Download db2utils

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

How To Deep Compare Two Db2 Environments?

What is DB2 Deep Compare ? Have you ever tried ...

Useful DB2 resources:

Db2 Knowledge Center V10.5

Db2 Knowledge Center V11.1

International Db2 Users Group(IDUG)

Top Posts & Pages

Follow me on Twitter

Shares

Share This

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