BSEG(cluster table) table size

[Former Member]

Hi experts,

How to find clustertable(BSEG) size?

from DB02 we are not able to see the table size for this.

Thanks and regards

Ray

[shouvik]

Hi Ray,

Go to transaction SE38 and execute the program "RSSPACECHECK"  or "RSTABLESIZE"

It is possible to exclude tables of delivery classes

'L' and 'A' from the selection.

For more info. see note 118823 - CC-ADMIN: Size of a client.

Hope this helps. Enjoy.

Best Regards,

Shouvik

[Former Member]

I looked at the link, which spoke of row numbers reported by SAP, but I think you were wondering why you can't see BSEG at the DB/2 level.

The reason is that BSEG is a "cluster table". Multiple cluster tables can be stored in a single "table cluster". BSEG happens to be stored inside the table cluster RFBLG. If you look in the DB/2 catalog, you'lll see a table called RFBLG.

You'll also see something pretty ugly. RFBLG has just a few columns, one of which is called VARDATA, and it is a binary column. The data in RFBLG-VARDATA is compressed. It contains rows from BSEG as well as other cluster tables (BSET comes to mind, but I can't remember the others off the top of my head).

I have been told there is no way to comprfhend the data in a table cluster apart from SAP code. I need to do that very thing, and have written up the question in a few other threads. I think I'll also probably start a new thread and put the question in there.

Thank You,

Larry Smith

[Former Member]

Hi,

check

regards,

kaushal