cancel
Showing results for 
Search instead for 
Did you mean: 

Required FM's to get Used and Unused space..

Former Member
0 Kudos

Iu2019m trying to find out a FM for all the below mentioned Databases.

DB2

INFORMIX

Sybase,

MaxDB

Which should give me the used and unused space for a particular Table.

Need one DB2 FM, one INFORMIX FM, one Sybase FM, and MaxDB FM.

Please let me know.

Accepted Solutions (0)

Answers (1)

Answers (1)

lbreddemann
Active Contributor
0 Kudos

> Iu2019m trying to find out a FM for all the below mentioned Databases.

> DB2

> INFORMIX

> Sybase,

> MaxDB

>

> Which should give me the used and unused space for a particular Table.

>

> Need one DB2 FM, one INFORMIX FM, one Sybase FM, and MaxDB FM.

>

> Please let me know.

For MaxDB there is no such a function module.

What should it be good for?

There is nothing like "table reorganization" in MaxDB - the database completely manages the space allocation and automatically decides whether a page needs to be added to a table or not.

Of course you can check on the storage quality if you really feel that this is interesting (system table TABLESTATISTICS would contain such data). Anyhow, there is nothing you can do about the way MaxDB allocates space.

Thus, looking for "unused" space is nonsense here.

regards,

Lars