It's all about the answers!

Ask a question

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

james hays (827) | 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.4k6160182) | 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.