Understanding table queues in DB2 for Linux, UNIX, and Windows

Communication between DB2 data partitions

In partitioned database environments, query processing requires data to be exchanged between database partitions. Table queues (often referred to as TQs) are the vehicle that DB2 uses for passing rows between partitions. This article provides an in-depth look at table queues, includes tips on how to identify whether a performance problem is due to TQ behavior, and explains what you can do to resolve such a problem.

David Sky (sky@ca.ibm.com), Senior Technical Writer, IBM

Author photoDavid Sky is a senior technical writer with the DB2 for Linux, UNIX, and Windows product team at the IBM Canada Lab in Markham, Ontario. He has worked on a wide range of DB2 documentation, and is currently responsible for several content areas in the DB2 Information Center, including SQL query performance. He holds a Bachelor degree in Artificial Intelligence from the department of Computer Science at the University of Toronto. He is currently collaborating with the DB2 best practices development team on a range of subjects.



Jamie Nisbet (jtnisbet@ca.ibm.com), Software Engineer, IBM

Author photoJamie Nisbet is a Software Engineer with the DB2 for Linux, Unix, and Windows development team at the IBM Canada Lab in Markham, Ontario. He holds a bachelor's degree in computer science from the University of Western Ontario, and has been with IBM since the year 2000. Jamie spent several years in his early career working in the DB2 Advanced Support organization before moving on to the DB2 Continuing Engineering development team, specializing in the runtime and codegen query compiler components.



Michael Kwok (mkwok@ca.ibm.com), Senior Manager, IBM

Michael Kwok photoMichael Kwok is the senior manager for the DB2 Warehouse Performance team at the IBM Toronto Lab in Canada. He focuses on DB2 performance in the data warehouse space and ensures that new releases and fix packs continue to deliver the best performance possible. He also works extensively with customers and provides technical consultation. Michael Kwok holds a Ph.D. degree from the University of Waterloo, Canada, with his doctoral dissertation in the area of scalability analysis of distributed systems.



18 December 2012

This article provides an in-depth look at table queues in DB2® for Linux®, UNIX®, and Windows®. It includes tips on how to identify whether a performance problem is due to TQ behavior, and explains what you can do to resolve such a problem.

This article includes the following:

  • An introduction to table queues
  • An in-depth discussion of table queues
  • Monitoring table queues
  • Table queue performance
  • Table queue tips and facts

Downloads

DescriptionNameSize
sample scriptformat_subsection_snap.zip3.27KB
articleunderstanding_table_queues.pdf482KB

Resources

Learn

Get products and technologies

Discuss

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=852643
SummaryTitle=Understanding table queues in DB2 for Linux, UNIX, and Windows
publish-date=12182012