How to purge the RT_LOG using DELETE command in uvsh

[soportesis]

Hi,

I'm trying to purge RT_LOG file (DATA.30 and OVER.30) using DELETE command. The problem is that only the DATA.30 file is being purged. Is there a way or a command you could use to purge OVER.30 file?

This is an example of the command I use:

Code: Select all

DELETE FROM RT_LOGXX WHERE TIMESTAMP < 'Today'

[ray.wurlod]

DELETE purges data from both parts. Space is made available against future re-use rather than being reclaimed, so it may appear (from the sizes) that OVER.30 is not being purged. If you ever need to reclaim the available space in a dynamic hashed file the appropriate commands are either CLEAR.FILE filename or RESIZE filename * * *