To understand on a deep level how DB2 for LUW executes your SQL, you need to understand the concepts of agents, subagents, sections, and subsections. DB2, especially with the Data Partitioning Feature (DPF), takes advantage […]
Tag: snapshot monitor
db2top Sessions Screen (Part 3)
In the first post on the Sessions screen, we examined the gauges and table columns that appear when the screen is 80 to 140 columns wide. In the second post, we saw what additional columns […]
db2top Sessions Screen (Part 2)
In the previous post on the Sessions screen, we looked at the gauges and table columns that make up the default screen. In today’s post, we will examine all the extra information that becomes available […]
db2top Sessions Screen (Part 1)
Today we will take our first detailed look at the Sessions screen. The sessions screen lets you view applications connected to the database and see what they’re doing and how many resources they are consuming.