Creating databases best practices

Although IMS DDL conforms with standard DDL syntax, it also extends the syntax with IMS specific keywords. You may choose to utilize these IMS keywords or allow IMS to take the default values for them as described in the IMS DDL syntax descriptions.

Ensure that you set-up the required infrastructure and connections to communicate with IMS via ODBM. You can use installation verification program (IVP) to do this for you.

Procedure

  1. Use IMS Enterprise Suite Explorer for Development to generate the DDL statements for program views which reference the database. At least one of the program views should be defined with PROCOPT L. For more information, see Generating DDL with IMS 14.
  2. Submit DDL statements, including a final COMMIT DDL statement. DDL changes are held in IMS in a pending state. For more information, see Submitting DBD field changes to IMS with IMS 14.
  3. Allocate your database data sets. For more information, see Allocating the indexed database data sets.
  4. Optional: Define DBRC definitions.
  5. Optional: For non-HALDB full-function DBs, define IMS database for dynamic allocation (MDA).
  6. Initialize the partitions. For example,
    • For Fast Path DBs, run DBFUMIN0, or
    • For full-function DBs, run DFSUPNT0 and/or Prereorg (DFSURPR0) utilities.
    For more information, see Initializing the partitions.
  7. Load IMS databases as needed. For example, HALDB and Fast Path might not need an initial load. However, full-function DBs require it. For more information, see Loading each database as a HALDB database, Loading Fast Path databases and Loading a DEDB.
  8. Establish database recovery point by taking an image copy (IC). For more information, see Image copy utilities (DFSUDMP0, DFSUDMT0, DFSUICP0).
  9. Define database and program online resource definitions:
    • If DRD is enabled, issue the CREATE DB / PGM command to create the database and program (DRD).
    • If DRD is not enabled, specify DATABASE and PROGRAM system definition macros.

    At this point, all of the above steps need to be completed, regardless of the order in which you choose to do them.

    For more information, see Modifying system resources online.
  10. Issue the IMPORT DEFN SOURCE(CATALOG) command to activate the database and program definitions. For more information, see IMPORT DEFN SOURCE(CATALOG) command.
  11. Start IMS resources - Databases, Programs, Transactions, Routing Codes.