Hi All,

We are using Sybase IQ 16.0 and facing DB performance issues often.

Swap memory is 150 GB and Data volume is 3.5 TB. Whenever Complex reports are running swap is consumed heavily around (50 GB) .

Post Execution swap space is not released to the DB. As of now we are going for DB restart every alternate days.

Do anyone knows how to avoid this and clear the swap space, Please help....