View previous topic :: View next topic
|
Author |
Message |
amiya_mf
New User
Joined: 01 Mar 2005 Posts: 18
|
|
|
|
Hi,
Can somebody help me to find out some EZtrieve program by which I can build reports to format the "database growth" metrics into a readable format. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Suggest you post a bit of the data that you want to work with and show an example of the output you want from that input data. . . |
|
Back to top |
|
|
amiya_mf
New User
Joined: 01 Mar 2005 Posts: 18
|
|
|
|
Hi Dick,
Thanks for your reply.
Actually in my shop I have one table which is being used by the user everyday. and the no of records inserted is huge number. So just to track weekly, how many records got inserted into the table, i need to prepare a report. So for this I am looking for an approach.
I think now i made my requirement somewhat clear, as there is no input data and out put data so i have not given any sample. At the end of the program it should give me a report by which i can see what was the number of records last week and how many new records got inserted into the table and what is the current record count.
Thanks. |
|
Back to top |
|
|
dejunzhu
Active User
Joined: 08 May 2008 Posts: 390 Location: China
|
|
|
|
If you have got a timestamp field in your table structure, you can simply achieve this by issuing a SQL statement. |
|
Back to top |
|
|
amiya_mf
New User
Joined: 01 Mar 2005 Posts: 18
|
|
|
|
There is no timestamp field in the table structure. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
Quote: |
if you have got a timestamp field in your table structure, you can simply achieve this by issuing a SQL statement. |
and, by grace, how would a timestamp in the data help to plot a growth rate for a database ??
anyway You should define a new DB2 table <Your _statistics_stuff> with the columns relevant to the data You want to keep track on
here You might want to include a timestamp to record the time the data was collected..
run the proper SQL queries for the relevant catalog tables,
populate the <Your _statistics_stuff> with the data...
afterwards it is just the issue to process the <Your _statistics_stuff> in order to get reports an graphs for Your metric application
it' s a full blown application ( small, maybe, but an application neverthless)
the proper approach must be followed, requirements and all the rest proper design, plan, documentatin |
|
Back to top |
|
|
|