ca idms performance and tuning
TRANSCRIPT
![Page 1: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/1.jpg)
1 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
World®’16
CAIDMS™PerformanceandTuning
JohnSiraco,Director,SoftwareEngineeringCATechnologies
MFX69E
MAINFRAMEANDWORKLOADAUTOMATION
![Page 2: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/2.jpg)
2 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
Abstract
AftercompletingthiscourseyouwillbeabletoidentifythecomponentswithinanIDMSsystem,identifyandtakecorrectiveactionstodealwithperformanceissues.Youwillalsobefamiliarwiththetoolsavailableformonitoringandtuningaswellasdevelopmonitoringprocedures.
JohnSiraco
CATechnologiesDirector,SoftwareEngineering
![Page 3: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/3.jpg)
3 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
Agenda
IDENTIFYTHECOMPONENTSWITHINANIDMSCENTRALVERSION
DEALWITHPERFORMANCEISSUES
TAKECORRECTIVEACTIONS
IDENTIFYAVAILABLETOOLSFORMONITORINGANDTUNING
IDENTIFYPOTENTIALSCARCERESOURCES
ESTABLISHMONITORINGPROCEDURES
1
2
3
4
5
6
![Page 4: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/4.jpg)
4 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
FunctionsofMonitoringandTuning
§ Systemmonitoringistheprocessofmeasuringsystemperformanceandresourceconsumption
§ Systemtuningshouldbeundertakenonlywhen:– Systemmonitoringindicatesthatperformancegoalsarenotbeingmet– Achangeinthesystemworkloadforexistingapplicationsisanticipated– Achangetothetotalsystemworkloadisanticipated– Hardwaremodificationsarebeingintroduced
![Page 5: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/5.jpg)
5 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
StepsintheMonitoringandTuningProcess
1. IdentifythecomponentswithinanIDMSCentralVersion
2. DealwithPerformanceIssues
3. IdentifytheavailabletoolsforMonitoringandTuning
4. Identifypotentialscarceresources
5. Establishmonitoringprocedures
6. Takecorrectiveaction
![Page 6: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/6.jpg)
IdentifytheComponentswithinanIDMSCentralVersion
![Page 7: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/7.jpg)
7 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
ComponentswithinanIDMSCentralVersion
§ AnIDMSCentralVersion(“Region”/“DC/UCFSystem”)consistsof:– System-relatedentities– Database-relatedentities
![Page 8: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/8.jpg)
8 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
System-RelatedEntities
§ StartupModuleandIDMSNucleusModules
§ StoragePools
§ ProgramPools
§ Storageformaintaining(database)lockrelatedinformation
§ SystemAreas(Log– Scratch– Queue)
§ DataCommunication(DC)Components:– LineDrivers– CommunicationsLineswithLogicalandPhysicalterminals
![Page 9: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/9.jpg)
9 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
System-RelatedEntitiesContinued
§ SystemRunUnittasks
§ ExternalRunUnittasks
§ UserTasks(applications)
![Page 10: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/10.jpg)
10 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
Database-RelatedEntities
§ DictionariesandDatabases
§ DatabaseBuffers
§ Journals
![Page 11: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/11.jpg)
DealwithPerformanceIssues
![Page 12: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/12.jpg)
12 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
TypesofPerformanceIssues
WithinanIDMSCentralVersion,twotypesofperformanceissuescanarise:
§ SystemPerformanceissues
§ DatabasePerformanceissues
![Page 13: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/13.jpg)
13 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
IntroductiontoSystemPerformanceIssues
§ Identifycriticalresourcesthataffectsystemperformance
§ Identifyfactorsthatcontrolandlimittheavailabilityofthoseresources
![Page 14: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/14.jpg)
14 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesStoragePools
§ StoragePoolsarefound– Belowtheline/24-bitstorage/nonXAstorage(numbers0– 127)– Abovetheline/31-bitstorage/XAstorage(numbers128– 255)
§ Twotypesofstorage– SYSTEMtype:System,Terminal,Database– USERtype:User,UserKept,Shared,SharedKept
§ StoragePools0and255arerequired
§ StoragePool255containsSYSTEMtypestorageonly
§ StoragePool0containsSYSTEMtypeandeventuallyothertypes
![Page 15: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/15.jpg)
15 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesStoragePoolsContinued
§ DefinedinSYSGEN
§ Storagepools0and255definedinSYSTEMstatement:– ADDSYSTEMnnn
STORAGEPOOLXASTORAGEPOOL
![Page 16: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/16.jpg)
16 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesStoragePoolsContinued
§ Otherstoragepoolsthataredefinedinindividualstatements:– Belowtheline:
§ ADDSTORAGEPOOLnn(01<=nn<=127)– Abovetheline:
§ ADDXASTORAGEPOOLnn(128<=nn<=254)
![Page 17: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/17.jpg)
17 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesStoragePoolsContinued
§ Ifarequest(GetStorage)forXAstorageisdone,but:– NoXAstoragepoolforthattypeexists,or– XAstoragepoolforthattypeexists,butnospaceisavailableinit,then– Storageisallocatedoutof:
§ anonXApoolwhichcontainsthattype,or§ Ifnotexisting,outofstoragepool0§ ThisappliesforanonXA storagerequesttoo
![Page 18: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/18.jpg)
18 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesStoragePoolsContinued
§ DefineextrapoolstoseparateSYSTEMfromUSERstorage.(requiredforStorageProtection)
§ Optionflag193canbeusedtoreduceCPUusage
![Page 19: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/19.jpg)
19 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesStoragePoolsContinued
§ ExampleofSYSGENdefinitionstatements:
![Page 20: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/20.jpg)
20 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesStoragePoolsContinued
§ ShortonStorage(SOS)Conditionscanhaveamajorimpactonperformance.Twotypescanoccur:– Shortonstoragecondition(condition0)– Storagenotavailablecondition(condition1)
§ MessageDC015007iswrittentotheOperatorConsole:
![Page 21: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/21.jpg)
21 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesStoragePoolsContinued
§ IncaseofShortOnStorageconditions– Determinewhetherneedlessorexcessivestorageallocationsaremade– UseStorageLimitstolimitstorageutilizationpertask– Ifanon-XAstoragepoolisSOS,checkfortaskswithLOC=BELOWandif
possible,changeintoLOC=ANY– IfanXAstoragepoolisSOS,mayneedtoincreasethatpool– EventuallyreduceMAXTASKS
![Page 22: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/22.jpg)
22 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesStoragePoolsContinued
§ MonitorStorageutilizationwith:– DCMTDISALLSTORAGEPOOLS
§ Secondpool255containsruntimeDMCL,andisnota“real”storagepool
Anon-zerovalueinTimesSOSisaredflag
![Page 23: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/23.jpg)
23 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesStoragePoolsContinued
§ DCMTDISACTIVESTORAGE
![Page 24: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/24.jpg)
24 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesStoragePoolsContinued
§ OPERWATCHSP
Anon-zerovalueisaredflag
![Page 25: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/25.jpg)
25 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesStorageforDatabaseLocks
§ Shortonstorageofteniscausedbylockoverflow
§ Atstartup,storagefordatabaselocksispreallocatedinakindof“storagepool”outsideofthe“numbered”storagepools
§ SizeisbasedontheSYSLOCKSparameter(SYSGEN,SYSTEMstatement)
![Page 26: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/26.jpg)
26 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesStorageforDatabaseLocks
§ Incaseoflockoverflow,databaselocks“overflow”instoragepool255,whichincreasesthepossibilityforSOSconditions
§ Lockoverflowcandegradesystemperformance
§ MostoftencausedbylongrunningprogramswithoutCOMMITs(batchprogramsrunninginCentralMode)
![Page 27: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/27.jpg)
27 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesStorageforDatabaseLocksContinued
§ MonitorLockingstoragewith:– TheLOCKMONtask(STATUScommand)
Non-zerooverflowvaluesarearedflag
![Page 28: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/28.jpg)
28 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesStorageforDatabaseLocksContinued
§ DCMTDISPLAYLOCKSTATISTICS
![Page 29: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/29.jpg)
29 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesProgramPools
§ Areaofstoragethatis usedtoloadprogramsthatmustbeexecutedwithintheCentralVersion:– CAADSdialogs– Maps– Subschemas– Edit/CodeTables– AccessModules– Cobol,Assembler,Pl/Iprograms– Databaseprocedures
![Page 30: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/30.jpg)
30 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesProgramPoolsContinued
§ TypesofProgramPools:– 24-bitprogrampool– 24-bitreentrantprogrampool– 31-bitprogrampool– 31-bitreentrantprogrampool
§ MakeProgramPoolslargeenoughsothateachprogramisonlyloadedonce
![Page 31: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/31.jpg)
31 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesProgramPoolsContinued
§ ExampleofSYSGENdefinitionstatements:
![Page 32: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/32.jpg)
32 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesProgramPoolsContinued
§ IncreasesizeofProgramPoolsif:– Activeprogramsareoverlaidbyotherprograms– Youexperiencewaitsforprogrampoolspace
![Page 33: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/33.jpg)
33 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesProgramPoolsContinued
§ MonitorProgramPoolutilizationwith:– DCMTDISALLPROGRAMPOOLS
![Page 34: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/34.jpg)
34 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesProgramPoolsContinued
§ DCMTDISACTIVEXAREENTRANTPROGRAM
Values>1arean
indicationofapotentialpoolsizeproblem
Checkforvalues>0
![Page 35: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/35.jpg)
35 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesProgramPoolsContinued
§ OPERWATCHPR
![Page 36: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/36.jpg)
36 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesScratchArea
§ Containstemporarydatathatare usedbyonlinetasks
§ CanbeallocatedonDASDormemory
§ Recommendedtousememory– SizeequalstoSYSGENdefinitionorsizeofscratcharea
§ DefinedinSYSGEN– SYSTEMstatement“SCRATCHInSTOrageisYES”
§ CanbelocatedinXAor64-bitstorageifavailable
§ Significantlyimprovesruntimeperformance
![Page 37: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/37.jpg)
37 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesScratchAreaContinued
§ CheckscratchallocationswithDCMTDISPLAYSCRATCH
![Page 38: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/38.jpg)
38 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesTasks
§ ATASKisthebasicunitofworkwithinaCentralVersion
§ Consistsofexecutionofoneormoreprograms
§ Maximumnumberoftasksthatare determinedby:– MAXIMUMTASKS/MAXIMUMERUSinSYSTEMstatement– NumberofpredefinedSYSTEMRUNUNITS– Numberoflines– DeadlockDetectionTask– PrinterTask– Othermiscellaneoussystemfunctions
![Page 39: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/39.jpg)
39 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesTasksContinued
§ Monitorthenumberofactivetaskswith:– DCMTDISPLAYACTIVETASK
![Page 40: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/40.jpg)
40 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesTasksContinued
§ OPERWATCHACTIVETASK
![Page 41: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/41.jpg)
41 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesTasksContinued
§ Maximumnumberofconcurrenttaskshasadirectinfluenceonsystemperformance
§ Strategy:– InSYSGEN,specifyhighMAXIMUMTASKand/orMAXIMUMERUS– Immediatelyafterstartup,useDCMTVARYMAXTASKtosetvaluetoa
relativelylownumber– Observesystemperformance– UseDCMTtoincrease/decreaseMAXTASKSvalue
![Page 42: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/42.jpg)
42 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesTasksContinued
§ IndicatorstodecreaseMAXTASK– Systemexperiencesshortonresources– PMRM(Real-TimePerformanceMonitor)showslong/excessivewait
times– Frequentdeadlocksforasystemresourceareexperienced
§ IndicatorstoincreaseMAXTASK– IftheCentralVersionencountersaMAXTASKconditionandno
shortageonresourcesnorlongwaittimesareexperienced
![Page 43: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/43.jpg)
43 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesTasksContinued
§ UseDCMTDISPLAYSTATISTICSSYSTEMtocheckMAXTASK
![Page 44: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/44.jpg)
44 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesSystemRunUnits
§ Arepredefinedrununitstoprovidestandardservicesfor:– Signonprocessing– Messageprocessing– ProgramLoadingprocessing– Queueprocessing– Securityprocessing
§ DefinedinSYSGEN(SYSTEMstatement,viaRUNUNITSFORxxxclauses)
![Page 45: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/45.jpg)
45 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesSystemRunUnits
§ Startedduringstartupprocessing
§ Remainactiveuntilshutdown
![Page 46: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/46.jpg)
46 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesSystemRunUnitsContinued
§ Monitorsystemrununitswith:– DCMTDISPLAYRUNUNIT
![Page 47: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/47.jpg)
47 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesSystemRunUnitsContinued
§ PMRM– SystemRunUnitSummary
![Page 48: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/48.jpg)
48 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesSystemRunUnitsContinued
§ Adjustingthenumberofpredefinedrununitscanimprovesystemperformance
§ Considerations:– Insufficientpredefinedrununitscausesoverflowrununits– Eachoverflowrununitcausesextra overhead
![Page 49: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/49.jpg)
49 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesExternalRunUnits
§ OnlinetaskthatisinitiatedwithinaCentralVersiontoservicedatabaserequestsfromanexternalusersession(ERUs)
§ Originatesfrom:– Abatchapplication– AnotherCentralVersion– AnotherTPmonitorsuchasCICS
![Page 50: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/50.jpg)
50 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesExternalRunUnits
§ Canhavefollowingruntimecharacteristics:– LimitsforI/Os,recordlocks,storage– Inactiveandexternalwaittimes– Dispatchpriority– Areaacquisitionthresholdandretrycounts
![Page 51: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/51.jpg)
51 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesExternalRunUnitsContinued
§ NeedstohaveacorrespondingTASKdefinitiontoapplythesecharacteristics
§ Ifnotaskisfound,RHDCNP3Sisused
![Page 52: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/52.jpg)
52 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesResourceManagement
§ Fine-tuninghowaCentralVersioncontrolsresourcescanimprovetaskexecution
§ Taskresourcesaremanagedby:– Resourcecontrolelements(RCEs)– Resourcelinkelements(RLEs)– Deadlockpreventionelements(DPEs)
§ IfTIMESTHRESHOLDEXCEEDEDishigh,improveperformancebyallocatingmoreoftheindicatedelements
![Page 53: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/53.jpg)
53 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesResourceManagementContinued
§ DCMTDISPLAYSTATISTICSSYSTEM
![Page 54: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/54.jpg)
54 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesResourceManagement– DeadlockDetection
§ Adeadlockisanunresolvablecontentionforaresource
§ Aresourceiseithera:• Systemresource• Databaseresource
![Page 55: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/55.jpg)
55 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesResourceManagement– DeadlockDetection
§ Detectedbythedeadlockdetector(RHDCDEAD)
§ DEADLOCKDETECTIONINTERVALdefinesthefrequencywithwhichthesystemchecksfordeadlocks
§ Optionflag189canbeusedtospecifyasubsecondinterval
![Page 56: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/56.jpg)
56 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesResourceManagement– DeadlockDetectionContinued
§ Checkthisintervalwith:– DCMTDISPLAYDEADLOCK
– Theintervalisexpressedinseconds
![Page 57: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/57.jpg)
57 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesResourceManagement– Limits
§ Resourcelimitsspecifythemaximumamountofspecificresourcesagiventaskcanuseatruntime
§ Resourcesthatcanbelimitedpertaskare:– CALL(numberofservicecalls)– DBIO(numberofI/Os)– Locks(numberoflocks)– Storage(sizeofstorage)
![Page 58: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/58.jpg)
58 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesResourceManagement– Limits
§ LimitscanbedefinedatSYSTEMlevelforOnlineand/orERUStasks(global)and/orTASKlevel(individual)
![Page 59: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/59.jpg)
59 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesResourceManagement– LimitsContinued
§ Monitorgloballimitswith:– DCMTDISPLAYLIMIT
![Page 60: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/60.jpg)
60 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesResourceManagement– LimitsContinued
§ Monitorindividuallimitswith:– DCMTDISPLAYTASKtaskcode
![Page 61: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/61.jpg)
61 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesAbend DetectionandTimedFunctions
§ Systemperformancecanbeimprovedifabended tasks,loopingtasksandotherabnormalprocessingconditionsaredetectedpromptly
§ Thesoonerdetected,thesoonerresourcesthatare heldbythesetaskscanbefreedandmadeavailableforothertasks
![Page 62: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/62.jpg)
62 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesAbend DetectionandTimedFunctions
§ FollowingparametersandtimerscanbedefinedinSYSGEN,SYSTEMstatement:– CHKUSERtasks– DEADLOCKDETECTIONINTERVAL– EXTERNALWAIT– INACTIVEINTERVAL– RESOURCETIMEOUTINTERVAL– RUNAWAYINTERVAL– TICKERINTERVAL
![Page 63: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/63.jpg)
63 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesAbend DetectionandTimedFunctionsContinued
§ TickerIntervalisthemostimportantonebecauseitspecifieshowoftenaCentralVersionchecksforoccurrencesoftimer-relatedevents(defaultis1second)§ IftheTickerIntervalissetto60thenDeadlockDetectionrunsat60
seconds,settimestarttaskcannotstartataskinlessthen60seconds.Manyimplications.
![Page 64: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/64.jpg)
64 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesMultitasking
§ RunningaCentralVersioninmultitaskingcanbeconsideredif:– LparhasfreeCPUcycles– Lparconsistsofmultipleprocessors
§ Easytoactivate– MT=Y,SUBT=nandMTQDEPTH=nparametersinPARMstringofEXEC
card
![Page 65: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/65.jpg)
65 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesMultitasking
§ Increasedthroughputandreducedresponsetime
§ ThecostisaCPUincreasethatvariesfromsitetosite
![Page 66: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/66.jpg)
66 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesMultitaskingContinued
§ MonitorMultitaskingwithfollowingDCMTcommands:– DCMTDISPLAYSUBTASK– DCMTDISPLAYSUBTASKEFFECTIVENESS– DCMTDISPLAYMPMODE– DCMTDISPLAYMTQUEUEDEPTH
![Page 67: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/67.jpg)
67 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesMultitaskingContinued
§ DCMTDISPLAYSUBTASK
![Page 68: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/68.jpg)
68 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesMultitaskingContinued
§ DCMTDISPLAYSUBTASKEFFECTIVENESS
![Page 69: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/69.jpg)
69 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssueszIIP Exploitation
§ AnIDMSCentralVersioncanexploitzIIP processorsonthez9seriesandaboveforthez/OSoperatingsystem
§ EnablesoffloadingcomputingcyclestozIIPs,therebyincreasingoverallCPUthroughputatloweroperationalcosts
![Page 70: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/70.jpg)
70 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssueszIIP Exploitation
§ ApplyPTFsRO63129(18.0)andRO63736(18.5)
§ MostCAIDMSsystemcodeiseligibletorunonzIIP
![Page 71: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/71.jpg)
71 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssueszIIP ExploitationContinued
§ zIIPsupportisimplementedasfollows:– z/OSsoftwarefeatureHBB7709isrequiredtousezIIP– AddZIIP=YasstartupparameterinCentralVersionstartupjcl
![Page 72: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/72.jpg)
72 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssueszIIP ExploitationContinued
§ Followingrulesforloadmodulesneedtobemet:– Startupmodule(RHDCOMVS)mustbeinanauthorizedSTEPLIBlibrary– CAIDMSNucleusmodules(includingalllinedriversandservicedrivers)
mustbeinanauthorizedlibraryintheCDMSLIBconcatenation– TheIBMlanguagelibrary(CEE.SCEERUN)mustbeauthorizedifincluded
inCDMSLIBconcatenation– z/OSCallableServiceslibrary(SYS1.CSSLIB)mustbeinlinklistormustbe
authorizedifintheSTEPLIBconcatenation
![Page 73: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/73.jpg)
73 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssueszIIP ExploitationContinued
§ CheckifCentralVersionrunswithzIIP withDCPROFILtask
![Page 74: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/74.jpg)
74 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssueszIIP ExploitationContinued
§ MonitortheCPUtimeoffloadedtozIIP with:– DCMTDISPLAYSUBTASKEFFECTIVENESS
![Page 75: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/75.jpg)
75 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesExceptionResponse
§ ReduceterminalI/OoverheadbyassigningVTAMExceptionresponseprotocoltocertaintasksorlines
§ ReducesCPUtimebecauseterminalsarenotrequiredtorespondwithcompletionstatus
§ DefinedintheLINEandTASKdefinitionsinSYSGEN
![Page 76: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/76.jpg)
76 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
SystemPerformanceIssuesOperatingSystemRecommendations
§ Foroptimumperformance,anIDMSCentralVersionshouldalwaysberunnon-swappable
§ AwardanIDMSCentralVersionthehighestreasonabledispatchingpriority
§ Avoidthattheoperatingsystemwouldneedtodopaging
![Page 77: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/77.jpg)
77 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
IntroductiontoDatabasePerformanceIssues
§ Identifythemajortypesofresourcesbottlenecksthatarerelatedtoaccessingadatabasethataffectssystemperformanceandperformenvironmentaltuning
§ Pro-activetuningstartswithdatabaseandapplicationdesign
§ Poorperformancecanbecausedby:– ExcessiveI/Oactivity– Toomuchworkbeingrequired(CPU)– ResourceContention
![Page 78: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/78.jpg)
78 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesInformationGathering
§ Whatapplicationsareinvolved?– Onlineapplications– BatchprogramsrunninginCentralMode
§ Howdotheyaccessthedatabase?– Areasweeps– Randomaccess– Walkingchains– Indexprocessing– RetrievalorUpdate
![Page 79: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/79.jpg)
79 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesInformationGatheringContinued
§ TheDBMScollectsanumberofstatisticsonarununitorSQLtransactionlevel
§ Arecategorizedasbasicandextendedstatistics– Basicstatistics
![Page 80: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/80.jpg)
80 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesInformationGatheringContinued
§ Extendedstatistics
![Page 81: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/81.jpg)
81 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesInformationGatheringContinued
§ DatabaseStatisticsareaccumulatedonrununitlevel
§ Canbeaccessedthrough:– JREPORTS– ACCEPTSTATISTICSDML/GETSTATISTICSSQLcommands– SREPORTS– PMARPTs– DCMTDISPLAYTRANSACTION
![Page 82: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/82.jpg)
82 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesInformationGatheringContinued
§ FieldsinDatabaseStatisticstowatch:– PAGESREAD– PAGESWRITTEN– PAGESREQUESTED– OVERFLOW– NOOVERFLOW– RECORDSREQUESTED– RECORDSCURRENT
![Page 83: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/83.jpg)
83 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesInformationGatheringContinued
§ Oftenused“ratios”basedondatabasestatistics:– PAGES-REQUESTED/PAGES-READ– RECORDS-REQUESTED/PAGES-READ– RECORDS-REQUESTED/RECORDS-CURRENT– NOOVERFLOW/(OVERFLOW+NOOVERFLOW)
![Page 84: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/84.jpg)
84 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesInformationGatheringContinued
§ DCMTDISPLAYTRANSACTION
![Page 85: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/85.jpg)
85 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesInformationGatheringContinued
§ JREPORT8forsametransaction/run-unit
![Page 86: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/86.jpg)
86 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesExcessiveI/OActivity
§ OverallperformancecandegradeduetoexcessiveI/O– OnDatabasefiles(DatabaseI/O)– OnJournalfiles(JournalI/O)
![Page 87: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/87.jpg)
87 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesDatabaseI/O
§ FactorsinfluencingDatabaseI/Oare:– NumberofPagesaccessed
§ DatabasePagesover70%full§ CalcandViaoverflow§ Fragmentationofcompressed/variablelengthrecords§ Indexlevels/orphansincreasing§ Increaseoflogicallydeletedand/orrelocatedrecords
– Buffercontention– UseofPrefetch– UseofFileCaching– DASDcharacteristicsandDataSetPlacement
![Page 88: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/88.jpg)
88 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesDatabaseI/OContinued
§ ToolstomonitorDatabaseconditions:– PRINTSPACEutility(runsinbatchandonline)– PRINTINDEXutility(runsinbatchandonline)– IDMSDBANutility(batchonly)
![Page 89: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/89.jpg)
89 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesDatabaseI/OContinued
§ PRINTSPACEutility
![Page 90: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/90.jpg)
90 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesDatabaseI/OContinued
§ PRINTINDEXutility:SUMMARYreport
![Page 91: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/91.jpg)
91 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesDatabaseI/OContinued
§ IDMSDBANutility:Report3– SetAnalysis
![Page 92: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/92.jpg)
92 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesDatabaseI/OContinued
§ IDMSDBANutility:Report5– SetAnalysis– ChainLength
![Page 93: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/93.jpg)
93 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesDatabaseI/OContinued
§ IDMSDBANutility:Report5– SetAnalysis– PageChange
![Page 94: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/94.jpg)
94 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesBufferContention
§ Buffercontentioncanexistiftherearefewerbufferpagesthandatabasepagesmappingtothebuffer
§ CanincreasenumberofI/Osbecause:– TheDBMSmustre-usebufferpages– Itmayforceredundantreadsandwrites
![Page 95: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/95.jpg)
95 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesBufferContention
§ Recommendationstoreducebuffercontention– assignfrequentlyusedfilesandsequentiallyaccessedfilestoseparate
buffers– Defineonelargebufferforrandomlyaccessedareas
![Page 96: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/96.jpg)
96 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesBufferContentionContinued
§ MonitorBufferutilizationtocheck:– Thebufferutilizationratio– Bufferwaits– Whichfilesareaccessedmostoften
§ Bymeansof:– DCMTDISPLAYSTATISTICSBUFFER– RealTimePerformanceMonitor(PMRM)– JREPORTs03– SREPORTs03– 07- 09
![Page 97: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/97.jpg)
97 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesBufferUtilizationRatio
§ IstheNumberofPagesrequested/NumberofPagesread
§ Ratioof2orhighermeanseffectivebuffer
§ Ratiolowerthan2indicatestoofewpagesinbuffer
![Page 98: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/98.jpg)
98 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesBufferInfoExamples
§ DCMTDISPLAYSTATISTICSBUFFER
![Page 99: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/99.jpg)
99 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesBufferInfoExamplesContinued
§ PMRMBufferI/OSummary
![Page 100: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/100.jpg)
100 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesBufferInfoExamplesContinued
§ PMRMBufferI/OSummaryContinued
![Page 101: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/101.jpg)
101 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesPrefetch
§ Prefetch(orchainedreads):readmultipleblocksfromdiskwithasingleI/Orequest
§ Enabledbydefault,canbedisabled
§ WithinaCentralVersion:two tracksarereadwith1I/O
![Page 102: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/102.jpg)
102 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesPrefetch
§ Reduces:– I/Osifnearbypagesarealsoaccessed– I/OWaitsforbenefitingapplications
§ Increases:– DurationofanI/O– Buffercontention
![Page 103: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/103.jpg)
103 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesPrefetch Continued
§ ImpactofPrefetchdependsuponbuffersize
![Page 104: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/104.jpg)
104 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesPrefetch Continued
§ Prefetchcanbecontrolledwith:– ThePREFETCHparameterinSYSIDMS(defaultisON)– ThePREFETCHoptioninDCMTVARYDMCL,AREA,FILE,
BUFFER
§ Thedefaultprefetchlimitof500pagescanbeoverriddenby:– PREFETCH_BUFSYSIDMSparameter– DCMTVARYBUFFERnamePREFETCHlimit
![Page 105: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/105.jpg)
105 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesPrefetch Continued
§ UseDCMTDISPLAYBUFFERtocheckifprefetchisenabled
![Page 106: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/106.jpg)
106 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesPrefetch Continued
§ MonitorPrefetcheffectivenesswithOPERWATCHDBIO
![Page 107: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/107.jpg)
107 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD 107
DatabasePerformanceIssuesFileCaching
§ Howitworks
AdvantageCAIDMSCV/Local
Buffer
Cache
Onaread:– lookincache– iffound,moveto
buffer– ifnotfound,read
fromfile,copytocache
Onawrite:– copytocache– writetofile
![Page 108: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/108.jpg)
108 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesDataSetPlacement
§ GuidelinestoestablishaDASDconfigurationforanIDMSCentralVersion:– Isolatehigh-activitydatasetsasmuchaspossible– DatasetsaccessedbyIDMSCentralVersionsmustbeisolatedfrom
thoseaccessedbybatchjobs– Thegoalistoachievepathisolation– Onlinedatasetsshouldbeisolatedbypathandshouldbestoredonthe
fastestdevicespossible– PlacefilesonParallelAccessDevices(PAV)toallowconcurrentI/Os
againstthesamediskunit
![Page 109: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/109.jpg)
109 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesDataSetPlacementContinued
§ Isolatejournalfiles
§ DonotplaceCAIDMSfileswiththefollowing:– Paging,spool,orSYSRESdatasets– Heavilyusedpartitioneddatasets– Non-CAIDMSVSAMfilesofcatalogs
§ Isolatethelog,scratch,andqueuefilesifheavyCA-ADSdevelopmentorhighOLQusageoccurs
§ Isolatedictionaryareasfordevelopmentsystems
![Page 110: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/110.jpg)
110 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesJournalI/O
§ Factorsinfluencingperformance:– Journalpagesize– Journalbuffersize– Journaltransactionlevel
![Page 111: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/111.jpg)
111 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesJournalI/O- PageSize
§ IfJournalpagesizeistoosmall– Morepagesthatareneededtoholdimages– Morejournalwritesissued
§ Ifjournalpagesizetoolarge– Maywastejournalspace
![Page 112: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/112.jpg)
112 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesJournalI/O- PageSize
§ Recommendedminimumpagesize– 2*largest-record-size(upto32K)
§ MonitorARCHIVEJOURNALreport– Lowerpagesizeifmostjournalblocksnearempty– Increaseifmostjournalblocksarefull
![Page 113: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/113.jpg)
113 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesJournalI/O- BufferSize
§ Multiplejournalbufferpages– Enableoverlappedfillingandwritingofjournalblocks
§ Reducedwaittimesforjournaling– MayavoidjournalI/Oduringrecovery
§ Fasterrecovery§ Lessinterferencewithnormalactivity
![Page 114: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/114.jpg)
114 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesJournalI/O- BufferSize
§ Minimumfivepages
§ Systemswithlotsofabends…muchlargernumberofpages
![Page 115: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/115.jpg)
115 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesJournalI/O- BufferSize Continued
§ DCMTDISPLAYBUFFER
#ofbufferwaits.If>0,increaseBuffersize #recoveryI/Os
Iflarge,increaseBuffersize
![Page 116: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/116.jpg)
116 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesJournalI/O- JournalTransactionLevel
§ Enablesdeferringjournalwriteuntilblockisfull– Fewerjournalblockswritten– FewerjournalI/Os– Betterjournalfileutilization
§ While#ofupdatetransactionexceedsjournaltransactionlevel– CVdeferswriteofjournalblockuntilitfills
![Page 117: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/117.jpg)
117 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DatabasePerformanceIssuesJournalI/O- JournalTransactionLevelContinued
§ Journaltransactionlevelshouldbe:– 0(nodeferraloccurs)– Greaterthan3– Iftoolarge...nobenefit
§ DefinedinSYSGEN- SYSTEMstatement
§ CanbechangedatruntimewithDCMTVARYJOURNALTRANSACTIONLEVELn
§ MonitorARCHIVEJOURNALreport
![Page 118: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/118.jpg)
118 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
0
5000
10000
15000
20000
25000
# of Journal Blocks
JTL=4 JTL=5 JTL=0 or 10
Journal Block Utilization
DatabasePerformanceIssuesJournalI/O- JournalTransactionLevelContinued
![Page 119: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/119.jpg)
IdentifytheAvailableToolsforMonitoringandTuning
![Page 120: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/120.jpg)
120 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringTools
§ Interactive(real-time)tools– DCMTandOPERtasks,PerformanceMonitor(PMRM,PMAM,PMRM)
§ Postprocessingtools
![Page 121: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/121.jpg)
121 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsContinued
§ CAIDMStoolstoaidmonitoringandtuningprocess:– DC/UCFstatistics– DC/UCFlogmessages– DC/UCFjournals– Onlinefacilities– Reports– CAIDMS/DBPerformanceMonitor– CAIDMS/VisualDBA
![Page 122: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/122.jpg)
122 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsDC/UCFStatistics
§ System(-wide)statistics- alwayscollected
§ Taskandexternalrequestunitstatistics- optional
§ Transactionstatistics- optional
§ CA-ADSdialogstatistics- optional
§ Histograms- optional
§ User-writtenstatistics- optional
![Page 123: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/123.jpg)
123 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsSystemStatistics
§ System-widestatisticsarewrittentotheDC/UCFsystemlog:– Automaticallyatnormalsystemshutdown– Atthestatisticsintervalthatisspecifiedinthesystemgeneration
SYSTEMstatement,parameterSTATISTICSINTERVALtime– Atthestatisticsintervalrollthatisspecifiedinthesystemgeneration
SYSTEMstatement,parameterSTATISTICS ROLL TIME interval-roll-time FREQUENCY day-frequency
– OnexplicitrequestwithaDCMTWRITESTATISTICSorDCMTWRITESTATISTICSROLLcommand
![Page 124: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/124.jpg)
124 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsSystemStatisticsContinued
§ ExampleofSystemStatisticsasfoundinaPRINTLOGoutput
![Page 125: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/125.jpg)
125 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsOtherStatistics
§ Taskandexternalrequeststatistics
§ Transactionstatistics
§ CA-ADSdialogstatistics
![Page 126: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/126.jpg)
126 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsHistograms
§ Histogramstrackthefrequencyofspecificevents
§ Accumulatedinsystemcontrolblocksatruntime,andwrittentotheDC/UCFLogatthefollowingtimes:– Normalsystemshutdown– Thestatisticsintervalthatis establishedbytheSTATISTICS
parameter(SYSGEN)– ExplicitrequestwithDCMTWRITESTATISTICS
![Page 127: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/127.jpg)
127 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsHistograms
§ Threetypesofhistograms:– System-widehistograms(alwayscollected)– Taskhistograms(optional)– Linehistograms(optional)
![Page 128: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/128.jpg)
128 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsUser-WrittenStatistics
§ Implementedviauserexits
§ Allowstogaincontrolatselectedpointsinthestatistics-writingprocess
§ Examples:– IDMSSVCX(SVCexit)– Exit5(Taskterminationexit1)– Exit9(Systemstatisticsexit)– Exit15(VIBstatisticsexit)
![Page 129: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/129.jpg)
129 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsDC/UCFLog
§ DC/UCFLogmessages– Usefulindetectingabends
![Page 130: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/130.jpg)
130 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsDC/UCFLogContinued
§ ExampleofTaskPhotointheDC/UCFafterataskabend
![Page 131: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/131.jpg)
131 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsDC/UCFLogContinued
§ ExampleofTaskPhotointheDC/UCFafterataskabend
![Page 132: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/132.jpg)
132 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsDC/UCFLogContinued
§ ExampleofTaskPhotointheDC/UCFafterataskabend
![Page 133: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/133.jpg)
133 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsJournals
§ DC/UCFJournals– Vitalcomponentfordatabaserecovery– Sourceofdatabaseactivitystatistics– ThearchivedjournalscanbeusedasinputforourJREPORTs
CentralVersion
ArchiveJournal
DiskJournals
ArchivedJournal
ReportTool
Jreport
![Page 134: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/134.jpg)
134 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsJournalReports
§ ExampleofJournalReport1– TransactionSummary
![Page 135: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/135.jpg)
135 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsJournalReportsContinued
§ ExampleofJournalReport2– ProgramTerminationstatistics
![Page 136: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/136.jpg)
136 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsJournalReportsContinued
§ ExampleofJournalReport4– ProgramSummary
![Page 137: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/137.jpg)
137 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsJournalReportsContinued
§ ExampleofJournalReport8– Formatteddump
![Page 138: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/138.jpg)
138 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsJournalReportsContinued
§ ExampleofJournalReport8– Formatteddump(part2)
![Page 139: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/139.jpg)
139 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsOnlineFacilities
§ OnlinePrintLogutility(OLP)
§ MasterTerminalfacility(DCMT)
§ Operatorfacility(OPER)
§ DCProfile(DCPROFIL)
§ Lookfacility(LOOK)
§ LockMonitor(LOCKMON)
§ CAIDMSPerformanceMonitor(optional)
![Page 140: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/140.jpg)
140 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsOnlineFacilitiesContinued
§ OnlinePrintLogutility(OLP)
![Page 141: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/141.jpg)
141 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsOnlineFacilitiesContinued
§ DCMTcommandtoshowallofitssub-commands
![Page 142: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/142.jpg)
142 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsOnlineFacilitiesContinued
§ DCMTHELPSEGMENTcommand
![Page 143: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/143.jpg)
143 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsOnlineFacilitiesContinued
§ OPERTask
![Page 144: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/144.jpg)
144 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsOnlineFacilitiesContinued
§ OPERTaskwithWATCHCPUsub-command
![Page 145: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/145.jpg)
145 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsOnlineFacilitiesContinued
§ OPERTaskwithWATCHCRITICALRESOURCESsub-command
![Page 146: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/146.jpg)
146 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsOnlineFacilitiesContinued
§ DCPROFILTask
![Page 147: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/147.jpg)
147 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsOnlineFacilitiesContinued
§ DCPROFILTaskContinued
![Page 148: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/148.jpg)
148 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsOnlineFacilitiesContinued
§ LOOKtask
![Page 149: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/149.jpg)
149 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsOnlineFacilitiesContinued
§ LOOKtaskContinued
![Page 150: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/150.jpg)
150 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsOnlineFacilitiesContinued
§ LOCKMONtask
![Page 151: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/151.jpg)
151 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsOnlineFacilitiesContinued
§ LOCKMONtaskContinued
![Page 152: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/152.jpg)
152 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsReports
§ DatabaseUtilities– PRINTSPACE– PRINTINDEX– IDMSDBAN
§ DatabaseActivity– JREPORTs
§ SystemActivity– SREPORTs
§ CAIDMSPerformanceMonitor
![Page 153: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/153.jpg)
153 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/PerformanceMonitor
§ Overview– PerformanceMonitorisaperformanceandtuningtoolthatyoucan
usetomonitorhardwareandsoftwareresourcesthatareusedinanIDMSCentralVersion
§ BenefitsofusingCAIDMSPerformanceMonitorinclude:– Easeofuse– Windowingfacility– Applicationanddatabasemonitoring– Onlineandbatchreportingtools
![Page 154: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/154.jpg)
154 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/PerformanceMonitorContinued
§ Perfmonstatisticsarewrittento– TheDC/UCFlog(DDLDCLOGareaofthesystemdictionary)– TheSMFjobaccountingfile(z/OSonly)
§ OnlinecomponentsofCAIDMS/PerformanceMonitor:– TheReal-timeMonitor– TheIntervalMonitor– TheApplicationMonitor
§ Batchcomponents(reports)areaddedasmodulesintheSYSDIRLdictionaryduringinstallationoftheproduct
![Page 155: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/155.jpg)
155 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/PerformanceMonitorContinued
§ TheReal-timeMonitorinitialscreen
![Page 156: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/156.jpg)
156 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/PerformanceMonitorContinued
§ TheReal-timeMonitorSystemRunUnitSummaryscreen
![Page 157: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/157.jpg)
157 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/PerformanceMonitorContinued
§ TheReal-timeMonitorActiveUser TaskDetailscreen
![Page 158: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/158.jpg)
158 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/PerformanceMonitorContinued
§ TheReal-timeMonitorExampleofonlinehelpfacility
![Page 159: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/159.jpg)
159 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/PerformanceMonitorContinued
§ TheIntervalMonitorinitialscreen
![Page 160: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/160.jpg)
160 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/PerformanceMonitorContinued
§ TheIntervalMonitorStorageDetailscreen
![Page 161: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/161.jpg)
161 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/PerformanceMonitorContinued
§ TheApplicationMonitorinitialscreen
![Page 162: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/162.jpg)
162 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/PerformanceMonitorContinued
§ TheApplication Monitor EntitySelectionscreen
![Page 163: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/163.jpg)
163 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/PerformanceMonitorContinued
§ TheApplication Monitor EntityListscreen
![Page 164: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/164.jpg)
164 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/PerformanceMonitorContinued
§ TheApplication Monitor GeneralStasticsscreen
![Page 165: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/165.jpg)
165 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/PerformanceMonitorContinued
§ TheApplication Monitor DCStatisticsscreen
![Page 166: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/166.jpg)
166 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/PerformanceMonitorContinued
§ TheApplication Monitor DBandWaitStatisticsscreens
![Page 167: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/167.jpg)
167 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsBatchComponentsofCAIDMSPerformanceMonitor
§ IntervalMonitorReports
§ ApplicationMonitorReports
§ ConsistofanumberofstandardCACulpritmodulesthatare deliveredduringinstallation
§ Canberunusingthestatisticsthatare foundin– Anarchivedlog(ifloggingtotheDC/UCFlog)– AnextractionfromtheSMFjobaccountfile(usingPMSMFEX)
![Page 168: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/168.jpg)
168 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsBatchComponentsofCAIDMSPerformanceMonitorContinued
§ ExampleofPMIRPT04– SummaryWaitDetailReport
![Page 169: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/169.jpg)
169 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsBatchComponentsofCAIDMSPerformanceMonitorContinued
§ ExampleofPMIRPT11– I/OByAreaSummaryReport
![Page 170: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/170.jpg)
170 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsBatchComponentsofCAIDMSPerformanceMonitorContinued
§ ExampleofPMIRPT13– BufferSummaryReport
![Page 171: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/171.jpg)
171 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsBatchComponentsofCAIDMSPerformanceMonitorContinued
§ ExampleofPMIRPT18– StoragePoolSummaryReport
![Page 172: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/172.jpg)
172 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsBatchComponentsofCAIDMSPerformanceMonitorContinued
§ ExampleofPMARPT02– TaskSummaryReport
![Page 173: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/173.jpg)
173 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsBatchComponentsofCAIDMSPerformanceMonitorContinued
§ ExampleofPMARPT17– DatabaseDetailReport
![Page 174: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/174.jpg)
174 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsBatchComponentsofCAIDMSPerformanceMonitorContinued
§ ExampleofPMARPT18– DatabaseSummaryReport
![Page 175: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/175.jpg)
175 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/VisualDBA
§ Overview– Easytousegraphicaluserinterface(GUI)toolforperforming:
§ Databaseadministrationandmonitoring§ Systemadministrationandmonitoring
![Page 176: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/176.jpg)
176 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/VisualDBA
§ BenefitsofusingCAIDMS/VisualDBAinclude:– Easeofuse
§ NoJCLorsyntaxknowledgerequired§ Containsextensivehelpsystem
– ReducesthelearningcurveforanewDBA– IncreasestheproductivityofanexperiencedDBA
§ AvailabletoallCAIDMSclientsatnocharge
![Page 177: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/177.jpg)
177 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/VisualDBAContinued
§ UsesCAIDMS/ServertocommunicatewithoneormoreCentralVersions
§ ConnectionswithCentralVersionsaremadebasedonODBCDatasources
§ AllowstoconnecttomultipleCentralVersionssimultaneously
![Page 178: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/178.jpg)
178 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/VisualDBAContinued
§ UsesmanyWindowsfeaturessuchas:– Drill-downandpop-upmenus– Tear-outWindowstocustomizeaview– Drag-and-dropandcut-and-pasteability– Tabbartoquicklyaccessawindowandothers
![Page 179: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/179.jpg)
179 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/VisualDBAContinued
§ ManagesalmostallknownCentralVersionentitiesasobjects
![Page 180: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/180.jpg)
180 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/VisualDBAContinued
§ InitialviewafterbeingconnectedwithaCentralVersion
![Page 181: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/181.jpg)
181 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/VisualDBAContinued
§ ExampleofDatabaseSpaceMonitoring(classicchart)
![Page 182: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/182.jpg)
182 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/VisualDBAContinued
§ ExampleofDatabaseSpaceMonitoring(piechart)
![Page 183: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/183.jpg)
183 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/VisualDBAContinued
§ ExampleofDatabaseBufferMonitoring(barchart)
![Page 184: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/184.jpg)
184 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/VisualDBAContinued
§ ExampleofStoragePoolMonitoring(piechart)
![Page 185: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/185.jpg)
185 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSMonitoringToolsCAIDMS/VisualDBAContinued
§ ExampleofProgramPoolMonitoring(piechart)
![Page 186: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/186.jpg)
IdentifyPotentialScarceResources
![Page 187: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/187.jpg)
187 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
IdentifyPotentialScarceResources
§ Identifyscarceresources– Reducedemandforthoseresources– Increasetheamountofthoseresourcesinthesystem
![Page 188: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/188.jpg)
188 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
Resources
§ Categoriesofsystemresources:– CPU– DASD
§ Storagespace§ Accesstostoreddata(I/O)
– Memory§ Realstorage§ Virtualstorage
![Page 189: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/189.jpg)
189 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
ResourcesContinued
§ Database-relatedresources:– DB-keylocks– Arealocks– Buffers– Journals
![Page 190: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/190.jpg)
EstablishMonitoringProcedures
![Page 191: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/191.jpg)
191 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
GuidelinesforEstablishingMonitoringProcedures
§ Threeareasofperformancemonitoring:– Routinemonitoringprocedures– Monitoringforperformancetroubleshooting– Applicationtestingandmonitoring
![Page 192: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/192.jpg)
192 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
RoutineMonitoringProcedures
§ Operatingsystemstatistics
§ Onlinemonitoring
§ Shutdownorintervalstatistics
§ Journalreports
§ PRINTSPACEUtilityreport
![Page 193: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/193.jpg)
193 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
RoutineMonitoringProcedures
§ PRINTSPACEUtilityreport
§ PRINTINDEXSUMMARYreport
§ DatabaseAnalysisUtilityreports(IDMSDBAN)
§ PerformanceMonitorreports
![Page 194: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/194.jpg)
194 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
MonitoringforPerformanceTroubleshooting
§ OPERWCRITLOGRCA
§ DCMTDisplaySTATistics SYSTEM
§ DCMTDisplayACTive TASK
§ DCMTDisplayTRansaction
§ OPERWatchDB
§ OPERWatchTIme
§ OLP
![Page 195: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/195.jpg)
195 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
GuidelinesforAnalyzingCPUUsageChanges
§ Themajorareastobeexaminedare:– ChangestotheDC/UCFsystemconfiguration– Changestoexistingapplications– Additionofnewapplications– DMCLchanges– Increaseintaskabends– Changestohardwareorsoftwareenvironment– Databasebottlenecksorincreaseinotherresourcecontention
![Page 196: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/196.jpg)
196 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
AnalyzingDC/UCFSystemConfigurationChanges
§ ThefollowingtypesofchangesaremostlikelytocauseanincreaseinCPUusage:– Increaseinstatisticscollection– Storageprotection– JOURNALRETRIEVAL– Increaseinnumberofterminals– IncreaseinMAXERUS/MAXTASK– Additionofsecurityresourceschecked– Compressionroutines(RBBs,LINES,andDBPROCs)
![Page 197: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/197.jpg)
197 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
AnalyzingApplicationChanges
1. ApplicationchangescoincidentalwithincreaseinCPUusage
2. Frequencywithwhichapplicationsareexecuted
3. Determinewhetherthechangesinvolveadditionalwork
4. Continuetheexaminationusingapplicationmonitoringandtuningtechniques
![Page 198: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/198.jpg)
198 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
NewApplications
§ IdentifyallnewapplicationswhoseadditiontosystemcoincideswithincreaseinCPU
§ Examineprogramstatistics
§ Examinethesystem-impacttestingresults
§ Followupwithapplication-levelmonitoringandtuningtechniques
![Page 199: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/199.jpg)
199 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DMCLChanges
§ TypesofchangesmostlikelytoincreaseCPUusage:– Decreasethenumberofbuffersforheavy-usepool– Assignextrafilestoexistingpool
§ Totunebufferpools,youcanadopteitherofthefollowingstrategies:– Increasenumberofbufferswithinexistingpools– Changefiletobuffermappingconfiguration
![Page 200: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/200.jpg)
TakeCorrectiveActions
![Page 201: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/201.jpg)
201 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
ExpandingtheDatabase
§ Expansionchoices:– EXPANDPAGE(increasepagesize)– EXTENDSPACE(addpagestoendofarea)– Unloadingandreloading(pagesizeandnumberofpages)
§ UNLOAD/RELOAD§ REORG
![Page 202: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/202.jpg)
202 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
IntegratedIndexes
§ PRINTINDEXwithSUMMARYoption
§ ChecktheOrphanCountsandindexlevels
§ TUNEINDEX
§ MAINTAININDEX
![Page 203: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/203.jpg)
203 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
ProactivePerformanceandTuning
§ StayCurrentonGENLEVEL– Maintenancelevel:
§ AggregateMaintenance(endedDecember2013)§ CARecommendedServices(CARS)
§ UtilizeCASupportOnline– CheckCAIDMSProductPage– Keywordsearcheswith‘PERFORMANCE’‘CPU‘‘STORAGE’and
operatingsystemidslike‘MVS’‘OS’‘z/OS’‘VSE’‘z/VSE’
![Page 204: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/204.jpg)
204 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
ProactivePerformanceandTuning
§ PeriodicMonitoringandTuningCheckups
§ NewHardware/OpSysexploitation
![Page 205: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/205.jpg)
205 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSOptionalProductPerformanceConsiderations
§ CAIDMS-DC
§ CAIDMSSQLOPTION
§ CAIDMSServer
![Page 206: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/206.jpg)
206 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMS/DCPerformanceConsiderations
§ VTAM-typelinesbestoptionsare:– Compacting– PermanentReadBuffers– ExceptionProtocol– RPLCOUNT=20%ofphysicalterminals+1perprinter
![Page 207: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/207.jpg)
207 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSSQLOptionPerformanceConsiderations
§ Singledatabasestrategy
§ Optimizer
§ NON-SQLaccess
§ EXPLAINfacility
§ UPDATESTATISTICS
![Page 208: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/208.jpg)
208 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CAIDMSServerPerformanceConsiderations
§ ODBC/JDBCAPI
§ TCP/IPVersusCAICCI
§ IDMS/Serverr17providesODBCWireprotocolforODBC-typeConnections(ImprovedPerformance)
![Page 209: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/209.jpg)
209 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
ReferenceMaterials(allfromRelease18.5.00,exceptwhenmentionedotherwise)
§ CAIDMSDatabaseDesignGuide
§ CAIDMSDatabaseAdministrationGuide
§ CAIDMSBestPracticesGuide
§ CAIDMSSystemOperationsGuide
§ CAIDMSSystemGenerationGuide
§ CAIDMSUtilitiesGuide
![Page 210: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/210.jpg)
210 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
ReferenceMaterials(allfromRelease18.5.00,exceptwhenmentionedotherwise)
§ CAIDMSServerr17UserGuide
§ CAIDMSVisualDBAVersion18.0.00UserGuide
§ CAIDMSPerformanceMonitorAdministrationGuide
§ CAIDMSPerformanceMonitorUserGuide
![Page 211: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/211.jpg)
211 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CourseSummary
§ Youshouldnowbeableto:– IdentifythecomponentswithinanIDMSCentralVersion– Dealwithperformanceissues– Identifytheavailabletoolsformonitoringandtuning– Identifypotentialscarceresources– Establishmonitoringprocedures– Takecorrectiveactions
![Page 212: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/212.jpg)
@CAWORLD#CAWORLD ©2016CA.AllRIGHTSRESERVED.212 @CAWORLD#CAWORLD ©2016CA.AllRIGHTSRESERVED.212
MainframeandWorkloadAutomation
FormoreinformationonMainframeandWorkloadAutomation,pleasevisit:http://cainc.to/9GQ2JI
![Page 213: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/213.jpg)
213 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
RecommendedSessionsSESSION# TITLE DATE/TIME
MFX100S StrategyandVisionforCAIDMS 11/16/2016at12:45pm
MFX101S LegacyisnotaDirtyWord 11/16/2016at1:45pm
MFX102S CAIDMS19.0WebServicesforModernization 11/16/2016at3:00pm
MFX103S CAIDMS19.0SQLEnhancementsforModernization 11/16/2016at3:30pm
MFX104S JavaAccesstoCA-IDMSDataatBT(BritishTelecom) 11/16/2016at4:45pm
MFX105SImplementationandUseofGenericVTAMResourceswithParallelSYSPLEXFeatures(CA andCAXIA)
11/17/2016at12:45pm
MFX106S CAIDMSBufferTuning 11/17/2016at1:45pm
MFX107S M3AServicesMonitor,Measure,ManageandAlert 11/17/2016at3:00pm
MFX108S BirdsofaFeather/StumptheTechie! 11/17/2016at3:45pm
![Page 214: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/214.jpg)
214 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
MustSeeDemos
DemoNameProductXTheater#location
DemoNameServicesYTheater#location
DemoNameSolutionYTheater#location
DemoNameProductXTheater#location
![Page 215: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/215.jpg)
215 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
Questions?
![Page 216: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/216.jpg)
216 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
Thankyou.
Stayconnectedatcommunities.ca.com
![Page 217: CA IDMS Performance and Tuning](https://reader034.vdocuments.us/reader034/viewer/2022042504/58ef2a2c1a28abaf4e8b4669/html5/thumbnails/217.jpg)
217 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
©2016CA.Allrightsreserved.Alltrademarksreferencedhereinbelongtotheirrespectivecompanies.
Thecontentprovidedinthis CAWorld2016presentationisintendedforinformationalpurposesonlyanddoesnotformanytypeofwarranty. The informationprovidedbyaCApartnerand/orCAcustomerhasnotbeenreviewedforaccuracybyCA.
ForInformationalPurposesOnlyTermsofthisPresentation