Skip to Content
author's profile photo Former Member
Former Member

Database Tables

Hi Everyone,

I know the ods tables names are stored like /bix/a<ods_name>00 and /bix/a<ods_name>40 and for change log it is /bic/b*. But my requirement is I have to display the size of the tables belonging to a particular ods object. So for all the tables the size is stored in DBSTATTORA which gives information about

DBSTATTORA

fields of this tables are:

TNAME --> Table Name

ANDAT --> Analyzing Date

AMETH --> Analysis method for collecting Statistics

NROWS --> No of rows in a table

OCCBL --> Used blk(size) of table in KB

EMPBL --> Empty blk(size) of table in KB

AFREE --> Avg Freespace in a used db block

INDBS --> Used Blk(size) of an index kb

This is a table which stores the statistics information.

It displays all the tables of infocubes and ods objects, but does tell that this table belongs to this infoprovider.

I have to display data from this table as well as the infoprovider to which it belongs. So there is no proper information of database tables where the infocube and its associated tables like the facttable, dimtables are stored together. Same for the ods objects also.

There are for ods object RSDODSOTABL which give information about ods object and the table name is stored differently <ods_name>_0000. How do i map this table with the DBSTATTORA table, the tablenames doesn't match. Same problem with RSTSODS table which give informaiton about change log table.

And also for infocubes, there is RSDCUBE which gives information about infocubes but not the associated tables. So does anyone know where all these information is stored in some database tables. It would be of great help.

Thanks a lot.

Prab

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jun 05, 2005 at 07:40 AM

    I answered this question in ABAP forum yesterday. also suggested you the right forum, what happend the answers were not useful?

    copy of my answer in the abap forum

    <b>BW related questions , post them in BW forum

    /community [original link is broken]

    anyhow to answer your question.

    check out transaction

    listschema</b>

    Regards

    Raja

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Listshema only displays the tables related to infocubes, but my question was is there any database tables where the ods object name and its associated tables, like active data table, new data table are stored. I have explained in detail in the question. Still nobody is able to understand. I hope this helps out.

      Regards,

      Prabhu

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.