I have a table that is replicated to another database, on the same instance. Everything is identical for these tables. The issue is it takes ~ 45 minutes to perform a runstats on the table in one db and it takes ~ 4 hours on the other.
Could one of these parameters cause this type of issue? Intra_parallel is NO and max_querydegree is ANY at the DBM level.
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08022"
with level identifier "03030106".
Informational tokens are "DB2 v188.8.131.52", "special_15295", "U800790_15295", and
Product is installed at "/opt/IBM/db2/V8.1".
runstats doe a full tablescan; is a heavy I/O process; are the 2 operating systems the same; like, CPU,diskspeed etc; also the tablespaces set up the same way? what is the load on either system when you run runstats?