Db2 v7 and v8 weirdness

Lee Robertson

Db2 v7 and v8 weirdness

AIX 5.2 DB2 v7.1 and DB2 v8.2

We recently migrated a database from 7 to 8 as detailed above and now find
one of our queries performance has crashed through the floor.

Basically, a table is dynamically created and then rows inserted into it,
this table is then updated.

Previously the update step took about 30 secs at v7 but at v8 this now
just runs and runs.

Anyone seen this type of behaviour before ? In neither case (v7 or v8), is
a runstats done after the insert and prior to the update.



Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm