BW – Table space available

[Former Member]

Hi Experts,

I am new to BW; I am in the process of analysing available free space at DB level.

How/Where can I find

• What is the Total and Available space in BW
• What is the total size of PSA Tables (So that I can analyse the impact of deleting PSA requests) and
• What is the total size of DSO Change Log Tables (So that I can analyse the impact of requests in change log table)

I already searched SDN, But its pretty confusing.

Thanks in advance.

[sander_vanwilligen · Accepted solution]

Hi,

Although I am not frequently doing this kind of analysis, please try t/code DB02 or DB02OLD.

Every BW persistent object is assigned to a Data Class. This Data Class is in turn assigned to a Table Space (depending on the Database). E.g. for Oracle these tables are TAORA and IAORA if I am correct.

You can also have a look at the following excellent blog series . The topic Space is discussed in Part 1 and PSA deletion in one of the next parts.

Best regards,

Sander

[sander_vanwilligen]

Hi,

Can you please confirm if my reply of Dec 28, 2013 11:52 PM is clear?
If not, please let me know how I can help you further.

Thanks,
Sander

[Former Member]

Hi,

Yes,The reply is very helpful.

Thanks for the inputs

[former_member184884]

Hi Dush,

i would like to add one point to sanders reply  if you are using oracle as your underlying database for BW you need to check in DB02 tcode.

But if your underlying database is DB2 no need to check this parameters as there is automate process which will increase memory  dynamically so we can say this also one kind advantage we can get by leveraging DB2 database with our BW system

recently we are replaced our database from oracle---> DB2 we've experienced so many fruit full results we've overcome some reoccurring bottlenecks like data load run time, table space dumps.

Regards,

Harish