It's all about the answers!

Ask a question

mandatory/optional temp tablespaces and is everything in our databases BLOBs?

james hays (879) | asked Jul 15 '14, 1:06 p.m.

Also, are temp tablespaces required? I didn’t see any reference related to it being mandatory/optional in the documentation?


Regarding BLOB, as per db standards, BLOBs should go in a separate _blob tablespace. So we need to know whether it is acceptable.


One answer

permanent link
Kevin Ramer (4.5k8183200) | answered Jul 15 '14, 4:14 p.m.
edited Jul 15 '14, 4:16 p.m.
In general temporary tablespaces are needed for things relating to dynamic queries, sorts, dynamic tables ( i.e. joins ).  Being a DB2 person, a temporary table space ( system managed ) with very few pages is created when a database is created.   For example:

 Tablespace ID                        = 1
 Name                                 = TEMPSPACE1
 Type                                 = System managed space
 Contents                             = System Temporary data
 State                                = 0x0000
   Detailed explanation:
 Total pages                          = 1
 Useable pages                        = 1
 Used pages                           = 1
 Free pages                           = Not applicable
 High water mark (pages)              = Not applicable
 Page size (bytes)                    = 4096
 Extent size (pages)                  = 32
 Prefetch size (pages)                = 32
 Number of containers                 = 1
I'd leave tablespaces like those alone myself, which is to say:  Take what the database management system gives you (mostly) at face value.   There are times to deviate, but probably not here.

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.