Maximizing DB2 Performance and Availability With BMC

solution WHitE PAPERMaximizing DB2 Performance and AvailabilityWith BMC table of Contents intRoDuCtion............................................................................................................................. 1 iBM DB2 V8 — BREAKinG liMits. ............................................................................................ 2 EVAluAtinG soFtWARE Costs................................................................................................. 2 BMC lEADs WitH sPEED............................................................................................................ 2. REDuCinG CPu usAGE inCREAsEs tCo...................................................................................3 tHE Cost oF PRoDuCtiVitY — MoRE tHAn tCo. ................................................................. 3. RoBust solutions — not Just utilitiEs. ......................................................................... 4. suMMARY. .................................................................................................................................... 5introductionBMC.Software.DB2.utilities.have.set.the.standard.for.high.database.availability.and.performance.since.1988..Customers.rely.on.BMC.for.the.most.advanced.data.management.solutions.and.utilities.to.maximize.the.availability.of.mission-critical.DB2.applications..Most.of.the.world’s.data.still.resides.on.mainframes,.and.DB2.databases.drive.a.large.part.of.the.global.economy.DB2.high-speed.utilities.were.developed.to.maintain.and.manage.DB2.databases.more.efficiently..BMC.continues.to.develop.industry-leading.data.management.solutions.that.keep.data-intensive.DB2.applications.running.at.peak.performance.with.high.availability..Providing.continual.application.availability.and.meeting.customer.service.level.agreements.(SLAs).are.critical.to.business.success,.and.BMC.DB2.utilities.deliver.minimal.downtime.for.your.DB2.databases..In.many.cases,.no.outage.is.required.when.running.these.utilities.With.increasing.economic.pressures,.IT.professionals.must.careful y.scrutinize.hardware,.software,.and.labor.costs..Balancing.these.costs.over.time.has.traditional y.been.described.as.managing.the.total.cost.of.ownership.(TCO)..To.contain.IT.costs.and.grow.business.profits,.IT.professionals.strive.to.lower.TCO..The.chal enge.lies.in.balancing.the.cost.of.technical.personnel.with.the.management.of.increasingly.complex.hardware.and.software.environments.—.while.maintaining.very.high.levels.of.service..PA G E > “When.considering.migrating.to.new.versions,.support.BMC leads with speedfrom.vendors.such.as.BMC.is.definitely.a.factor.in.our.decision-making.process,”.said.Tricia.Maupin,.DBA.manager,.BMC.provides.the.most.comprehensive.set.of.data.Corporate.Systems.Incorporated..“Corporate.Systems.management.tools.and.utilities.in.the.industry..We.began.provides.sophisticated.property/casualty.risk.management.responding.to.customers’.needs.by.developing.DB2.utilities.information.software.services.and.products.that.help.clients.and.point.products..Customer.requirements.quickly.drove.improve.productivity,.increase.efficiencies,.and.provide.product.needs.beyond.the.minimal.level.of.functionality.higher.levels.of.customer.service..To.ensure.this.high.provided.by.the.base.utilities.shipped.with.DB2..BMC.led.level.of.service.for.our.clients,.it.is.critical.that.regardless.the.way.with.the.development.of.innovative,.patented.of.the.platform.we.are.working.on,.we.are.afforded.data.technology.to.more.efficiently.manage.DB2.databases..management.solutions.such.as.BMC’s.that.ensure.our.Today,.the.BMC.DB2.utilities.are.fully.integrated.with.BMC.systems.remain.available.at.all.times.”.performance,.administration,.and.recovery.solutions..iBM DB2 V8 — Breaking limitsIBM’s.DB2.Universal.Database.for.z/OS.V8.(DB2.V8).provides.more.integration.and.synergy.with.zSeries.hardware,.with.middleware,.and.with.applications..It.also.breaks.through.many.previous.limitations.with.scalability.and.availability..DB2.V8.supports.64-bit.virtual.storage;.the.zSeries.64-bit.architecture.allows.DB2.V8.to.move.many.storage.areas.above.the.previous.2BG.limit..In.DB2.V8,.the.maximum.number.of.partitions.in.a.partitioned.table.space.increased.from.254.to.4096.partitions..Applications.with.large.volumes.and.to.those.that.require.high.availability.must.be.able.to.add.partitions.and.to.make.schema.changes.online.Evaluating software CostsAnalyzing.the.factors.that.contribute.to.a.software.investment.can.be.a.daunting.and.confusing.task.because.requirements.and.IT.environments.vary..The.Aberdeen.Group1.initial.software.costs.should.be.compared.with.other.key.factors.—.scalability,.administrative.productivity,.robustness,.comprehensiveness,.and.integration..The.key.is.to.look.for.sustained,.reduced.TCO.over.time.—.not.just.the.initial.software.investment..In.July.2006,.a.large.retail.manufacturer.asked.a.team.of.BMC.DB2.specialists.for.help.in.solving.a.DB2.availability.and.scalability.problem..The.manufacturer.had.a.large.DB2.for.z/OS.SAP.environment.and.needed.to.perform.routine.DB2.maintenance.during.a.limited.window.of.availability..The.customer.had.data.in.excess.of.40GB.in.one.segmented.table.space..In.comparing.BMC.REORG.PLUS.V8.1.00.with.IBM.DB2.V8.REORG,.the.customer.found.that.the.BMC.utility.delivered.20-plus.hours.of.additional.availability.PA G E > Reducing CPu usage increases tCothe Cost of Productivity – More than tCoAt.one.time,.database.utility.benchmarks.were.just.about.BMC.DB2.utilities.help.manage.the.efficiency,.speed..But.today,.measuring.the.value.of.technology.responsiveness,.and.performance.of.mission-critical.DB2.to.reduce.TCO.means.examining.the.cause,.cost,.and.for.z/OS.applications.by.reducing.CPU.consumption,.batch.consequences.of.downtime..run.times,.and.online.transaction.response.times..BMC.DB2.utilities.are.not.in.contention.with.the.same.resources.Computing.the.actual.cost.per.minute.for.an.offline.used.by.DB2..For.example,.BMC.LOADPLUS.for.DB2.and.application.is.difficult.because.you.must.consider.the.BMC.UNLOAD.PLUS.for.DB2.do.not.use.the.same.DB2.type,.size,.and.complexity.of.an.application,.as.well.as.buffer.pools.to.load.and.unload.data.as.the.IBM.utilities.use..the.amount.of.traffic.hitting.an.application..According.to.This.allows.for.optimal.utility.processing.and.reduced.costs.Information.Access.Company,.industry-standard.figures.because.fewer.CPU.cycles.and.execute.channel.programs.reveal.the.average.downtime.for.an.e-commerce.application.(EXCPs).are.used.can.cost.companies.$2,500.to.$7,800.per.minute..For.ERP.applications,.downtime.can.cost.$6,400.to.$7,900.per.Elapsed.times.are.also.reduced.because.load.and.unload.minute,.and.for.data.warehouse.applications,.downtime.can.tasks.are.not.restricted.to.processors.in.a.single.system..cost.$5,800.to.$6,300.per.minute..BMC.LOADPLUS.for.DB2.and.BMC.UNLOAD.PLUS.for.DB2.have.built-in.system.intelligence.that.allows.tasks.to.be.distributed.automatically.to.the.least-busy.processors.within.the.system..A.large.Asian.bank.with.a.critical.online.transaction.DB2.application.took.advantage.of.BMC.UNLOAD.PLUS.for.DB2..Customer.satisfaction.and.response.time.were.critical.to.success..They.needed.to.migrate.a.table.of.approximately.45.million.rows.with.37.partitions.PA G E > A.company.using.standard.IBM.DB2.V8.utilities.to.run.a.production.application.ran.an.offline.database.recovery.that.took.more.than.eight.hours..Using.a.median.downtime.figure.of.$6,000.per.minute,.the.cost.to.the.business.was.approximately.$3.million.in.lost.revenue..However,.when.the.company.used.BMC.Recovery.Management.for.DB2.solution,.the.downtime.was.less.than.14.minutes.--.resulting.in.a.savings.of.more.than.$2.9.million.Robust solutions — not Just utilitiesBase.utilities.are.simply.not.adequate.for.business-critical,.continuous.availability.demands..Today’s.data-intensive.DB2.environments.require.the.industry’s.best.data.management.solution.—.tools.that.are.fully.integrated,.easy.to.use,..non-disruptive,.and.have.built-in.intelligence.and.automation..For.companies.seeking.the.best.return.on.their.DB2.software.investment,.BMC.offers.integrated,.high-performing.DB2.tools.and.utilities.for.cost-effective.recovery,.performance,.and.administrative.solutions.BMC DB Solution Category of SolutionBMC.Administrative.Assistant.for.DB2.Reduces.time.and.effort.spent.creating.and.managing.DB2.databasesBMC.Database.Administration.for.DB2.Reduces.complexity.of.managing.DB2.across.multiple.subsystems.and...includes.high-speed.integrated.utilitiesBMC.SQL.Performance.for.DB2.Proactively.analyzes.and.tunes.SQL.code.with.minimal.overhead.BMC.Database.Performance.for.DB2.Optimizes.database.objects.to.deliver.high.performance.and.availability.BMC.System.Performance.for.DB2.Automates.tuning.of.DB2.subsystems.to.meet.SLAsBMC.Recovery.Management.for.DB2.Performs.rapid.recovery.from.disasters.or.application.and.user.errors.with...no.downtime.PA G E > summary“In.1989,.we.had.determined.that.the.IBM.utilities.in.DB2.just.couldn’t.keep.up.with.our.workload,”.said.Robert.At.BMC,.we.are.committed.to.providing.you.the.best.Goodman,.senior.database.administrator,.Florida.Hospital..database.tools.and.utilities.for.the.lowest.total.cost.of.“IBM.brought.BMC.Software.in.as.a.vendor.showed.us.ownership..We.continue.to.deliver.on.that.promise.with.their.products.and.actual y.recommended.that.we.consider.DB2.performance,.administration,.and.recovery.utilities.and.the.BMC.Software.products.for.our.volume.and.needs..We.solutions..We.augment.our.technology.with.one.of.the.best.went.through.negotiations,.closed.the.deal.and.have.been.customer.support.organizations.in.the.industry.to.ensure.using.BMC.utilities.ever.since.”.The.hospital.frequently.has.that.when.you.choose.BMC,.you.are.getting.the.most.from.benchmarked.BMC.against.major.competitors.during.the.your.software.investment.last.several.years..“In.every.case,.we.found.that.when.it.came.to.availability.and.features,.the.other.market.players.just.couldn’t.touch.the.BMC.utilities.—.at.least.not.in.our.environment,”.Goodman.said.End.Notes:1..Peter.Kastner,.Vice.President.and.Research.Director,.Information.Technology..Aberdeen.Group,.Inc.PA G E > About BMC SoftwareBMC.Software.delivers.the.solutions.IT.needs.to.increase.business.value.through.better.management.of.technology.and.IT.processes..Our.industry-leading.Business.Service.Management.solutions.help.you.reduce.cost,.lower.risk.of.business.disruption,.and.benefit.from.an.IT.infrastructure.built.to.support.business.growth.and.flexibility..Only.BMC.provides.best.practice.IT.processes,.automated.technology.management,.and.award-winning..BMC®.Atrium™.technologies.that.offer.a.shared.view.into.how.IT.services.support.business.priorities..Known.for.enterprise.solutions.that.span.mainframe,.distributed.systems,.and.end-user.devices,.BMC.also.delivers.solutions.that.address.the.unique.challenges.of.the.midsized.business..Founded.in.1980,.BMC.has.offices.worldwide.and.fiscal.2006.revenues.of.more.than.$1.49.billion..Activate.your.business.with.the.power.of.IT..www.bmc.com.*64257*BMC.Software,.the.BMC.Software.logos.and.all.other.BMC.Software.product.or.service.names.are.registered.trademarks.or.trademarks.of.BMC.Software,.Inc...All.other.registered.trademarks.or.trademarks.belong.to.their.respective.companies..©2006.BMC.Software,.Inc..All.rights.reserved..BP_RTV_CCM_US01..64257