Tag: IBM

Community

db2top Agent Screen (Part 2)

(Keith McDonald) In part 2 of this series on the db2top Agent screen, you will see just how much more detailed the Agent screen becomes on DB2 systems that have the Data Partitioning Feature (DPF). Not only can you see the individual subsections of an executing statement, but also how they are proce

Community

db2top Agent Screen (Part 1)

(Keith McDonald) 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 of parallelism, not only in running large numbers of SQL s