We have many applications using embedded sql statements. We are discovering that as the files grow larger the performance diminshes significantly. We have tried using dbmon to ensure indices are not being built on the fly. There are either indices or logicals for all keyed access sequences. Any idea on how to improve performance without stripping out the sql and replacing it with native db2 files?
February 20, 2006 4:04 PM
November 30, 2009 7:20 PM