how to get the most out of your db2 and analytics investment · how to get the most out of your db2...
TRANSCRIPT
![Page 1: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/1.jpg)
World®’16
HowtoGettheMostoutofYourDB2andAnalyticsInvestmentRonColmone @RonColmoneCATechnologies #CAWorldSr ConsultingArchitect
MFX81E
MAINFRAMEANDWORKLOADAUTOMATION
![Page 2: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/2.jpg)
2 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
Abstract
ThissessionwillfocusonanewmainframeDB2®toolscustomeroranon-DB2customer
interestedinDB2solutionsfromCATechnologiesandhelpingthemunderstandthevalue
propositionandthereal-lifeusecases(administration,changemanagement,performance
optimization,monitoring,etc.)whereDB2toolshelpcustomersreduceoperationalcosts,reduce
risksassociatedwithdowntime/availability,improveservicelevelsandimproveuser
productivity.
RonColmone
CATechnologiesSr ConsultingArchitect
![Page 3: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/3.jpg)
3 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
AgendaCLONINGUSINGCARC/MIGRATOR™FORDB2FORZ/OS
DB2REALTIMESTATS(RTS)FORAUTOMATION
TIPSANDHINTSWITHTHETOOLS
PACKAGECOMPAREINTEGRATIONWITHCHANGECONTROL
DETECTORCOLLECTIONANDREPORTINGPROFILES
MANAGEDB2ANALYTICSACCELERATOR(IDAA)
1
2
3
4
6
7
CARC/QUERY®FORDB2FORZ/OSHDDLLINE COMMAND5
![Page 4: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/4.jpg)
4 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
UseCase:CloningusingRC/Migrator(Merger)
![Page 5: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/5.jpg)
5 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CARC/Migrator(Merger)
§ MoveorCopyTable/IndexSpacesfromoneSubsystemtoanother(couldbesameSSID)
§ SharedDASDrequiredbetweensubsystems
§ Norequirementtounloadandreloadtables
§ CopytheVSAMdatasetsfromsourcesubsystemtotargetincludingcatalogstatistics
§ Flashcopy supportedtoeliminateoutageonsourcesystem
§ OBIDscanbereservedortranslatedinplaceontargetsystem
CloningDatausingCARC/Migrator– MStrategy
![Page 6: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/6.jpg)
6 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CARC/Migrator(Merger)
§ CustomerinitiallyusedUnload/LoadMigrationprocesstomovedatafromProductiontoTest
§ SecondphasewastoremoveunnecessaryIndexesfromthemoveprocess
§ ThenconvertedMigrationstrategytouseRC/Merger– largereductioninprocessingtime
§ ImplementedFlashCopy Support(RC/MergerR19feature)
Customercasestudy
![Page 7: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/7.jpg)
7 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CARC/Migrator(Merger)CustomerstatisticsmovingfromstandardUnload/LoadmethodtoRC/Merger
Note:Cloningprocessisnowhandling2-3x
thedataoriginallyprocessed
UsingUnload/LoadProcessing
Removedsomeunnecessaryindexes
ConvertedtoRC/Mergerprocess
ImplementedSNAPSHOTwithRC/Merger
![Page 8: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/8.jpg)
8 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CARC/Migrator(Merger)CloningDatausingCARC/Migrator– MStrategy
SpecifyRC/MergerMove/CopyAnalysisStrategyOptions.
ReserveOBIDS=YwillremoveneedtotranslateOBIDsunlesscollision.
SourceExecutionofReadOnlyensuresconsistentcopy.
![Page 9: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/9.jpg)
9 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CARC/Migrator(Merger)CloningDatausingCARC/Migrator– MStrategy
GlobalChangesallowobjectattributestobealteredontargetsystem.
CopySourceTablespaces toTargetTablespaces.
![Page 10: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/10.jpg)
10 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CARC/Migrator(Merger)CloningDatausingCARC/Migrator– MStrategy
RC/MergerwillallocateTargetVSAMdatasetsifrequired.
![Page 11: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/11.jpg)
11 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CARC/Migrator(Merger)CloningDatausingCARC/Migrator– MStrategy
CallRC/MergertoReserveOBIDsifavailable.
![Page 12: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/12.jpg)
12 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
UseCase:DB2RealTimeStatistics(RTS)forAutomation
![Page 13: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/13.jpg)
13 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DB2RealTimeStatsforAutomationDatabaseAnalyzer– ObjectSelectionusingRTS
§ DB2ObjectselectionbasedonRTSusingReorgbestpracticeselectioncriteria(DSNACCOXlike)
![Page 14: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/14.jpg)
14 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DB2RealTimeStatsforAutomationDatabaseAnalyzer– ObjectSelectionusingRTS
§ ExecutionofPDAExtractProceduretogenerateOnlineReorgsJOBsforselectedTablespacestiedtoObjectSelectionProfile
![Page 15: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/15.jpg)
15 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DB2RealTimeStatsforAutomationDatabaseAnalyzer– ObjectSelectionusingRTS
§ OnlineReorgJCLgeneratedintotargetlibraryforeachobjectselectedbasedonbestpracticeselectioncriteria.
![Page 16: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/16.jpg)
16 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
UseCase:PackageCompareIntegrationWithChangeControl
![Page 17: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/17.jpg)
17 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
PPAPackageCompareIntegrationWithChangeControlIdentifyingAccessPathChanges
![Page 18: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/18.jpg)
18 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
PPAPackageCompareIntegrationWithChangeControl
§ AddBatchProcessstepstoChangeControlprocessinordertodetectSQLperformanceimpactduetoSQLchanges
§ CurrentExplainofPackagecanbeusedtocreatetheBaseline
§ FutureExplainwithComparisontoCurrentExplaintodetectimpactofSQLchanges
§ OptionscanbespecifiedtosetThresholdvalueoncostcomparison
CostCompareanalysis
![Page 19: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/19.jpg)
19 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
PPAPackageCompareIntegrationWithChangeControl
CVCCOPTScontainsoptionsforCostComparereportincludingthresholds.
AddJCLsteptoChangeControlProcesstoComparebaselinetofutureexplaininordertoanalyzeaccesspathchangesofpackage.
![Page 20: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/20.jpg)
20 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
PPAPackageCompareIntegrationWithChangeControl
PackagecompareofOldversusNewpackagecompareresultedin26improvedSQLstatements.
![Page 21: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/21.jpg)
21 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
PPAPackageCompareIntegrationWithChangeControl
CostofSQLstatementwentfrom60to1(ms)sinceAccesstypechangedfromTS_SCNtoIXDATA.
![Page 22: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/22.jpg)
22 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
PPA– NewR19FeaturetoSimplifyCompareProcess
§ RebindCompareAnalysis(RCA)commandtosimplifycomparecurrent/futureaccesspathsforapackage
§ IssuesCurrentExplainofPackage,followedbyFutureExplain
§ ComparesFuturetoCurrentexplainresultsandgeneratestheRebindCompareAnalysisreport
§ ShowonlySQLstatementswhereaccesspathhaschanged
§ RCAcanbeissuedfrommostreportswhereaPackagelineexists
RebindCompareAnalysisReport
![Page 23: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/23.jpg)
23 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
PPARebindCompareAnalysis(RCA)
RCALinecommandcanbeexecutedonmostreportscontainingaPackagedetailline.Current/FutureexplainsfollowingbyComparewithRebindAnalysisReportforSQLwithAccessPathchanges.
![Page 24: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/24.jpg)
24 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
PPARebindCompareAnalysis(RCA)
RebindCompareAnalysisreportshowsacostimprovementfrom44to1(ms)whenrebindingpackageonDB2V10duetoColFnE=R(ColumnFunctionevaluatedatdataretrieval)
![Page 25: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/25.jpg)
25 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
UseCase:DetectorReportingandCollectionProfileUsage
![Page 26: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/26.jpg)
26 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DetectorReportingandCollectionProfileUsageDefineapplicationgroupsusingreportingprofiles
ApplicationprofilescanbedefinedforcollectionsofPLANs,Packages,CorrID,andUserswhichmakeupanapplication.
Inthisexample,RTPPLNMNandRTPREGarethecollectionofPLANnamesthatarespecifiedintheprofilethatmakeoftheApplicationRTPAPPL.
![Page 27: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/27.jpg)
27 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DetectorReportingProfileUsageViewingDB2activitybyApplicationReportingProfile
ViewBy‘Prof’(optionF)providesanaggregateviewofallactivityfortheselectedintervalsbyallPLANsdefinedinthespecificapplicationprofiles.
Inthisexample,RTPAPPListheapplicationIDassociatedwiththeapplicationprofilethataggregatesthecollectionofPLANSthatmakeuptheapplication.Allotheractivityintheintervalisrepresentedby‘*NoProfile*’.
![Page 28: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/28.jpg)
28 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DetectorReportingProfileUsageDrilldownintoactivitywithintheselectedApplication
Byselectinganapplicationprofilewithan“S”linecommandontheViewByProfiledisplay,activitycanthenbedisplayedforeachPLAN(orprofiletype)individuallywithintheApplication.
FurtherDrilldowntoPrograms,DynamicSQL,orotherKeyscanthenbeselected.
![Page 29: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/29.jpg)
29 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
UseCase:CARC/QueryHDDLLineCommand
![Page 30: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/30.jpg)
30 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
CARC/QueryHDDLLineCommand
§ HDDLLinecommandonaDB2objectwillgenerateDDLfortheobjectalongwithitsParentandDependentObjects.
GenerateDDLforspecifiedobjectalongwithParentandDependentObjects
![Page 31: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/31.jpg)
31 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
UseCase:ManageDB2AnalyticsAccelerator
![Page 32: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/32.jpg)
32 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
ManageDB2AnalyticsAcceleratorUseCARC/QueryforIDAAadministration
AbilitytoStart/Stop/DisplayandPINGAcceleratorfromRC/QAcceleratorList
![Page 33: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/33.jpg)
33 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
ManageDB2AnalyticsAcceleratorUseCARC/QueryforIDAAadministration
RC/QAcceleratorTablelistreportprovidestableleveladministrationofyourIDAA
![Page 34: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/34.jpg)
34 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
ManageDB2AnalyticsAcceleratorUseCARC/QueryforIDAAadministration
IDAATablelevelfunctionsareavailabletoDefine,Alter,Remove,Load,etc.
![Page 35: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/35.jpg)
35 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
ManageDB2AnalyticsAcceleratorUseCARC/QueryforIDAAadministration
§ LoadDB2TableintoIDAA– RC/QALOADCommand
– CanloadrangeofpartitionsorentireTable
– UsesIDAALoaderutility
– MostcommandssuchasALOADareavailableusingBatchProcessorScripts
![Page 36: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/36.jpg)
36 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DB2AnalyticsAcceleratorCASYSVIEW®PerformanceManagementforDB2
§ Subsystemstatistics:AcceleratorDetails– SYSACDTL:
AcceleratorDetails– HSACCDTL/
HSUACDTL:AcceleratorServerDetails/Summary
![Page 37: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/37.jpg)
37 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
TipsandHintsWithDB2Tools
![Page 38: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/38.jpg)
38 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DB2Tools
§ “?”– PrimaryandLinecommands
§ Freeze/Unfreeze/Reportcommands
§ QFILEandQPRINTcommands
§ ALLprimarycommandinCARC/Query
§ EQF– ExtendedQueryFacility– TheSQLLinecommand
§ RC/QueryUserDefinedLinecommands
Tips,HintsandUsefulstuff
![Page 39: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/39.jpg)
39 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DB2Tools– TipsUsingtheISPFInterfaceUseof“?”foravailablePanelandLineCommands
Enter“?”inPrimaryorLinecommandfieldtogetalistofavailable
commands
![Page 40: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/40.jpg)
40 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DB2Tools– TipsUsingtheISPFInterfaceFreeze,UnfreezeandReportCommands
§ CreateCustomizableReportformatsusingtheReportCommand
§ Freeze/Unfreezecommandsallowforfixingcolumnstoscrollleft/right
§ QPRINT/QFILEcommandstoprint/savereport
![Page 41: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/41.jpg)
41 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DB2Tools– TipsUsingtheISPFInterfaceALLPrimarycommandinCARC/Query
The“ALL”primarycommandwillpopulateallobjectrowswiththeassociatedLinecommandtoenableaquickmethodofexecutingaspecificcommandforallobject.Linecommandoptionscanthenbeappliedtoallobjects.
![Page 42: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/42.jpg)
42 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DB2Tools– TipsUsingtheISPFInterfaceEQF– ExtendedQueryFacility
Anyscreenthatcontainsa‘Where=>’fieldcaninvoketheEQFSQLQueryEditor.
Y– CreateorUpdateEQFN– Don’tinvokeEQFS– ExecuteExtendedQuery
![Page 43: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/43.jpg)
43 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DB2Tools– TipsUsingtheISPFInterfaceEQF– ExtendedQueryFacility
AdditionalPredicatevaluesandORDERBYcolumnscanbeaddedtothebasequerybeingexecutedwithintheDB2Toolsinterface.
![Page 44: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/44.jpg)
44 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DB2Tools– TipsUsingtheISPFInterfaceCARC/Query– UserDefinedcommands
§ UserdefinedRC/QuerycommandsaredefinedviaUSALINEandidentifytheObjecttypetheyareavailabletobeusedon.
§ UsercommandscanbewritteninREXXorasacompiledprogramandLINKEDintothePTLLINELoadModule
USMLINE1 'USER-DEFINED LINE COMMANDS' USMLINE2 LISTCAT,(TS,IX,T,I), *
'IDCAMS Listcat of tablespace/indexspace' USMLINE2 FLDSTAT,(C), *
'Most frequent index column values' USMLINE2 EX,(T,V,C,S,U,P,I,A,VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI, *
CD,SQ,H,U,SY,L,SC,TG,AC,PM), *'Execute Clist or REXX Exec '
USMLINE2 TESTEX1,(T,V,C,S,U,P,I,A,VC,DT), *'SAMPLE REXX EXEC ',TYPE=R
![Page 45: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/45.jpg)
45 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
DB2Tools– TipsUsingtheISPFInterfaceCARC/Query– UserDefinedcommands
AvailableUserdefinedcommandsforspecifiedDB2ObjectTypearelistedinthePanelwhenenteringa‘?’Linecommand.
CommandcanbeSelectedorenteredasLinecommand.
SampleREXXcommandisprovidedasexample.
![Page 46: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/46.jpg)
46 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
ParticipateinCA’sDB2/IMSManagementCommunity!!communities.ca.com/community/ca-database-management-for-db2-and-ims
![Page 47: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/47.jpg)
@CAWORLD#CAWORLD ©2016CA.AllRIGHTSRESERVED.47 @CAWORLD#CAWORLD
MainframeandWorkloadAutomation
FormoreinformationonMainframeandWorkloadAutomation,pleasevisit:http://cainc.to/9GQ2JI
![Page 48: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/48.jpg)
48 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
RecommendedSessionsSESSION# TITLE DATE/TIME
MFX79E ProtectingandTappingIntoyourDataGoldmine:leveragingwhatresidesinyourmainframe 11/15/2016at9:00am
MFX80EIntelligentMainframeManagement- DataDrivenDatabase PerformanceManagement 11/15/2016at10:00am
MFX81EHowtoGettheMostoutofYourDB2,DB2Management,andAnalyticsInvestment 11/15/2016at11:00am
MFX88S StrategyandVisionforCADB2DatabaseManagement 11/17/2016at12:45pm
MFX90S DrivingDownCostsforDB2Management 11/17/2016at1:45pm
MFX91S BirdsofaFeather/StumptheTechieforCADB2Tools! 11/17/2016at3:00pm
![Page 49: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/49.jpg)
49 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
MustSeeDemos
DemoNameProductXTheater#location
DemoNameServicesYTheater#location
DemoNameSolutionYTheater#location
DemoNameProductXTheater#location
![Page 50: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/50.jpg)
50 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
Questions?
![Page 51: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/51.jpg)
51 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
Thankyou.
Stayconnectedatcommunities.ca.com
![Page 52: How to Get the Most Out of Your DB2 and Analytics Investment · How to Get the Most out of Your DB2 and Analytics Investment ... standard Unload/Load method to RC ... VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI,](https://reader033.vdocuments.us/reader033/viewer/2022051602/5aec48217f8b9a66258e614c/html5/thumbnails/52.jpg)
52 ©2016CA.ALLRIGHTSRESERVED.@CAWORLD#CAWORLD
©2016CA.Allrightsreserved.Alltrademarksreferencedhereinbelongtotheirrespectivecompanies.
Thecontentprovidedinthis CAWorld2016presentationisintendedforinformationalpurposesonlyanddoesnotformanytypeofwarranty. The informationprovidedbyaCApartnerand/orCAcustomerhasnotbeenreviewedforaccuracybyCA.
ForInformationalPurposesOnlyTermsofthisPresentation