Popular Posts
For when a first initial is all you can remember
db2top Federation Screen
Today’s topic is db2top’s Federation screen. Federation is a technology that allows you to build a heterogeneous set of database management systems into a single interface without requiring you to move all your data into one database. DB2 for LUW federation lets you query and perform transactions against Oracle, DB2 for z/OS, Microsoft SQL Server, [...]
db2top HADR Screen
HADR stands for High Availability Disaster Recovery. It is a technology that protects your database against data loss and allows it to be highly available even when you have a partial or complete site failure. It does this by replicating data changes from one database, called the primary, to another, called the standby. When your [...]
db2top Utilities Screen
A critical aspect of maintaining a database is getting the most current data possible into it. In data warehouses, this need is often met with extract-transform-load (ETL) technologies. DB2 for LUW addresses the loading aspect with a very sophisticated built-in load utility that makes it easy to load large amounts of data quickly into your [...]
db2top Statements Screen
Today’s topic is the Statements screen. Unlike the Dynamic SQL screen, the Statements screen lets you see both dynamic and static statements and it groups them by the applications in which they run. As with the Agent screen, you can use this screen to see the operation that a statement is in the middle of, [...]
db2top Memory Screen (Part 2)
In the first post on the db2top Memory screen, we examined the gauges and table that are visible at all screen sizes. We saw that we could differentiate between the various memory pools on the system and determine how much memory each was consuming in near real-time. We also saw that we could measure the [...]
Do db2top High Watermarks Give Wrong Answers?
I’m going to interrupt the two-part description of the db2top Memory screen I started last Friday because I need to address something that’s been bothering me about db2top. Having worked on the DB2 for LUW Workload Manager’s statistics functions, I am sensitive to seeing potential misuses of statistics. The Memory screen illustrates this problem perfectly. [...]
db2top Memory Screen (Part 1)
A well-tuned DB2 for LUW system strikes a careful balance among the various consumers of resources such as CPU, disk, and memory. Applications, utilities, and internal database processes all compete for limited memory resources. The db2top tool can give you insight into your biggest memory consumers using the Memory screen, which we will examine in [...]
db2top Dynamic SQL Screen
The first time I used db2top’s Dynamic SQL screen, I tried the ‘X’ key to switch to extended mode and had no idea what I had just done. Everything was reordered, hash values seemed to completely change, and the values in the Num Execution column shot upward. Eventually, I realized what was happening and I [...]
Categories
-
