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

    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

    db2level
    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
    Location
    Toronto, Canada
    Posts
    5,516
    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:
    Code:
    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
  •