Search for tag: "performance"

Unit 12, Section 2: Database Variables, Monitoring Trends, and IWAITs

This video summarizes some of the database variables that you can use to improve the performance of your database system. This video also describes monitoring trends, and general rules for monitoring…

From  5500031CVP 5500031CVP

Unit 12, Section 1: Performance Evaluation Steps

This video outlines the steps you should take to create reasonable metrics for performance objectives, monitoring your database system, and taking corrective action to meet your objectives.

From  5500031CVP 5500031CVP

Unit 11, Section 7: Storage Controllers and DASD Activity

This video describes considerations for caching database reads and monitoring DASD activity.

From  5500031CVP 5500031CVP

Unit 11, Section 6: Logging Considerations

This video describes suggestions for minimizing the delays to IMS that are the result of the log writes.

From  5500031CVP 5500031CVP

Unit 11, Section 5: High Performance (HP) Unload and Load Tools

This video describes the HP Unload and Load tools. HP Unload is a tool that is available from IBM. One of its functions is high speed sequential retrieve (HSSR), which is useful when performing…

From  5500031CVP 5500031CVP

Unit 11, Section 4: DL/I Call Image Trace

This video describes DL/I call image trace (DLITRACE), which is is an option that is part of IMS and is especially useful for diagnostic purposes or to establish a regression test baseline.

From  5500031CVP 5500031CVP

Unit 11, Section 3: Programming Considerations for Database Performance

This video describes programming suggestions to reduce the number of DLI calls, the number of IWAITs, and lock conflicts.

From  5500031CVP 5500031CVP

Unit 11, Section 2: Segment Compression in Block-Level Data Sharing

This video illustrates possible consequences of using segment compression in an IMS block-level data sharing environment.

From  5500031CVP 5500031CVP

Unit 11, Section 1: Segment Edit/Compression

This video describes segment compression, which can reduce the disk space needed to store IMS data. With segment compression in use, each block or CI will, on average, store more segments.

From  5500031CVP 5500031CVP

Unit 10, Section 7: Lab 7: Last Chance and Tuning OSAM, Part 2

This lab demonstration continues the discussion of how you can implement OSAM data set and OSAM buffering, OSAM sequential buffering, and tune OSAM data sets and buffers.

From  5500031CVP 5500031CVP

Unit 10, Section 6: Lab 7: Last Chance and Tuning OSAM, Part 1

This lab demonstration shows you how to implement OSAM data set and OSAM buffering, including OSAM sequential buffering, and tune OSAM data sets and buffers.

From  5500031CVP 5500031CVP

Unit 10, Section 5: OSAM vs VSAM Comparison and Summary

This video compares OSAM and VSAM, what functions they can provide, and tips for using OSAM buffering.

From  5500031CVP 5500031CVP

Unit 10, Section 4: OSAM Sequential Buffering (OSB)

This video describes OSAM sequential buffering: how it works, how it is enabled, and how to read reports on buffering activity.

From  5500031CVP 5500031CVP

Unit 10, Section 3: OSAM Buffering

This video provides a review of OSAM buffering, subpool restrictions, buffer pool definition, and benefits of tuning OSAM buffer pools.

From  5500031CVP 5500031CVP

Unit 10, Section 2: OSAM Data Sets, Part 2

This video continues the discussion of OSAM data sets, specifically, HD database data set blocks, and advantages of using OSAM.

From  5500031CVP 5500031CVP

Unit 10, Section 1: OSAM Data Sets, Part 1

This video provides an overview of OSAM data sets, their characteristics, and data set organization.

From  5500031CVP 5500031CVP