temp dbspace

[StevePB]

We have a problem with our temp dbspace.

There is a known bug with IDS where temp dbspace can get corrupted and can't be recovered without restoring the database.

This happened to us and we had extra temp dbsapce added, because at the time we could not restore (due to another bug). When the extra temp dbspace was created we understood that it was effectively an expansion of the existing space, i.e. if one temp dbspace was used up during a query it would automatically roll over to use the next. This does not seem to be happening. Can anyone help with this stuff ?

 

[mberni]

Hi,

i can only contribute, that temp dbspaces are used parallely, so if you have 2 at a time, they are used both at the same time, improving performance, when placed on different discs.

This is not much, but at least a bit

Regards,

Michael