Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: table gowth rate

    Is there a way to determine which tables have grown the most over a time period?

    Thanks ... Ellis

    SunOS njs75d-0004 5.8 Generic_117000-05 sun4u sparc SUNW,Netra-T12

    DB21085I Instance "db2inst2" uses "64" bits and DB2 code release "SQL08022"
    with level identifier "03030106".
    Informational tokens are "DB2 v8.1.0.89", "special_15295", "U800790_15295", and
    FixPak "9".
    Product is installed at "/opt/IBM/db2/V8.1".

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    Yes there is, although you'll have to do it yourself. You're probably updating statistics regularly; write a script to monitor stats for the tables you're interested in and save the data. For example:
    create table tablegrowth (
      tabname varchar (128) not null, 
      tstamp timestamp default current timestamp, 
      card bigint not null, 
      fpages bigint not null
    insert into tablegrowth select tabname, current timestamp, card, fpages
    from syscat.tables where tabname in (...);

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts