Informix DBA Survival Guide, Second Edition

Archiving And Temporary Spaces

Problem: Temp Space Problems

I'm archiving very large 24 x 7 databases while they are seeing significant amounts of user updates, inserts, and deletes. My archive is failing with temp space errors. Why?

Solution: Use a Big Temporary Space

This is similar to the quandary of one large DBSPACETEMP versus a DBSPACETEMP composed of more, smaller dbspaces. While you want to have multiple smaller DBSPACES comprising your DBSPACETEMP for query performance, IDS versions before 7.3 have some problems with DBSPACETEMP usage.

IDS systems changed their archiving methodology from OnLine. Now, at each checkpoint during an archive, the physical log pages are stored in one of the tempdbspaces listed in DBSPACETEMP before the physical ...