Hi all,

To calculate the growth estimate i am using the formula to calculate it

i.e

Formula used in the tablespace calculation: Tablespace size = (average row size + 8) * no of rows * 2.50

Today one of my collegue came across thi site which which DB2 automatically calculates storage space of all DB objects at a particular point of time to the connected database.

http://www-106.ibm.com/developer/forums/dw_expandTree.jsp?thread=32339&cat=19&forum=294&message=1996784

It helps in calculating storage snapshots. Snapshots can be captured for Databases, Table spaces, Tables,Indexes, and Database Partition Groups. To capture storage data (including estimated size) for all objects (including tables) in a database, you should capture a database snapshot.


Procedure
---------------
1. Before capturing a snapshot, you must create the storage management tables (where all snapshot data is stored). Run the following command to create the
storage tables, and specify a table space for the tables.

db2 connect to DATABASE ;
db2 call create_storagemgmt_tables('<TableSpace name>')

Parm Mode Type Length Scale AS Locator
TSNAME IN VARCHAR 128 0 N

Example we have executed here: db2 call create_storagemgmt_tables('NA_TS') (this is the production data tablespace)

NOTE: THE STORAGE TABLES ARE STORED IN ABOVE TABLES SPACE

Is this automation procedure adviced to use as this creates the necessary schema,tables,views for calculation in my tablespace where i have production data.

Will there be any other risk factors ? ? ?

Thanks in adv
Thirumaran



DB2 & UDB email list listserv db2-l LazyDBA home page