Your company has decided to set up a Performance Testing Environment, referred to as PTE from now on, with production sized data volumes, allowing them to do \u00a0some real testing and get accurate SQL optimizer paths through your data. \u00a0Imagine the costs involved; the hardware costs to run the environment, the duplicated DASD to hold the data (this must have been a storage vendor\u2019s idea), the operational costs to keep it operating smoothly, the people costs to update it and the people costs when teams of programmers are waiting for the environment to be ready for another test run. \u00a0Of course the teams are not standing around waiting; but you get the idea – when someone is waiting for something to be ready to use \u2013 it preoccupies them and they mentally wait on it. \u00a0At least I do! \u00a0 And of course you will have a management layer on top of all those people costs.<\/p>\n
Well, let\u2019s get to the real gist of this blog entry, or actually the first of 3 blog entries. \u00a0This entry will discuss populating the PTE environment. \u00a0The next entry will discuss resetting the data so your application teams can run their next test or series of tests. \u00a0And the final blog entry will delve into those costs to make sure you consider them all. <\/p>\n
Populating the PTE environment initially is really a data migration exercise, and BMC has addressed this requirement over the years in several White Papers. \u00a0Like this one located here, you will see many flavors of migration; depending on outage reduction, structure modifications along the way, the ability to tolerate fuzzy source data or the need for crystal clear intact relational data. \u00a0As we are always striving for speed and outage reduction at BMC my personal favorites are:<\/p>\n
<\/span>\u25aa <\/span>Change Manager with Resource Maximizer \u2013 build a worklist to read production image copies with our Recover Plus product, go through ID translation and then lay those down in your PTE subsystem. You might have noticed in your shop, a recover product can be difficult to justify, but one that runs every day (hint, hint — we are also going to use recovery in blog entry #2) and saves resources, should be an easy justification. \u00a0Check back next week when we go into restoring\/recovering the data so you can re-run your tests. \u00a0Would turning many hours into minutes get your LOBs and managers attention? Remember those people are waiting to run the next test.<\/p>\n Change Manager allows for unattended operations when used to manage the objects in the PTE. \u00a0All of Change Manager Processes can run unattended in batch. \u00a0You can easily do the following. \u00a0Let\u2019s say the PTE looks different than production and you want it that way, but you want to the page moving capability of Recover Plus versus doing unload\/reloads. \u00a0You can take a baseline (a snapshot) of the PTE structures, drop them, copy the objects with Change Manager from production and then run a Change Manager compare, to the original baseline, to put the PTE back to the original structures, but with production data. \u00a0All of this can run automatically and unattended.<\/p>\n By Jonathan Ginter<\/p>\n","protected":false},"excerpt":{"rendered":" Your company has decided to set up a Performance Testing Environment, referred to as PTE from now on, with production sized data volumes, allowing them to do \u00a0some real testing and get accurate SQL optimizer paths through your data. \u00a0Imagine the costs involved; the hardware costs to run the environment, […]<\/p>\n","protected":false},"author":26,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[39],"class_list":["post-10820","post","type-post","status-publish","format-standard","hentry","category-blog","tag-english-fr"],"yoast_head":"\n
<\/span>\u25aa <\/span>Benefit: Automates the build and maintenance of the data migration process, thus reducing the overhead on DBA time and runs at Recover Plus page recovery speed.
<\/span>\u25aa <\/span>Online Consistent Copy on the source, followed by BMC RECOVER PLUS using OCC input with OBIDXLAT on the target
<\/span>\u25aa <\/span>Benefit: No outage on the source system to create the OCC. \u00a0There is little CPU or I\/O to create the OCC (it is driven by storage data set snap technology). OCC renders the OCC consistent with log apply technology. The OCC is then input to the BMC RECOVER PLUS OBIDXLAT utility on the target, where replicated data sets will be created. \u00a0Consideration: OCC requires the appropriate storage technology<\/p>\n