Hi ,
In DB02 you can see space disk evolution of the BW databse by days , weeks , months
I want to create queries with the same data
For this I need to create a cube about space disk
What are the tables where space disk values are stored ?
If I know the tables I will then create a datasource on them
Thanks
Sebastien
1 Answer
-
Posted on May 04, 2011 at 02:20 PM
Hi,
ask your database admin!
=> I think, you can't create a datasource for this. with native sql perhaps (see http://help.sap.com/saphelp_470/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/content.htm).
in INET I found for example: http://database.ittoolbox.com/groups/technical-functional/db2-l/how-to-calculate-the-table-size-in-db2-1691545
=> you need the system tables: syscat.tables, syscat.indexes and syscat.tablespaces
Sven
Add comment
Add comment