Skip to Content
0
Former Member
Jan 17, 2006 at 09:08 PM

ODS Activation - Multiple RUNSTATS on DB2 OS/390 BW System

20 Views

All,

In looking over the ODS activation logs our DB2 system is executing runstats on a very large ODS active table before adding "new" data and after the data has been added to the active table. Each runstat runs about 20-25 minutes. It doesn't make sense that the first runstat is executed. I can live with one runstat, but two seems unnecessary and expensive. If anyone has an OSS note or white paper you can point me to I would appreciate it tremendously. Thanks, Ted