Submitting DBD definitions to IMS systems that support DDL

If the IMS system that you are connected to supports DDL, you can submit new or changed definitions for IMS databases (DBDs) directly to IMS™ by using the Submit Changes to IMS option. IMS Explorer generates the necessary DDL CREATE or ALTER statements and sends them to IMS through the JDBC driver. To generate the DDL, IMS Explorer compares the resource in the local project with the resource in the IMS catalog.

Before you begin

The IMS system that you are connecting to must support DDL and the DDL support must be enabled. DDL is supported by IMS 14 and later systems that are configured to manage application control blocks (ACBs) in the IMS catalog. For more information about enabling support for DDL and the IMS management of ACBs in an IMS system that supports these functions, see IMS management of ACBs.

Before you submit changed database definitions to IMS, understand the impact of the changes you are making to the IMS database. Some database changes require you to unload and reload the database in the z/OS environment. For more information about changing record segments, see Modifying IMS databases

Add or edit the IMS database:

Procedure

  1. Submit the database changes to IMS by using one of the following methods:
    • From the Project Explorer view, right-click an updated DBD and select IMS Explorer > Submit Changes to IMS.
    • From the IMS DBD Editor or Import Data Structures Manager, right-click an updated DBD and select Submit Changes to IMS.
  2. In the Submit DBD Changes to IMS window, select the Profile for your Data Source Explorer connection. Before IMS Explorer sends the changes to IMS, the generated DDL is displayed so that you can check the DDL statements before you submit changes.

Results

After the changes are sent to IMS, IMS processes the submission and updates the IMS catalog. Certain changes might be activated in the IMS system immediately while others might be stored in the staging data set of the IMS catalog as an updated ACB for the database. If the database is referenced by program views or other databases, IMS might also include updated ACBs for these resources in the staging data set. While the updated ACBs remain in the staging data set, the database changes remain in a pending state in IMS until they are activated by the IMS command IMPORT DEFN SOURCE(CATALOG).

What to do next

Confirm that any additional necessary tasks in IMS that are associated with the type of change you are making are complete. For example, certain database or segment changes might require you to reorganize the database in the IMS environment.

To activate the pending database changes in IMS, issue the IMPORT command to load the updated ACBs into the online IMS™ system.




© Copyright IBM Corporation 2010, 2017.