application tuning for ca datacom environments part ii

World®’16

ApplicationTuningforCADatacomenvironments– PartIIKevinShuma,VPProductManagementCATechnologies

MFX67EB

MAINFRAMEANDWORKLOADAUTOMATION

Abstract

ThisisatwopartsessionthatdescribesthevarioustechniquesusedtotuneaCADatacomapplicationforthebestpossibleperformance.Includedwillbediscussionsonavailablemonitoringtools.

ThissessionisprimarilyfocusedontheapplicationdeveloperwhoiswritingapplicationsfortheCADatacom®/DBdatabase.

KevinShuma

CATechnologiesVP,ProductManagement

Agenda

APPLICATIONTUNINGWITHINTHEAPPLICATION

WHATISTHEURTANDHOWDOESITAFFECTTHEAPPLICATION

GENERALPROGRAMMINGRECOMMENDATIONS

IDEALPROGRAMMINGRECOMMENDATIONS

AVAILABLETUNINGTOOLSANDRESOURCES

SUMMARY

ApplicationTuningwithintheapplication

§ Someapplicationissuesneedtoberesolvedwithintheapplication

§ Inothercases,newordifferentprogrammingtechniquescanbeusedtoimprovetheapplicationsperformance

§ Thissessionwilladdresswaystoimproveapplicationprocessingwithintheapplicationprogram

Bestpracticesthatcanbeapplied

WhatistheURTandhowdoesitaffecttheapplication

WhatisaURT?

§ Muchmorethanjustalistoftablesaccessedbytheprogram– Interfacecode(batchnon-Ideal)– Processingoptions– TableslistandSequentialReadAheadoptions– GBMAXR/GETBLK/SEQBUFS– GSETL/GETITinvokedautomaticallybyCAIdealFORconstructsunder

therightcircumstances– NotinvokedautomaticallyforCAMetaCOBOL+

Two-partwebcastisavailableonthesubjectofURTs

SequentialReadAheadSimplifiedview

HalfofSEQBUFSbuffers(1-16)filledNOW

SecondhalfofSEQBUFSbuffers(17-32)filledwhilefirsthalfarebeingprocessed

ApplicationRegion MUFRegion

GSETL/GETIT SEQBUFS=32

GETBLK=61440GBMAXR=255

BlockofrowsreturnedsubjecttoGBMAXRlimit(255is“unlimited”)

SequentialReadAhead(cont’d)

§ Pros– Significantlyfasterbatchsequentialprocessing– ReducedelapsedtimeduetoMUFread-ahead– ReducednumberofMUFtoapplicationcommunications

§ EspeciallyimportantwhenusingXCF– PossiblereducedIOsduetoveryfastbufferre-use

Simplifiedview

SequentialReadAhead(cont’d)

§ Cons– Significantpossibilityforapplicationprogramtomisusethe

functionality§ Gettinglotsofdatarowsthatareneveractuallyreadintheprogram§ Typicalwhennotreadingthekeyrangefrombeginningtoend§ Fornon-Ideal,besuretospecifythekeyrangeendvalue

– Gettinglotsofdatarowsandholdingthemunderexclusivecontrol§ IfURThasUPDATE=YESallrowspassedinBlockGETxxbufferarelocked§ CanbeminimizedbyusingsmallerGBMAXRand/orGETBLK(e.g.GBMAXR=10)

Simplifiedview

URTPriority

§ MUFBREAKparameterwillinfluenceeffectiveness– BREAK500suitableatmostsites

§ WhattospecifyforPRTY=inURTs:– HotCICSAORsandHotTrustedServer:12– NormalCICSAORsandTrustedServer:10– Hotbatch(Time-sensitiveorCriticalPath):8or9– Normalbatch:7(CADefault)– DataqueryCICSAORsandAd-hocServer:5– Dataquerybatch,DBSQLPRandDataReporter:3

Doesitstillreallymatter?InabusyMUF,Yes!

Generalprogrammingrecommendations

GeneralProgrammingRecommendations

§ Record-at-a-Time(RAAT)

§ Set-at-a-Time(SAATor“CBS”)

§ SQL

§ Canmixandmatchallthreeaccessmethodswithinasingleprogram

OneDBMS,threeAPIsavailableto3GLs(COBOL,PL/I,etc.)

Record-at-a-Time(RAAT)

§ MostcommonlyusedAPIforlegacyapplications– NotavailabledirectlytoprogrammersinCAIdeal– UsedbyCAMetaCOBOL+LOCATE/READstatements– SimilartoVSAMprogrammingAPI

§ Allprocessingselectionspredetermined(table,keys,elements)– Changestokeysorelementsrequireprogramchanges

§ Veryfastfordirectrandomkeyedaccess(LOCxx/REDxx)– Buteachrowisreturnedindividually– communicationsoverhead

Record-at-a-Time(RAAT)(cont’d)

§ Sequentialreadahead(GSETx/GETxx)– Batchonly– Veryfastiftrawlingthroughlargekeyranges– TuneGBMAXR/GETBLK/SEQBUFSinURT– “New”feature(r12)tospecifyend-of-key-rangeonGSETL

§ Oftenrowsarereturnedthatarelaterrejectedbytheapplicationinnon-zIIPprocessing

Set-at-a-Time(SAATor“CBS”)

§ APIbuiltforusewith4GLapplications– SimilartoSQLprogrammingAPI(withoutjoins)– CAIdealandCAMetaCOBOL+“FOR”constructs

§ CallDBNTRY….SELFR/SELNR/SELSM/SELPR

§ Dataviewscanonlyreferenceaverticalsubsetofasingletable

§ Canselectonnon-keycolumns,andorderrows– Reducingcommunicationsoverheadandperformingthe“sorting”onzIIP– ReviewoldprogramswithIFtestsandinternalsorts

Set-at-a-Time(SAATor“CBS”)(cont’d)

§ CAMetaCOBOL+doesNOTconvertSRAcandidatestoGSETL/GETIT

§ CAMetaCOBOL+(orCALL)doesallowSKIPprocessingwithintheset– Changedirectionorjumptotop/bottomofset,orrelativeposition– Greatforsimple(single-table)scrollingapplications

§ TuneusingCBStrace– “$$$”inchars1-3ofUIB

§ Manualjoins(nestedFOR)oftenmeansrowsarereturnedthatarelaterrejectedbytheapplicationinnon-zIIPprocessing

§ Thetemporaryindex– CBSexaminestherequestmadeanddetermineshowtoaccessthedata– Atemporaryindexisbuiltif

§ Mixedascending/descendingORDERBY§ ORDER/GROUPBYanon-keyfield§ Signednon-positivenumericfieldspossibleinkey§ CBSchoseabetterkeytosatisfytheWHEREclause

– SometimesatemporaryindexisNOTabadthing.§ Unnecessaryonesshouldbeeliminated

CBS- BuildingatemporaryindexMixedORDERBYwithbothascendinganddescending

FOR FIRST PRICE-LIST-R001 WHERE EFCTV-DATE = W.EFCTV-DATE

AND FGI-ID = W.FGI-ID AND PRICE-CLS-ID = W.PRICE-CLS-ID AND ALWN-BRCKT-CDE GT $SPACES

ORDERED BY EFCTV-DATE FGI-ID PRICE-CLS-IDDESCENDING ALWN-BRCKT-CDE

FOR FIRST PRICE-LIST-R001 WHERE EFCTV-DATE = W.EFCTV-DATE

AND FGI-ID = W.FGI-ID AND PRICE-CLS-ID = W.PRICE-CLS-ID AND ALWN-BRCKT-CDE GT $SPACES

ORDERED BY DESCENDING EFCTV-DATE FGI-ID PRICE-CLS-IDALWN-BRCKT-CDE

Before After

Allthe“ascending”columnsintheORDERBYarespecifiedasequalitiesintheWHEREclause,sotheORDERBYcanbechangedwithoutimpactingtheprogram

CBS- Buildingatemporaryindex(cont’d)

§ SQLCREATETABLEstatementsalwaysdefinenumericcolumnsassigned– DBAcanchangetounsignedafterwards

§ Ifthecolumnonlyevercontainspositivevalues– DBAshouldsetTYPE-NUMERIC=Pattribute

§ Ifthecolumndoescontainnegativevalues– DBAshouldsetDATA-SENSITIVEattribute

Signednumericcolumnsinkey

CBS- DeterminingthebestkeytouseforCBS

§ CBSdynamicallychoosesthebestkeytousebasedoninformationinthewhereandorderbyclauses

§ Becarefulwhentryingtosecond-guessCBS– RunaCBStracetocheckthatyourassumptionwascorrect– Withtwosimilarcandidatekeys,StatisticalPopulationCountingcan

changethekeyselectionatruntime

§ Inthefollowingexample– TheORDERBYmatchesthenativekey– ButabetterkeymatchestheWHEREclause

CBS- DeterminingthebestkeytouseforCBS(cont’d)Orderbydeterminesthekey– butisnotthebestchoice

FOR FIRST SALES-EST-PD WHERE MARKET-CODE EQ W.MARKET-CODE

AND SOURCE-CODE EQ $SPACES AND CURRENT-WEEK EQ W-WEEK AND CPCK-ITEM-CODE EQ $SPACES AND SETUP-WEEK-10 GE SETUP-DATE

ORDERED BY MARKET-CODE SOURCE-CODE

CURRENT-WEEK SETUP-WEEK-10

FOR FIRST SALES-EST-PD WHERE MARKET-CODE EQ W.MARKET-CODE

AND SOURCE-CODE EQ $SPACES AND CURRENT-WEEK EQ W-WEEK AND CPCK-ITEM-CODE EQ $SPACES AND SETUP-WEEK-10 GE SETUP-DATE

ORDERED BY MARKET-CODECURRENT-WEEK

SOURCE-CODE :MovedCPCK-ITEM-CODE :InsertedSETUP-WEEK-10

Before After

StatisticalPopulationCountingandaTemporaryIndex Nowadirectselection

CBS- MoreWHEREclausetips

§ AvoidNOToperator,iffeasible– WHEREACTIVE=“Y”…ratherthan…– WHEREACTIVE<>“N”

§ Specifyanalternativeto“OR”-ingvaluesforafield- usearange,iffeasible– WHEREQTY=3OR4OR5…becomes…– WHEREQTY>=3ANDQTY<=5– ConverttoIFstatementONLYinspecialcircumstances

§ Agile/DevOps- Quicktodevelop/maintain

§ Alljoins/aggregation/formattingdoneinMUF– AvailableforzIIPprocessing– Keepstheapplicationsmall/simple/efficient

§ Minimizescommunicationsoverhead– SQLpre-fetchworksforCICSrequeststoo

§ Ifthereissyntax/functionalityyouneed…– Submityourenhancement“Ideas”

Industrystandardsyntax

SQL(cont’d)

§ SQLConstraintscanbeusedtoimplementbusinessrules– RunsinMUF(onzIIP)– Reducesneedforprogram“checks”

§ Don’tallowadeleteofacustomerthatstillhasanorder§ Onlyallowtype“A,B,C”§ UtilizeCASCADEtotriggerfulldeletes

§ SQLCACHEcanbeimplementedtoimproverepeateddynamicqueries

Industrystandardsyntax

SQLtuningtips

§ INvs.OR– WHERECAT_TYPEIN(’05’,’07’)– WHERECAT_TYPE=’05’ORCAT_TYPE=’07’– UsuallyORisbetter

§ ORvs.BETWEEN– WHERECAT_TYPEIN(’05’,’06’,’07’)– WHERECAT_TYPE=’05’ORCAT_TYPE=’06’ORCAT_TYPE=’07’– WHERECAT_TYPEBETWEEN’05’AND‘07’– UsuallyBETWEENisbetter

Simplewhereclausepredicatetips

SQLtuningtips(cont’d)

§ IndexcardinalitystatsandRowCounts– RETIXDBID=100,KEYNAME=*SETR– REPORTAREA=IXX,DBID=100,TYPE=G,UPDATE=YES– Don'tforgetUATenvironments– EspeciallyifrefreshedusingDASDutilities

§ SYSMSGenhancements– Mucheasiertounderstand– Predicatemessagesnolonger“lost”inPXX– SELECT*FROMSYSADM.SYSMSGWHEREPLANNAME='KEVIN';

SQLqueryoptimizationhousekeeping

COBOLtuningtips

§ COBOLSTRING/UNSTRINGwithpointerisveryefficient

§ Cachingusinginternalarrays– Goodorbad?– Directaccesscanbegood– SearchingisCPU-intensive

§ OrdertheEVALUATEpredicatesbymost-used->Least-used

COBOLtuningtips(cont’d)

§ CBLOPTIMIZE– Dualcompile?

§ EnterpriseCOBOL5.xandbeyond- thebiggeststepchangesinceCOBOLII– Architectureexploitation(ARCH)– Choosethehighestlevelsupportedbyyourhardware– IncludingyourDRsite

Idealprogrammingrecommendations

Idealprogramminggotchas- $SUBSTR

§ $SUBSTRisoneofthemostCPU-intensivefunctionsofCAIdeal– Nevercodea$SUBSTRwithfixedvaluesforbothSTART=andLEN=– Breakthetargetfieldintoagroupfieldandreferencethedatadirectly

asasimplefield

§ Don’trepeatthesame$SUBSTRfunctionunnecessarily– SETtheresultintoasimplefieldandthenreferencethatfieldin

subsequentstatements

Idealisapowerfullanguagebutsomeprocessescanbeexpensivetouse

Idealprogramminggotchas- $SUBSTR(cont’d)Idealisapowerfullanguagebutsomeprocessescanbeexpensivetouse

Level Field Name T I Ch/Dg ----- ------------------- - - -----1 SRA-DATA X 80

SELECT FIRST ACTION WHEN $SUBSTR(SRA-DATA,START=70,LENGTH=3) = 'ELM'

SET ELM = TRUE WHEN $SUBSTR(SRA-DATA,START=70,LENGTH=3) = 'DVW'

SET DVW = TRUE WHEN $SUBSTR(SRA-DATA,START=70,LENGTH=3) = 'PGM'

SET PGM = TRUE ENDSEL

Level Field Name T I Ch/Dg ----- ------------------- - - -----1 SRA-DATA 2 FILLER-1 X 692 SRA-ENT-TYP X 32 FILLER-2 X 8

SELECT FIRST ACTION WHEN SRA-ENT-TYP = 'ELM'

SET ELM = TRUE WHEN SRA-ENT-TYP = 'DVW'

SET DVW = TRUE WHEN SRA-ENT-TYP = 'PGM'

SET PGM = TRUE ENDSEL

Before After

Idealprogramminggotchas- $STRING

§ $STRINGisoneofthemostCPU-intensivefunctionsofCAIdeal– Dataiscopiedtoatemporaryworkarea,appendedandthencopiedto

thetargetarea– Whereappropriate,usethenewIdeal15.0DOCUMENTfeaturewith

variable-lengthfieldstoaccomplishthetask

§ Don’trepeatthesame$STRINGfunctionunnecessarily– Settheresultintoasimplefieldandthenreferencethatfieldin

subsequentstatements

Idealprogramminggotchas- $STRING(cont’d)Idealisapowerfullanguagebutsomeprocessescanbeexpensivetouse

SET W.DUPLICATE = FALSE LOOP VARYING W.SUB2 FROM 1 BY 1 UNTIL W.DUPLICATE

OR W.SUB2 = 640 IF DUP-PGM-DVW(W.SUB2) =

$STRING(RPT.PROGRAM,RPT.STATUS,RPT.DATAVIEW)

SET W.DUPLICATE = TRUE ENDIF

ENDLOOP

Before

Idealprogramminggotchas- $STRING

§ Whileweareherewhatelsecanweimprove?– Avoidloopingthroughthewholearray

§ Inthiscase,all640entriesaresearchediftheincomingitemisNOTaduplicate

§ Storethe“maximumentry#”valuewhenthearrayisbuiltandusethatvaluetoterminatetheloop

– Avoidre-testingthe“terminator”valueoneachiterationoftheloop

ENDLOOP

BeforeSET W.DUPLICATE = FALSE SET NEW-PGM-DVW = $STRING(RPT.PROGRAM,

RPT.STATUS,RPT.DATAVIEW)<<SEARCH-PGM-DVW>>LOOP VARYING W.SUB2 FROM 1 BY 1 UP THRU W.DVW-MAX

IF DUP-PGM-DVW(W.SUB2) = NEW-PGM-DVW SET W.DUPLICATE = TRUE QUIT SEARCH-PGM-DVW

ENDIFENDLOOP

ENDLOOP

BeforeSET W.DUPLICATE = FALSE SET NEW-PGM-DVW = $STRING(RPT.PROGRAM,

RPT.STATUS,RPT.DATAVIEW)<<SEARCH-PGM-DVW>>LOOP VARYING W.SUB2 FROM 1 BY 1 UP THRU W.DVW-MAX

IF DUP-PGM-DVW(W.SUB2) = NEW-PGM-DVW SET W.DUPLICATE = TRUE QUIT SEARCH-PGM-DVW

ENDIFENDLOOP

SET NEW-PGM-DVW = $STRING(RPT.PROGRAM,RPT.STATUS,RPT.DATAVIEW)

LOOP VARYING W.SUB2 FROM 1 BY 1 UP THRU W.DVW-MAX

UNTIL DUP-PGM-DVW(W.SUB2) = NEW-PGM-DVWENDLOOP IF W.SUB2 > W.SUB

SET W.DUPLICATE = FALSE ELSE

IfyoureallyhateQUIT

Idealprogramminggotchas– Internalsorting

§ AVOIDunnecessaryinternalsorts– UseSQLtojoin/aggregate/sortdataintorequiredsequence

§ MoveworktoMUFwherezIIPCPUcanbeused– UsethesortedreportfacilityofCAIdealinstead,ifappropriate– Ifinternalsortistheonlyoption,avoidrepeatedlycalculatingtheindex

subscript§ Calculatethe“subscript– 1”onceandusethatinallsubsequentstatements§ Usegroupfieldtomovewholearray“row”atonce

Ifinternalsortistheonlyoption,avoidrepeatedlycalculatingtheindexsubscript

LOOP VARYING W.SUB FROM W.ENTRIES BY -1 DOWN THRU 1IF W.CURR-KEY < W.PREV-KEY

SET WT.PROD-CD = W.PROD-CD(W.SUB) SET WT.CUST-CD = W.CUST-CD(W.SUB) SET WT.EFCT-DT = W.EFCT-DT(W.SUB) SET WT.TERM-DT = W.TERM-DT(W.SUB) SET W.PROD-CD(W.SUB) = W.PROD-CD(W.SUB - 1) SET W.CUST-CD(W.SUB) = W.CUST-CD(W.SUB - 1) SET W.EFCT-DT(W.SUB) = W.EFCT-DT(W.SUB - 1) SET W.TERM-DT(W.SUB) = W.TERM-DT(W.SUB - 1) SET W.PROD-CD(W.SUB - 1) = WT.PROD-CD SET W.CUST-CD(W.SUB - 1) = WT.CUST-CDSET W.EFCT-DT(W.SUB - 1) = WT.EFCT-DTSET W.TERM-DT(W.SUB - 1) = WT.EFCT-DT

ENDIFENDLOOP

BeforeLOOP VARYING W.SUB

FROM W.ENTRIES BY -1 DOWN THRU 1IF W.CURR-KEY < W.PREV-KEY

SET W.SUB2 = W.SUB - 1 SET WT.ARRAY-ROW =

W.ARRAY-ROW(W.SUB) BY POSITIONSET W.ARRAY-ROW(W.SUB) =

W.ARRAY-ROW(W.SUB2) BY POSITIONSET W.ARRAY-ROW(W.SUB2) =

WT.ARRAY-ROW BY POSITIONENDIF

ENDLOOP

Idealprogramminggotchas- $TRIM

§ $TRIMisoneofthemostCPU-intensivefunctionsofCAIdeal– Whenbuildingoutputtextstrings

§ Avoidrepeatedlytrimmingtrailingblanksandsoonfromthesameinputstrings

– Ifrepeatedlyreferencingfixed-lengthinput§ Converttovariable-lengthworkingdatafieldwith$TRIMjustonceandreferencethat

Idealprogramminggotchas- $TRIM(cont’d)

§ Appendingdatatoanoutput“message”string– Defineoutputmessagestringasvariable-lengthworkingdatafield;no

needfor$TRIM– UsetheCAIdeal15.0DOCUMENTfeature

§ Particularlyrelevanttothesetypesofapplications– InterfacingwithIBMMQ-Series– Ideal/webinterfaceoutputdocuments

Re-InitializingArrays

§ Inbatch,storageischeap,CPUisexpensive– Ifanarrayhastobeclearedmanytimesduringexecutionofaprogram

§ Keepanemptycopyofthearrayinworkingdata§ UseSETreal-array=empty-arrayBYPOSITION

§ InCICS,storageisnotsocheap,sothismethodmaynotbeappropriateforlargearrays

CallingNon-IdealSubprograms

§ IfusinganyLanguageEnvironment(LE)-enabledlanguage– MakesureyouareusingtheCEEUOPTRTEREUS=ONoption

§ EnsuresthatLEruntimeenvironmentisonlyestablishedonce§ Workingdataandsoonispreservedbetweencallsofthesubprogram§ Significantperformanceimprovementswheresubprogramiscalledrepeatedly

InsertorupdateexistingrowDeterminewhichtousebasedonlikelihoodthatrowalreadyexists

FOR FIRST dataviewnameWHERE...

update valuesWHEN NONE

FOR NEW dataviewnameinsert values

WHEN DUPLICATEhandle “unique” failures

ENDFORENDFOR

FOR NEW dataviewnameinsert values

WHEN DUPLICATEFOR FIRST dataviewnameWHERE...

update valuesENDFOR

ENDFOR

Rowisusuallypresent RowisusuallyNOTpresent

Dataviewsandelements

§ Dataviewsareacollectionofelements– Elementsaretheunitoftransfer

§ Definedasasinglefield– costsvsbenefits– nowonzIIP– Isolationfromothertablechanges– Agile/DevOps– SQLeffectivelydoesthis

§ Definedasthewholerow– Usewherethewholerowis/willbeALWAYSrequired

§ Definedasallthecolumnsinakey– Index-onlyprocessing.

ElementsareaDatacom-onlyconcept

AvailableTuningtoolsandresources

Built-intuningtools

§ PXXJobstatistics– ShowsnumberofDatabaserequestsandI/O’s

§ RXXreports(andREADRXX)– Usefultotrackmaintenanceactivityandtimes

§ DatacomAccounting– Canbeverylowoverheadifdefinedcorrectly– Canbeextremelydetailedforusewhenrequired

§ DynamicSystemTables

IncludedwiththeDatacomenvironment

Built-intuningtools(cont’d)

§ AUTOINFO/AUTOSTATUS/AUTOCOLLECT– Usefulinspottingtrendsandcontentions

§ MUF– EOJSYSPRINT– JESLOG

§ CBSDiagnostictrace

§ SQLplanmessageoptions(ortraces)

Built-intuningtools(cont’d)

§ CICSDEBUGFacility

§ CAIdealDEBUGfacility– Yesitrunsinbatch,andinruntime-onlyenvironments

§ IBMDebugTool– Basicbutcanbeveryuseful

CAApplicationTuningtools

§ CAIntertest– Functionallyrich– CodeCountingfeaturetoidentifyheavilyusedstatements

§ CASysview– Excellentforanalysisofcurrentactivity– CICSTransactionLogprovideshistoricalanalysis

§ MakesureSysview’sDCCTXPRhasbeenimplemented

AvailableforusewiththeDatacomenvironment

CAApplicationTuningtools(cont’d)

§ CAMainframeApplicationTuner(MAT)– MajornewtoolforCAIdealandCOBOLandothers– Virtuallynooverheadandnorecompilesrequired

§ IrecommendyouattendthevarioussessionsontheseproductswhileyouareatCAWorld

§ ComeseeusattheDatacomdemostation

AvailableforusewiththeDatacomenvironment

Externalresources

§ CADREonCACommunitiescommunities.ca.com/community/ca-datacom-cadre– Thereisnosuchthingasa“stupidquestion”– Askquestionsandshareyourexperienceswithdevelopersacrossthe

globe– Submityour“Ideas”forproductenhancements– Specificenhancementrequestsarewelcome– Non-specific“Iwishsomehow..”requestsarejustaswelcome

AvailabletoCADatacomusers

Externalresources(cont’d)

§ CASupport– support.ca.com/irj/portal/anonymous/newhome– ThefriendlyCAsupportstaffhavedecadesofexperienceandare

alwayshappytohelp

AvailabletoCADatacomusers

OurresultswhenapplyingapplicationtuningWehavemoreDatacomtablesthaneverbefore.Wehavemorerowsinthosetablesthaneverbefore.Wehavemoreapplicationsprocessingthedatathaneverbefore.Wehavefasterresponsetimes(batch,ServerandCICS)thaneverbefore.

Wehave30%lessCPU(MSUs)thanatthestartofthetuningexercise.ThemainframeisnolongerthehighestTCOserver.

SummaryCommentsfromthemanagingDBAforthetwositesprofiledinPartI

MainframeandWorkloadAutomation

FormoreinformationonMainframeandWorkloadAutomation,pleasevisit:http://cainc.to/9GQ2JI

RecommendedSessionsSESSION# TITLE DATE/TIME

MFX92S StrategyandVisionforCADatacomandCAIdeal 11/16/2016at12:45pm

MFX93S What’snewinCADatacom 11/16/2016at1:45pm

MFX94S ReducingTCOwithDatacomCompression(Presspack) 11/16/2016at3:00pm

MFX95SA ModernizingtheCADatacomdata – SQLAccessPartI 11/16/2016at3:45pm

MFX95SB ModernizingtheCADatacomdata – SQLAccessPartII 11/16/2016at4:30pm

MFX96S CADatacom/ADInstallation/UpgradeandMaintenance 11/17/2016at12:45pm

MFX97S CADatacom/ADReportUtilization,andinformationgatherforSupport 11/17/2016at1:45pm

MFX98SUsingSysview tomonitorandmeasureyourCADatacomenvironment– ADandDB

11/17/2016at3:00pm

MFX99S BirdsofaFeather/StumptheTechie! 11/17/2016at3:45pm

Questions?

Thankyou.

Stayconnectedatcommunities.ca.com

Thecontentprovidedinthis CAWorld2016presentationisintendedforinformationalpurposesonlyanddoesnotformanytypeofwarranty. The informationprovidedbyaCApartnerand/orCAcustomerhasnotbeenreviewedforaccuracybyCA.

ForInformationalPurposesOnlyTermsofthisPresentation

application tuning for ca datacom environments part ii

Technology

datacom cable - general cable america... · datacom this...

datacom/telecom - carling tech

datacom cable - graybarcanada.com

amazon web services - datacom › ... ›...

huawei datacom

2014 | 2015 annual report -...

datacom portfolio slide pp

datacom introduction

pak datacom limited - financials.psx.com.pk

datacom products - tools.ru us datacom telecom...

ca datacom®/db datacom 14... · ca technologies product...

datacom powerpoint

datacom® - ca technologies datacom 14 0 public-enu... ·...

devcon11 tuning blackboard learn 9 for high demanded...

datacom: practical pam4 test methods for electrical cdaui8...

defender datacom cabinets - crenlo · 9 defender ™...

datacom brochure 2020 - e.b. horsman · 2021. 6. 9. · ebh...

datacom line card

pak datacom pak datacom...

ca datacom® datacom 14 0 public-enu... · ca datacom®...