I assume you're asking primarily for price reasons. There are three things I'd recommend doing first before getting lost in the well:
1. Evaluate whether you can consolidate your QMF workloads onto a smaller number of your DB2 machines, especially if QMF can/would represent a comparatively large share of that machine's (or those machines') total DB2 workload. Consider also whether you can softcap that LPAR (or those LPARs). Your QMF charges are based on the peak 4 hour rolling average of DB2 MSUs consumed per month per machine where QMF is licensed. You should weigh possible consolidation against DB2 peak behavior. Specifically, if QMF 4HRA peaks are non-coincident with the non-QMF DB2 peaks, then exercise a little extra caution. Note also that Solution Edition, zNALC, and DB2 Value Unit Edition LPARs are typically measured separately and thus wouldn't count toward your QMF 4HRA calculation. 2. Run! (do not walk!) and buy one IBM DB2 Analytics Accelerator (after a bit of due diligence, of course -- but only a bit), plug it in, and turn it on. QMF workloads are strong candidates for acceleration with DB2 AA. You will be amazed. Don't have a z196 or z114 yet? Run and get one of those too even if only to plug in a DB2 AA. 3. Upgrade to DB2 10 if you haven't already. The vast majority of DB2 customers see a worthwhile performance improvement. -------------------------------------------------------------------------------------------------------- Timothy Sipples Resident Enterprise Architect (Based in Singapore) E-Mail: [email protected] ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
