2

For one of my issue, I am trying to understand the functionalities of below DB2 entities,

  • System Temporary table space.
  • Page Size.
  • Table Space.
  • Buffer Pool.

And below is my observation,

  • There is a TableSpace linked to a table in the DB2 table syscat.tables
  • The TableSpaces are linked to BufferPool with the relation defined in syscat.tablespaces
  • System Temporary table space is the table space that the DB might use while executing the query.
  • Page Size is an unit that defines the limit of a TableSpace and says how much data can a TableSpace can hold.

Is there something wrong in my above understandings? And when I excute a query how does the DB chooses which TableSpace to choose?

Community
  • 1
  • 1
Kannan Ramamoorthy
  • 3,980
  • 9
  • 45
  • 63
  • Page size is not the limit of the tablespace. It is the minimum storage unit, and it defines the size of the row. – AngocA Sep 03 '14 at 14:00
  • This is a similar question: https://stackoverflow.com/questions/22603524/ibm-db2-9-7-determining-default-tablespace However, this does not apply for temporary tablespaces when DB has multiples in the same pagesize. – AngocA Sep 03 '14 at 15:36

0 Answers0