As I've indicated on my prior posts, I think the Extended Insight function of OMEGAMON XE For DB2 PE is a very nice feature. It provides some very useful and interesting performance analysis information down to the SQL level.
Now the question some may have is, what is the required infrastructure to run Extended Insight? In the examples I posted earlier I show Extended Insight data displayed within the Tivoli Portal. That being said, you don't necessarily need the TEP to be able to see Extended Insight data. Extended Insight runs using infrastructure from Optim. Technically, when you are displaying this data in the TEP, you are pulling the data from the OPM server.
If you are interested in the deployment options, here is a link to a write up that describes the options: