Difference table size values

[Former Member]

Hello Experts,

I want to know the sizes of some tables (e.g. TCURR). In different threads the transaction db02old and the function module 'DB_GET_TABLE_SIZE' are mentioned for that purpose.

I wonder that using these methods two different sizes are

Using transaction db02old I get a size of 81.920 for TCURR.

Using function module 'DB_GET_TABLE_SIZE' I get a size of 79.937 for TCURR. Why is there a difference between both values?

Thanks for your help.

Regards,

Tobias

[Former Member · Accepted solution]

DB02old gives the correct information as it directly updates value from Database.

Function module 'DB_GET_TABLE_SIZE' depends on the variables you have set and it useful for ccms operations.

regards

nag

Edited by: welcomenag on Jul 6, 2009 4:15 PM

[Former Member · Accepted solution]

First, thanks for your helping answers. But in what way depends the value of module 'DB_GET_TABLE_SIZE' on the variables you have set. What effect does the variables have on the value? What can be set?

Regards

Tobias

[Former Member]

Not sure, but in db02old, multiply KBytes column by 8192 ( DB block size 8KB). Hope you may find the correct figures.