What is 'performance'?; Performance objectives; Workload categories; Service Level Agreements; Performance factors; System parameters; EDM pool size; Buffer pool sizes; Bufferpool thresholds; Bufferpool development; Database design factors; Application design factors; Db2 traces.
Db2 TracesTrace types; Trace destination; Accounting trace classes; Audit trace classes; Statistics trace classes; Performance trace classes; Monitor trace classes; Global trace classes; IFCID types; Other trace options; Controlling traces.
Db2 Optimizer & Access Path SelectionDb2 optimiser; Access path selection; Access paths - index usage; Access paths - direct row access; Access paths - matching index access; Access paths - non-matching index access; Access paths - table(space) scan; Input to the optimiser; Filter factors; Filter factor and: clustering, column cardinality, column correlation, column distribution; Influencing the optimiser; Influencing the optimiser: manually adjusting statistics, using optimisation hints, modelling production values; Catalog statistics; Updating catalog statistics using RUNSTATS; Statistics columns; RUNSTATS examples.
Db2 EXPLAINEXPLAIN; PLAN_TABLE; DSN_STATEMNT_TABLE; DSN_FUNCTION_TABLE; EXPLAIN examples: Access paths, Multi-index access, Nested queries.
Database Design FactorsNormalisation forms; De-normalisation considerations; Table creation; Null attributes; Variable length columns; Column considerations; Constraint and domain management; Tablespace considerations; Space allocation and free space; Work file considerations; Data set placement; Index structure; Creating indexes; When and when not to index; Indexes and clustering; non-key columns in unique indexes; Composite keys; Reorganising indexes.
Application Design FactorsPredicates; Access paths; Indexable and non-indexable predicates; SQL statement processing; Stage 1 and stage 2 predicates; Summary of predicate processing; Predicate evaluation sequence; Sequential prefetch; List prefetch; Index lookaside; Joins; Join transformation; Join method; Subqueries; Non-correlated vs. correlated subqueries; UNION; Case expressions; Union and case performance; Table expressions; Temporary tables; Table comparisons.
Locking & ConcurrencyLocking overview; Reasons for locking; Lock compatibility - row and page locks; Lock compatibility - table and tablespace locks; Bind - ACQUIRE and RELEASE parameters; Bind - ISOLATION and CURRENTDATA parameters; Lock avoidance; Accessing currently committed data; Locking and concurrency recommendations.
Application Programs versus Db2 UtilitiesLoading data; Online LOAD; Deleting data; Unloading data using the REORG utility; Unloading data using the UNLOAD utility; UNLOAD utility restrictions; Dynamic SQL in utility statements.
Monitoring Application PerformanceMonitoring overview; Db2 Performance Expert; Db2PE reports and traces; accounting short report; accounting long report; time distribution reports; times, suspensions & highlights report; SQL activity report; dynamic SQL caching report; other processing activity report; locking activity report; parallelism report; buffer pool and group buffer pool activity reports; statistics long report.
Performance AnalysisEXPLAIN information; Db2PM reports; short accounting reports; long accounting reports; report usage summary; a general approach to problem analysis in Db2.
Experience live, interactive learning from the comfort of your home or office with Bilginç IT Academy's Online Instructor-Led Db2 for z/OS: Monitoring & Tuning Applications' Performance Training in Bahrain. Engage directly with expert trainers in a virtual environment that mirrors the energy and schedule of a physical classroom.
Immerse yourself in our most sought-after learning style for Db2 for z/OS: Monitoring & Tuning Applications' Performance Training in Bahrain. Our hand-picked classroom venues in Bahrain offer an invaluable human touch, providing a focused and interactive environment for professional growth.
Streamline your organization's training requirements with Bilginc IT Academy’s Onsite Db2 for z/OS: Monitoring & Tuning Applications' Performance Training in Bahrain. Experience expert-led learning at your own business premises, tailored to your corporate goals.
Join our public courses in our Bahrain facilities. Private class trainings will be organized at the location of your preference, according to your schedule.
Bahrain has positioned itself as the pioneering fintech and cloud capital of the Middle East, with Manama hosting the region’s first dedicated fintech hub, Bahrain FinTech Bay. As the first country in the region to adopt a 'Cloud First' policy, Bahrain has attracted global giants like AWS to establish massive data center infrastructures on its shores. The University of Bahrain and various national initiatives are focused on cultivating a workforce that is highly proficient in blockchain, open banking, and cybersecurity. Our IT education services in Bahrain are tailored to this innovation-driven market, offering advanced curriculum in Cloud Engineering, DevOps, and Information Security. We empower professionals in the Kingdom to take the lead in a digital-first economy that consistently sets the benchmark for regulatory technology and financial innovation across the Gulf.
