using sysview to monitor and measure your ca datacom environment – ad and db

World®’16

KevinShuma,VPProductManagementCATechnologies

UsingCASYSVIEW®PerformanceManagementtoMonitorandMeasureYourCADatacom®Environment– ADandDB

MFX98S

MAINFRAMEANDWORKLOADAUTOMATION

2 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD

©2016CA.Allrightsreserved.Alltrademarksreferencedhereinbelongtotheirrespectivecompanies.

Thecontentprovidedinthis CAWorld2016presentationisintendedforinformationalpurposesonlyanddoesnotformanytypeofwarranty. The informationprovidedbyaCApartnerand/orCAcustomerhasnotbeenreviewedforaccuracybyCA.

ForInformationalPurposesOnlyTermsofthisPresentation


Abstract

ThissessionprovidesaninteractivedemonstrationofhowtouseCASYSVIEW®todiscoverCADatacom®environmentsanddrilldownforperformanceinformation,errordiagnosticsandmuchmore.

CASYSVIEW®PerformanceManagementisanintegralpartofperformancemanagementsolutionsfromCATechnologieswhichexposeawealthofperformanceinformationthatyoucanaccessthroughcustomizabledisplays.CASYSVIEW®PerformanceManagementCADatacom®OptionprovidesadirectperformancemanagementinterfacefortheCADatacom®/DBenvironment.

KevinShuma

CATechnologiesVP,ProductManagement


Agenda

THECASYSVIEWINTERFACE

DISCOVERINGCADATACOMENVIRONMENTS

NAVIGATINGTHROUGHTHEDATACOMMENU

USINGCASYSVIEWFORREALTIMEPROBLEMSOLVING

1

2

3

4

SUMMARY5


TheCASYSVIEWInterface

§ CADatacomdeliversacallableinterfacethatCASYSVIEWusestogatherCADatacominformation– Isolatestheuserfromreleaseinconsistencies

§ Removesconcernsoverhavingtoupgradeoneproducttomatchtheother§ NewdatacanbeexposedbyDatacomthatthenextreleaseofSysviewuses§ APIgathersinformationfrommultiplesources

CADatacomMUF

SysviewAPI DynamicSystemTables

Incorememory


TheCASYSVIEWInterface(Cont’d)ThePrimaryDatacomMenu


DiscoveringCADatacomEnvironmentsTheDCLISTCommand

UsestheSysviewAPIscapabilitiestodiscoveralltheDatacomEnvironmentsonagivenLPAR


DiscoveringCADatacomEnvironments(Cont’d)TheDCLISTCommand

• ListsallDatacom(MUF)addressspaces• Bothactiveandinactive

• IndicateswhetherADorDB• ShowsJob-CPU,storage,IOs,etc.



• Anyscreencanbesortedusingthesortcommand

• SortMUFsbyJob-CPUdescending



• SelectingaMUFtodrilldownfurther• ASIDcommand• Use“S”onCmdline• SelectedMUFwillgethighlighted• Anchoredforallother

commands


NavigatingThroughtheDatacomMenuTheMENUDATACOMCommand

• Primarycommands• Secondarymenus• Onlinereference

• Commands• Datadisplayed


NavigatingThroughtheDatacomMenu(Cont’d)TheDCTASKSCommand

DCTASKS• ProvidesarealtimelookinsideMUF• Mostuseddebuggingdisplay

Statusshowswhateachtaskisdoing• ACTIVEaretasksthatrunningonaCPU• READYTORUN– waitingforaCPU• WAITxxxx– Taskasleepwhilewaiting

onanotherfunctiontocomplete• NOTACTIVE– notcurrentlyprocessing

aDatacomcommand


NavigatingThroughtheDatacomMenu(Cont’d)TheDCMUFsCommand

DCMUFS• ProvidesSpecificinformationonthe

anchoredMUF• UsePF10/PF11togoleftandright


NavigatingThroughtheDatacomMenu(Cont’d)TheDCBASESCommand

DCDBASES• ListsalltheDatacombases• Placingan“S“inCMDwillswitchinto

areadisplay


NavigatingThroughtheDatacomMenu(Cont’d)TheDCAREASCommand

DCAREAS• ListsalltheDatacomareas• Placingan“S“inCMDwillswitchinto

tabledisplay• Fromtherewecancontinuethedrill

down• Columns• Keys• Elements


NavigatingThroughtheDatacomMenu(Cont’d)TheDCDIRSub-Menu

MenuDCDIR• ListsinfofromtheDirectory(CXX)• Databasemodel

• DCDBASES• DCAREAS(data)• DCINDEX(IXX)• DCTABLES• DCCOLUMNS• DCKEYS• DCKEYFLD• DCELEMEN• DCPARCOL

• DCDIR– listsinfoonthedirectory(CXX)itself


NavigatingThroughtheDatacomMenu(Cont’d)TheDCDIRSub-Menu- DCDSETS

DCDSETS• Listsdatasetinformationfortheareas

andindexes• Pullsselectedinformationfromthe

systemcatalog• Mayrunawhileifalotof

datasetsourqueried• Canbeusedtomonitorspace,

percentageofin-use,etc.


NavigatingThroughtheDatacomMenu(Cont’d)TheDCDIRSub-Menu- DCVOLUME

DCVOLUME• Listsvolumeinformationfortheareas

andindexes• Pullsselectedinformationfromthe

systemcatalog• Mayrunawhileifalotof

datasetsourqueried


NavigatingThroughtheDatacomMenu(Cont’d)TheDCDIRSub-Menu– CADatacomDirectoryDashboard

Directorydashboard(nodirectcommand)• SelectedinformationfromtheDCDIR• CombinedwithDCINDEXandDCDBASES

• Fordatabase1000(dynamicsystemtables)


NavigatingThroughtheDatacomMenu(Cont’d)TheDCMONSub-Menu

MenuDCMON• Variousperformanceandutilization

information• Databasemodel

• DCBUFFER• DCBUFP• DCCBS• DCLOG• DCRATES• DCREQS• DCSMP• DCSMPTSK• DCSYSTEM• DCTCBSRB• DCZIIP


NavigatingThroughtheDatacomMenu(Cont’d)TheDCMONSub-Menu– CADatacomMUFMonitoringDashboard

Monitoringdashboard• Combinesperformanceandutilization

informationfromseveraldisplays


NavigatingThroughtheDatacomMenu(Cont’d)OtherSubMenus

DCCDC– changedatacaptureDCDBASE– physicalandlogicalaccessinformation• Openareas,areaIOs• TablerequestsDCDEBUG– variousdisplaysshowingreturncodes,dumps,etc.DCOPT– variousdisplaysoncurrentlyexecutingMUFoptionsDCSQL- variousdisplaysonSQLactivitiesCSF– ifenabled,variousdisplaysonCICSServicefacilityusage


UsingCASYSVIEWforReal- TimeProblemSolvingOnlyReal-TimeTooltoLookInsideMUF

§ CASYSVIEWinterfaceallowsSYSVIEWto“see”insideMUFevenwhentheMUFishungorlooping

§ Noteverysituationwillbethesame,butthereareacoupleoffamiliaroccurrences

§ Wewillwalkthroughacoupleofscenarios


UsingCASYSVIEWforReal-TimeProblemSolvingMUFisLooping(HeavyCPUorIOConsumption)

§ IssueDCTASKSandlookatexecuting(ACTIVE)task– Hitenterdoesthetaskswitchoristhesametaskalwaysactive

§ Sametaskactive– couldmeanaloopingorrunawaytask– DoestheRSEQNUMchange

§ No– thenthetaskis“runningaway”inMUF

§ Yes– thentheapplicationisrunningaway– drivingMUF

§ DifferenttaskactivemeansMUFisprocessingasexpected– AretheRSEQNUMchanging

§ NO– thenseveralheavytasksinMUF

§ Yes– ThenthetasksaredrivingMUF


UsingCASYSVIEWforReal-TimeProblemSolvingMUFisLooping(HeavyCPUorIOConsumption)

Taskthatseemstoberunningaway


UsingCASYSVIEWforReal-TimeProblemSolvingMUFisLooping(HeavyCPUorIOConsumption)(Cont’d)

§ Possibleremediation– Researchloopingjobs,ifpermissible

§ Canceljob/CICStaskassociatedwithtaskinMUF§ UseREQABORTtocanceltaskinMUF

– WaitforafewminutesandrepeatDCTASKs


UsingCASYSVIEWforReal-TimeProblemSolvingMUFisHung– NothingisHappening

§ IssueDCTASKSandlookattaskdisplay– Hitenterdoesthetasklistchange

§ Ifnot,whatarethetaskswaitingon?– WaitLXX(istheLXXFULL)

– Waittask

§ Arethetaskshungupwaitingoneachother

– NOTACTIVE– MUFdoesn’tbelievethereisanyworktodo


UsingCASYSVIEWforReal-TimeProblemSolvingMUFisHung– NothingisHappening

Allmaintenancetasksare

waitingonLXX

SYSVIEW ISPF1 CA31 --------------------------- DCTASKS, CA Datacom MUF Active Tasks ----------------------------- 10/10/16 13:15:09Command ====> Scroll *===> PAGE--------------------------------------------------------------------------------------------------- Lvl 8 Row 1-18/41 Col 1-131/346Jobname DSNZMFX ASID 02E9 Jobid STC14266 Datacom 15.0 Mode REGION Group n/a -----------------------------------------------------------------------------------------------------------------------------------Cmd Jobname MUFName TaskJobn TaskNum Owner EXCPs RunUnit RSeqNum Command Status Duration Tran Term Opid CTask DBID Tbl___ . . QA#@EDS3 9 12 11607 840363 SELFR ACTIVE 3100 HST___ . . QA#@EOP1 13 3 11612 840282 GETIT READY TO RUN 352 HST___ . . QA#@EOP2 5 1 11613 840362 UPDAT WAIT I/O IXX 7:03 355 ACC___ . . QA#@EOP3 6 4 11614 839876 ADDIT WAIT I/O IXX 8:03 357 HST___ . . QA#@EOP4 7 4 11616 839876 UPDAT WAIT I/O IXX 6:21 357 GHT___ . . QA#@EOP5 8 4 11618 839876 DELET WAIT I/O IXX 5:08 359 BAS___ . . QA#@EOP6 1 4 11611 839876 ADDIT WAIT I/O IXX 7:32 357 HST

-----------------------------------------------------------------------------------------------------------------------------------1=HELP 2=SPLIT 3=RETURN 5=FIND 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RECALL


UsingCASYSVIEWforReal-TimeProblemSolvingThingsareRunningbutThereSeemstobealotMoreActivityThanUsual

§ IssueDCTASKSandlookattaskdisplay– Hitenterdoesthetasklistchange

§ Ifthingslookliketheyarerunningbuttheworkloadseemshigh– Startlookingatotherdisplays

§ DCRATES– istheMUFconsumingCPUandIO

§ DCAREAIO(sortL-Readsd)– arethereanysurprises,isoneareagettingalotofIO

§ DCTABREQ(sortrequestsd)– arethereanysurprises,isonetablegettingalotofrequests

§ DCRETCOD,DCSQLCOD– aretherealotoffailedrequestsgoingon


RecommendedApproach

Establishaperformancebaselinethatisusedtomeasureandtrackproductionenvironments.What’snormalforyoushop.

Monitor UseCASYSVIEWtoregularlymonitortheactivityinyourMUFs.GettoknowtheSysviewdisplaysaswellastheMUFprocessing.

Alert UseCASYSVIEWdisplaystodebugpossibledatabaseprocessingissuesinreal-time.

Measure


Summary

§ CASYSVIEWprovidesthebestreal-timeperformancemonitoringforaCADatacomenvironment.


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

MFX98SUsingCASYSVIEW®tomonitorandmeasureyourCADatacomenvironment– ADandDB

11/17/2016at3:00pm

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


Questions?


Stayconnectedatcommunities.ca.com

Thankyou.

using sysview to monitor and measure your ca datacom environment – ad and db

Technology