Search for tag: "course"

Unit 15 Section 5: Annotated VSAM Print of the Primary Index Database (HIDAM), Part 3

This video describes the beginning of the PRINT of the first DATA-containing CI.

From  5500031CVP 5500031CVP

Unit 15 Section 4: Annotated VSAM Print of the Primary Index Database (HIDAM), Part 2

This video describes the second CI of the ESDS main database data set.

From  5500031CVP 5500031CVP

Unit 15 Section 3: Annotated VSAM Print of the Primary Index Database (HIDAM), Part 1

This video describes the items in the first page of a VSAM PRINT for the database data set that corresponds to the first CI of the HIDAM primary index which is a VSAM KSDS data set.

From  5500031CVP 5500031CVP

Unit 15 Section 2: CI and Block Sizes and HIDAM Space Usage

This video some items that should help you VSAM PRINTs, by providing a hexadecimal to decimal conversion table, VSAM’s numbering system, and how to find answers about HIDAM space usage.

From  5500031CVP 5500031CVP

Unit 15 Section 1: Segment Format

This video describes the sequence in which various pointer types exist in the prefix of IMS segments.

From  5500031CVP 5500031CVP

Unit 14 Section 6: Changes to Database Hierarchic Structure

This video describes how changes to the database hierarchic structure will require some database tool (such as IBM’s IMS Tools DB Segment Restructure), or a combination of standard utilities…

From  5500031CVP 5500031CVP

Unit 14 Section 5: Database Segment Changes

This video describes the impacts of changing database segments. Existing application programs need not be affected by adding new segments. Existing programs can process without even being aware that…

From  5500031CVP 5500031CVP

Unit 14 Section 4: Impacts of Database Changes

This video describes the impacts of making database changes, including what actions have no or little impact on application processing.

From  5500031CVP 5500031CVP

Unit 14 Section 3: Database Design Considerations for Pointers

This video describes the following design considerations:Why you should validate your database design with some performance measurements Why you never specify a pointer that will never be used but…

From  5500031CVP 5500031CVP

Unit 14 Section 2: Sequence Fields

The root segments of all database types, except for HDAM, require that a unique sequence field be defined. If no sequence field is defined for other (that is, non-root) segment types, IMS relies on…

From  5500031CVP 5500031CVP

Unit 14 Section 1: Pointer Selection

This video describes physical child pointers, physical twin pointers, and secondary index pointers.

From  5500031CVP 5500031CVP

Unit 13 Section 16: Lab 4: Database Recovery, Part 2

This lab demo continues the discussion of IMS database backup and recovery utilities.

From  5500031CVP 5500031CVP

Unit 13 Section 15: Lab 4: Database Recovery, Part 1

This lab demo shows you how to: Use the Database Image Copy utility and prepare JCL and utility control statements to run it Use the DB Change Accumulation utility and prepare the JCL and utility…

From  5500031CVP 5500031CVP

Unit 13 Section14: DBRC and the Recovery Control Utility

This video describes the JCL used to start the Recovery Control utility and Database Recovery Control (DBRC), which does two main tasks:Maintains an inventory of the status of system logs (e.g. OLDS,…

From  5500031CVP 5500031CVP

Unit 13 Section 13: Database Backout Utility

The Database Backout utility does this tasks:Removes database changes made during the execution of a DLI or DBB region Should also be used to backout database changes made by a BMP or MPP region…

From  5500031CVP 5500031CVP

Unit 13 Section 12: Recovery Considerations

This video describes various recovery considerations such as:What frequency of image copy and change accumulation depends on. An image copy should be taken after a reorganization, database load, or…

From  5500031CVP 5500031CVP