munich 2016 - z011599 martin packer - more fun with ddf
TRANSCRIPT
Technical University/Symposia materials may not be reproduced in whole or in part without the prior written permission of IBM. 9.0
© Copyright IBM Corporation 2015
More Fun With DDF Session z011599
Martin Packer IBM
Abstract Theideaof"alien"DB2workcomingintoyoursystemthroughDDFstrikesfearintoeventhemostseasonedPerformanceSpecialist...
HowwillIclassifyit?
Whatwillstopitfromtakingovermymachine?
ThispresentaDondescribeshowtouseperformancedatatoaddressbothofthosequesDons,basedontheauthor'srecentexperienceswithnumerouscustomers.
ItalsoenablesyoutounderstandwhatapplicaDonsandmachinesareissuingtheDDFrequests,improvingyourknowledgeoftheapplicaDonlandscape.
What Is DDF?
• Oneofthemajorgatewaysintoz/OS• SpecifictoDB2astheserver
• AroundsinceDB2Version2• RefinedmanyDmessince
• Broadlyclientsare:• JDBC–'JCC'• z/OS–'DSN'• OS/400–'QSQ'• Other–'SQL'
• Higherriskof"feralSQL"
Why Do I Care About DDF?
• ManymodernapplicaDonsuseDDFtogettoDB2• You'dlikethemtoperformwell• You'dlikethemnottotakeoveryourmachine• You'dliketoknowwhattheyevenare
• Don'tyoujusthateitwhenworkshowsupandnobodytellsyou?
• You'dliketoensurezIIPexploitaDonisopDmal
But What Is A DDF Transac<on?
• ConversaDonsbetweenrequestorsandDB2areofvariablecomplexity
• Somedofewcommits• Somedomany
• Eachcommit/abortendsatransacDon• InfrequentcommitscanleadtolongtransacDons• Frequentcommitstoshortones
• SoatransacDonisgenerallynotawholeconversaDon
• ADDFtransacDonisaWLMtransacDon• Andwe'vealreadyseenthose
Mul<period Transac<ons
• AswithmanytransacDontypesWLMcanworkwith"periodaging"
• IfatransacDonaccumulatesenoughserviceit'llfallintosecondandsubsequentperiods
• Generallywe'retalkingaboutCPU
SMF 30 Contains Transac<on Rate
• SMF30ETCisIndependentEnclaveTransacDonRateCount• ProcessforDISTaddressspace• CountstransacDonsforallDDFserviceclassesservedbythesubsystem
• Likewisedoesn'tdisDnguishbetweenperiodendings• ManycustomershavemulDpleDB2subsystemsperLPAR
• Unnecessarytohaveseparateserviceclassesforeach• SMF30ETCletsyouseehowbusy,transacDonwise,eachsubsystemis
• CouldusefullydivideEnclaveCPUbytransacDonrate
DDF And The DB2 Accoun<ng Trace (SMF 101) Record
• Everythingyou'dexpectfroma101record• e.g.Timings• e.g.SQLCounts
• Plusmore:• DDFIdenDfiers(QMDAsecDon)• DDFCounters(QLACsecDon)• WLMServiceClass(QWACWLME)
• Recordsforrequesterandforserver• DB2onz/OStoDB2onz/OSappearstwice
• Oneineachsubsystem
• Recordscanberolledup• ACCUMACC=10isdefault
• 10thCommit/Rollback• Orsomeotherobscurecases
• ACCUMACC=NO• 1perCommit/Rollback
• CancalculateACCUMACCvaluefromSMF101
QMDA and QLAC Sec<ons
• QMDA–idenDfiers• Differentforz/OSandotherplahorms• UsefulfordesigningDDFWLMclassificaDonrules• AccounDngInformaDon• IPAddress/NetName• EndUserID• z/OSDB2CorrelaDon/PlaninformaDon• …
• QLAC–counters• Commonacrossallplahorms• Sent&Received• SQLStatements• Bytes• Rows• Blocks• Commits/Aborts• …
QWHS and QWACWLME
• QWHSCommontoSMF101recordsfromdifferenttypesofconnecDons.
• StandardHeaderinProductSecDon• QWHSLWID–24-byteLogicalUnitOfWorkID
• QWHSNID–8-byteNetworkName• QWHSLUNM–8-byteLUName• QWHSLUUV–6-byteUniquenessValue• QWHSLUCC–2-byteCommitCount
• QWHSLWID(minusQWHSLUCC)allowsyoutoDeaconversaDontogether.
• QWACWLMEuniquetoDDF• WLMServiceClass• Binaryzeroesforotheramachments
Batch And DDF – Strange Bedfellows?
• SAPBatchisnotJESBatch• Abunchof"transacDons"ieSMF101records• UniquecorrelatorinQWHSsecDon• Plonngcommit(orrecord)ratebyminuteDmesthejob• GivesbemergranularitythanJESBatch
• EgVaryingeffectofCPUqueuing–NotAccountedForDme
• Conversely,someJESBatchusesDDF• JobJamachestoSubsystemA• SubsystemAtalksDDFtoSubsystemB• FieldQTXAOTSEforAdocumentsDmespentinBandcommunicaDng
• CollectSMF101frombothsubsystems• CorrelatorsinQWHSsecDonsmatch
Maybe you learnt something like this
• DDFIsImportantToManage• DDFManagementneedstohappenwithWLMandbyapplicaDonexaminaDon/tuning
• AccounDngTraceSMF101iskeyinstrumentaDon• MarDnhassomesuperDFSORTcodetosummariseit
• DowntoarbitrarilyshortDmeintervals
• YoucanhavemorefunwithDDF(thanyoumight'vesupposed)