Introduction › Using This Guide

Using This Guide

This guide contains all information necessary to define, load, and administer a CA IDMS database:

• Chapter 1—Describes who uses this guide and provides an overview of how the syntax is used.
• Chapter 2—Describes the CA IDMS environment.
• Chapter 3—Describes defining physical databases.
• Chapter 4—Describes defining segments, files, and areas.
• Chapter 5—Describes defining, generating, and punching a DMCL.
• Chapter 6—Discusses defining a database name table.
• Chapter 7—Discusses physical database DDL statements.
• Chapter 8—Describes defining a database using SQL.
• Chapter 9—Describes defining a database using non-SQL.
• Chapter 10—Describes using the schema and subschema compilers.
• Chapter 11—Discusses compiler-directive statements.
• Chapter 12—Discusses operations on entities.
• Chapter 13—Discusses parameter expansions.
• Chapter 14—Discusses schema statements.
• Chapter 15—Discusses subschema statements.
• Chapter 16—Discusses writing database procedures.
• Chapter 17—Discusses allocating and formatting files.
• Chapter 18—Discusses buffer management.
• Chapter 19—Discusses journaling procedures.
• Chapter 20—Discusses two-phase commit processing.
• Chapter 21—Discusses backup and recovery.
• Chapter 22—Describes loading a non-SQL defined database.
• Chapter 23—Describes loading an SQL-defined database.
• Chapter 24—Discusses monitoring and tuning database performance.
• Chapter 25—Describes dictionaries and runtime environments.
• Chapter 26—Discusses migrating from test to production.
• Chapter 27—Discusses modifying physical database definitions.
• Chapter 28—Discusses modifying database name tables.
• Chapter 29—Discusses modifying SQL-defined databases.
• Chapter 30—Describes modifying schema, view, and table definitions.
• Chapter 31—Discusses modifying indexes, CALC keys, and referential constraints.
• Chapter 32—Discusses modifying non-SQL defined databases.
• Chapter 33—Describes modifying schema entities.
• Chapter 34—Describes modifying subschema entities.
• Chapter 35—Describes space management.
• Chapter 36—Describes record storage and deletion.
• Chapter 37—Discusses chained set management.
• Chapter 38—Discusses index management.
• Chapter 39—Describes lock management.
• Appendix A—presents a sample physical database definition.
• Appendix B—presents a sample SQL database definition.
• Appendix C—presents a sample non-SQL database definition.
• Appendix D—Discusses native VSAM considerations.
• Appendix E—Discusses batch compiler execution JCL.
• Appendix F—Discusses system record types.
• Appendix G—Discusses procedures for coding a user-exit program.