mandatory/optional temp tablespaces and is everything in our databases BLOBs?
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
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 = 1I'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
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.