Space management in BW
Finding how much DB% a cube is occupying
1)go to se11 type psa table name /bic/b********** and display the table.
now u have tab technical setting at top click it
and it will display the table space and the size
for cube/bib/d********
2)If you are maintaining the Statistics. You can check the reports of statistics Multiprovider. or you can also check with statisctis cube.
3)To see the disk space used from an InfoCube you should see TCode DB02 and should sum all the involved tables (Detailed Analysis -> Object Name "<IC_NAME>"), so E, F and DIM tables.
4)You can use RSRV -> All Elementary Tests -> Database -> Database information about infoprovider tables to get the rows in the fact tables and dimension tables.
You can also use the program SAP_INFOCUBE_DESIGNS.
5)GoTo T.Code, DB02 and there u can see the over all DataBase details. Look down in the "Tables, Indexes, stored procedures" there select Space Statistics then it will popup a selection there select Top n largest tables and check the PSA Table with the Table Name like /BIC/B0000264000.
If u have several requests in the PSA then u can delete them having a few requests in the PSA.
6)In DB02 Transaction Code see at the bottom u could see these,
1. Detailed Analysis
2. Missing Indexes
3. Space statistics
4. Checks
In this select the 3rd one, u should get the popup.
Check this link:
https://www.sdn.sap.com/irj/sdn/thread?forumID=131&threadID=142810&messageID=1596957
You can always delete old PSA data that is no more required which will enable the DBA to re-org PSA even from other PSA tables where space is surplus.
now u have tab technical setting at top click it
and it will display the table space and the size
for cube/bib/d********
2)If you are maintaining the Statistics. You can check the reports of statistics Multiprovider. or you can also check with statisctis cube.
3)To see the disk space used from an InfoCube you should see TCode DB02 and should sum all the involved tables (Detailed Analysis -> Object Name "<IC_NAME>"), so E, F and DIM tables.
4)You can use RSRV -> All Elementary Tests -> Database -> Database information about infoprovider tables to get the rows in the fact tables and dimension tables.
You can also use the program SAP_INFOCUBE_DESIGNS.
5)GoTo T.Code, DB02 and there u can see the over all DataBase details. Look down in the "Tables, Indexes, stored procedures" there select Space Statistics then it will popup a selection there select Top n largest tables and check the PSA Table with the Table Name like /BIC/B0000264000.
If u have several requests in the PSA then u can delete them having a few requests in the PSA.
6)In DB02 Transaction Code see at the bottom u could see these,
1. Detailed Analysis
2. Missing Indexes
3. Space statistics
4. Checks
In this select the 3rd one, u should get the popup.
Check this link:
https://www.sdn.sap.com/irj/sdn/thread?forumID=131&threadID=142810&messageID=1596957
You can always delete old PSA data that is no more required which will enable the DBA to re-org PSA even from other PSA tables where space is surplus.