Pro Tips on Managing Data at Scale
As a DBA I worked on a number of projects fighting fires and putting them off successfully. However in the beginning of my career I was not sure where to start, as I matured as a DBA there is a pattern that developed to troubleshoot performance issues. Each of the following areas need different kind … Read more
Problem: How would you generate a report of the top 10 most active tables of your DB2 database ? To be more precise how would you generate a list of top 10 tables that are being Read/Inserted/Updated/Deleted and also against which most table scans are happening ? Solution: Use the following SQL to generate a … Read more
Problem: I was contacted by fellow team members saying replication from their non-Db2 RDBMS to DB2 has been running with a lot of latency and they are noticing slowness specifically with deletes. Third party Replication software logs are also logging that latency is on the target Db2 side. This is not a recurring problem as … Read more
Problem Statement: A redundant index in my book can have one or more leading columns that match with any other existing index leading columns on a given table. As a DBA I worked in many places where this is a reccurring problem. Many DBA’s are hesitant to drop these redundant indexes despite number of disadvantages … Read more
In this blog post I am going to talk about how DB2 optimizer can underestimate or overestimate join ratios or cardinalities resulting from join operations and a few other situations. This topic is very broad and need multiple other blog entries to cover in detail. However in this blog post at a very high level … Read more
Problem: You would like to find out quickly how much space your tablespaces are utilizing and how much space is being wasted below the high watermark with in a tablespace, how would you look for it ? While there are multiple ways to pull out that information but ever since MON_GET functions were introduced I … Read more
Transaction Logging: In this short blog post I am going to cover transaction logging, its importance and how to measure logging performance. Transaction logging is needed by RDBMS to ensure Durability, the last alphabet in (ACID) principles. If you are a DBA, you must know about ACID (Atomicity, Consistency, Isolation and Durability) principles and ARIES … Read more
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.