table gowth rate

redwolf · #1 (**permalink**) 06-07-06, 14:33

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".

n_i · #2 (**permalink**) 06-07-06, 16:17

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 (...);

Internet Services

Web Development

Digital Marketing

Consumer Tech