Lekharaju , i accept to your point that through control center we can find
it .

I am using the below mentioned formula in a excel sheet to automate my
entire tasks faster and to get the accurate results.

Can the same be got throug the db2 utiility which is used to estimate the DB
growth ?? will ther be any risks as mentioned by me below

Thanks

Thirumaran
----- Original Message -----
From: "Lekharaju Ennam " <lekharaju.[Email address protected]
To: <[Email address protected]
Sent: Thursday, September 23, 2004 11:51 PM
Subject: RE: db2 table , tablespace growth estimation


> **A LazyDBA.com subscriber has responded to your lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this email,
> **and removed any attachments, and kept your email address secret
> **from this person, and any viruses/trojans.
> **If you reply to this email, the person will see your email address as
normal
> **Anything below this line is the original email text
>
>
>
> from control center , you can get size of grow , estimation.
>
>
> Lekharaju Ennam
> -----Original Message-----
> From: thirumaran
> [mailto:db2udbdba-ezmlmshield-x33283530.[Email address protected]
> Sent: Thursday, September 23, 2004 1:48 PM
> To: LazyDBA Discussion
> Subject: db2 table , tablespace growth estimation
>
>
> 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=1
> 9&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
>
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>



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