Search for tag: "database"

zDDL utility control options

This video describes how to use the following options: - SIMULATE- AUTOCOMMIT- VERBOSE- RSCLST and DDLTRACE DD cards

From  5500031CVP 5500031CVP

IMS Native z/OS DDL utility - an introduction

This video describes the zDDL utility and how you can submit DDL statements to an IMS database to create the necessary resources for that database, such as PSBs.

From  5500031CVP 5500031CVP

Get started on Amazon RDS for Db2 with an AWS Marketplace License

Watch how easy it is to get started with Db2 Standard Edition and Db2 Advanced Edition consumption-based subscriptions available in the AWS Marketplace, allowing customers to pay for Db2 licenses at…

From  chq_master_librarians

What is ETL

Wondering what ETL is all about? Jamil Spain explains what ETL is and what it can do for you to improve your data analysis and productivity.

From  chq_master_librarians

Use IMS Administration Foundation to view IMS database exceptions in a web browser interface

Learn how to use IMS Administration Foundation for z/OS, a Zowe-based web browser interface, to view your database exceptions and explore the historical metrics associated with those databases and…

From  1000003W0J 1000003W0J

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