cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase IQ BD Size Monitor

Former Member
0 Kudos

Hi All,

How can we check the allocated/free DB size in Sybase IQ 15.4?  We use Sybase Central V6.1 to do administration. Would like to check main and temp DB allocations.

Is there way to increase the DB allocations in Sybase IQ?

Thank you,

Shanka

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

sp_iqdbspace

increase: add files to you DBSpaces

Former Member
0 Kudos

Thanks Oleg, This is what I was after.

Is there any simple procedure that will give us the DB size for main memory usage which also highlights the free size?

Cheers,

Shanka

Former Member
0 Kudos

Calculate it.

Simple example for one file:

Total size: 12.6T

Usage: 78%

select 12.6 * 78 / 100.0 as UsedSpace, 12.6 - 12.6 * 78 / 100.0 as FreeSpace

Answers (1)

Answers (1)

Former Member
0 Kudos

Thank you for confirming. I was not sure if the free space could be simply calculated as per above.