DB2 Performance Expert - Commonly asked questions #1 - What is the architecture?
IBM_Optim 27000269HS Visits (3343)
I work with LOTS of customers who use or want to use DB2 Performance Expert for LUW. The first question I get asked usually has to do with the basic architecture - what pieces run where and on what platform?
The first thing to understand is that DB2 PE is a client/server application. The PE server runs on LUW platforms (AIX, SUN, Linux, Windows, etc). Most customers install the PE client on Windows then connect to the PE server running on AIX, SUN, Linux, Windows, etc.
Look at the diagram below.
As shown there, we recommend that you install the PE server on its own DB2 instance -- not on the monitored box -- and have that server remotely monitoring the other DB2 instances on the network. Why? Well, you don't want to impact the monitored DB2 instances. I like to call this window shopping... you look but you don't want to touch. Note that in the 3.2 release, you get a license of DB2 ESE for just this purpose so you don't need to use one of your own DB2 installations for this.
PE can monitor different DB2 levels all from a single PE Server. You can also mix and match your operating systems, too. For example, the PE server can be installed on AIX and remotely monitor your DB2 instance running on AIX, SUN, Linux, Windows, etc..
If you want the gory details on specific levels of hardware and software server support for both the client piece and the server piece of DB2 PE, see this technote.
I'll be back soon with answers to more FAQs. Feel free to submit your questions here using the comment link below or send an email to dstudio at us.ibm.com.
-- Alice Ma