ttCompactTS

Description

ttCompactTS is similar to ttCompact, except that ttCompactTS may be used to compact a small fraction of the data store, while ttCompact compacts the entire data store. ttCompactTS is a time-sliced version of ttCompact. ttCompactTS iterates through all the blocks in the data store compacting the quantum specified each time. ttCompactTS called repeatedly ultimately has the same effect as a call to ttCompact. When a sweep is completed, the value of the DS_COMPACTS field in the MONITOR table is incremented.

Required privilege

This procedure requires the ADMIN privilege.

Syntax

ttCompactTS(quantum)

Parameters

ttCompactTS has the parameter:

Parameter	Type	Description
`quantum`	TT_INTEGER NOT NULL	A non-zero positive integer that specifies the number of data blocks a ttCompactTS should compact. Each quantum corresponds to one data block.

Result set

ttCompactTS returns no results.

Example

CALL ttCompactTS (5);

Note

Compacting data does not modify result addresses.