3248 - 好事会降临到那些优化自身的人身上.pdf

1、Orlando,FLOctober 69IBM TechXchange 2025Session:3248Good Things Come to Those Who OptimizeChad ReiberBMC SoftwareTransforming Mainframe Performance:“Good Things Come to Those who Optimize”Agenda01020304Supercharge Data Access and PerformanceTackle Poorly Performing SQLStreamline OperationsMaximize C

2、ost EfficiencyIBM TechXchange|2025 IBM CorporationWe are talking Db2 Optimize=OptimizerDynamic/Static SQLWhat Has been Chosen?Access Path Retrieve/Update Db2Explain DataInfluence the Optimizer?SQL StatementStatsSchema StructureOptimization HintsPlan ManagementIBM AI for Db2IBM Db2 OptimizerWhat are

3、the steps to optimize the optimizerHistorical TrendsWhatsRunningAlertingCorrectionProductionSaving ResourcesBetter End UXQADevCodingDeployTestingSQLSQLGate 1Best to start with Determining the Access PathDynamic/Static SQLWhat Has been Chosen?Access Path Retrieve/Update Db2Explain DataInfluence the O

4、ptimizer?SQL StatementStatsSchema StructureOptimization HintsPlan ManagementIBM AI for Db2IBM Db2 OptimizerHow are Db2 Access Paths Determined and used?IBM Db2 OptimizerProgramsStored ProceduresSQL StatementStaticDynamic SQLStaticDynamic SQLDynamic SQLBIND CommandDb2CREATEEXECSQLIBM Db2 Catalog/DirD

5、b2 Dynamic StmtCacheCACHEDYN=YES|NOExecuteExplain data goes to Plan Tables Db2 will create Plan Tables Stored ProcedureDb2 will Populate Plan Table with Access Paths Static SQL StatementsStatic SQL StatementsEXPLAIN(bind EXPLAIN(bind option)option)EXPLAIN(NO)EXPLAIN(NO)EXPLAIN(YES)EXPLAIN(YES)EXPLAI

6、N(ONLY)EXPLAIN(ONLY)EXPLAIN EXPLAIN PACKAGEPACKAGECOPY(CURRENT)COPY(CURRENT)COPY(PREVIOUS)COPY(PREVIOUS)COPY(ORIGINAL)COPY(ORIGINAL)Dynamic SQL StatementsDynamic SQL StatementsEXPLAIN EXPLAIN MODE MODE(register)(register)EXPLAIN MODE NOEXPLAIN MODE NOEXPLAIN MODE YESEXPLAIN MODE YESEXPLAIN MODE EXPL