Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

database growth metrics

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
amiya_mf

New User


Joined: 01 Mar 2005
Posts: 19

PostPosted: Tue Oct 13, 2009 11:49 am    Post subject: database growth metrics
Reply with quote

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
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Oct 13, 2009 7:57 pm    Post subject:
Reply with quote

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
View user's profile Send private message
amiya_mf

New User


Joined: 01 Mar 2005
Posts: 19

PostPosted: Wed Oct 14, 2009 10:12 am    Post subject:
Reply with quote

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
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Wed Oct 14, 2009 12:02 pm    Post subject:
Reply with quote

If you have got a timestamp field in your table structure, you can simply achieve this by issuing a SQL statement.
Back to top
View user's profile Send private message
amiya_mf

New User


Joined: 01 Mar 2005
Posts: 19

PostPosted: Wed Oct 14, 2009 12:16 pm    Post subject:
Reply with quote

There is no timestamp field in the table structure.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Wed Oct 14, 2009 12:23 pm    Post subject: Reply to: database growth metrics
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts Database access from COBOL amitmahalkar DB2 1 Wed Jan 27, 2016 11:33 am
No new posts Database backup on IMS DB HABBIE IMS DB/DC 1 Wed Aug 12, 2015 9:02 pm
No new posts Database name in Z/OS HABBIE DB2 6 Fri Aug 07, 2015 5:52 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us