Re: New shared memory segments, while performing a backup with ontape. Why?

>In the last days, while performing an "ontape" backup, >the engine allocated new shared memory segments. > >During normal operational activity, the primary shared memory >segment is used on an average of 50-60%, so I think that for >now the segment is big enough. > > During the backup process, the physical log has to be checked from time to time to see if any pages have been updated that need to be placed in archive. We don't allow them to go directly to the tape as this can cause a system hang during the checkpoint (because the physical log file is flushed during checkpoints). What happens is that the pages go into virtural shared memory and are then flushed to disk files after the checkpoint. I suspect that you might be doing some rather masive updating during the archive and this is causing an increase usage of this temporary table space. Madison Pruet