Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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.

 

0 votes



One answer

Permanent link
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:
     Normal
 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.

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 2,358

Question asked: Jul 15 '14, 1:06 p.m.

Question was seen: 4,392 times

Last updated: Jul 15 '14, 4:16 p.m.

Confirmation Cancel Confirm