All Forums Database
Sen_td 20 posts Joined 08/11
31 Aug 2011
Table Growth using dictionary tables



Is there any dictionary tables i can the get the information about the table growth?


Like, Data in my "Table_A" has grown 40% in one month.




mnylin 118 posts Joined 12/09
01 Sep 2011

If you have PDCR implemented, you can look in those tables. It will capture your history of table space as it changes daily and from there you can calculate your growth rate.

Sidhharth 5 posts Joined 10/11
04 Oct 2011

Hi mnylin,


How do i check whether pdcr is implemented or not? Is there anyway like we does for the DBQL?




robpaller 159 posts Joined 05/09
13 Oct 2011

I believe PDCR is a Managed Services offering from Teradata. Your DBA or Teradata CSR should be able to assist you with identifying whether or not PDCR has been installed. 

Otherwise, you can create a maintenance routine that runs and captures what is in DBC.DiskSpace in another database (where you keep your DBQL History) on a daily basis. You may chose to retain the data at the vproc/amp level or aggregate it.

The same could be done for DBC.TableSize as well if you so choose to retain a historical view of your table sizes over time.

anils345 2 posts Joined 09/12
21 Sep 2012

What is PDCR means?How it works and where it is useful?can you plz explain about PDCR with examples?
Anil Kumar

Qaisar Kiani 337 posts Joined 11/05
22 Sep 2012

If I remember correctly, PDCR is called Performance Data Collection & Reporting services database, which complements the inforamtion captured in ResUsage tables or DBQL to give a more advance reporting features for performance measures. These are Teradata Professional Services Offers for MS/DBAs.
Probably you can get more information from your local Teradata team.

You must sign in to leave a comment.