IBM Support

How to change DBDs and PSBs by using IBM IMS Administration Tool for z/OS

How To


Summary

IBM IMS Administration Tool for z/OS (IMS Administration Tool) is an IMS Tools product that provides a comprehensive set of functions and features to assist IMS database administrators with managing IMS environments.

The IMS resource change function of IMS Administration Tool is enhanced with APAR PH28185 (IMS resource change enhancement to use data set group and select tasks). When you change IMS resources (DBDs and PSBs) with the IMS Administration Tool ISPF interface, you can:

- Select which IMS resource change tasks to perform:
Changing DBDs and PSBs generally involves series of tasks including copybook import and running utilities such as DBDGEN, PSBGEN, ACBGEN, and IMS Catalog Populate (DFS3PU00) utility. Previously, users could not select the tasks to run, but after this enhancement, users can select the tasks to run.

- Select data sets from a data set group:
Previously, IMS Administration Tool selected input and output data sets for IMS resource change tasks. With this enhancement, users can predefine the data sets that they want to use. This new capability allows users to easily select data sets, helping users reduce specification errors and the time spent on selecting data sets.

Objective

This information is designed to provide steps on how to change DBDs and PSBs with the IMS resource change function by using the ISPF interface of IMS Administration Tool. It is targeted for the following users of IMS Administration Tool:

  • Change DBDs and PSBs with IMS Administration Tool for the first time.
  • Have been using "Discovered Data Sets" when changing DBDs and PSBs.
  • Learn about the enhancements made to the DBD and PSB change capability.

Steps in this information are based on the following scenario:

  • Import field definitions from a copybook to a DBD and perform DBDGEN to update the DBD. Also, perform PSBGEN to update the PSB.
  • Perform ACBGEN to update ACBs, and populate the IMS catalog with updated DBD, PSB, and ACBs.

Steps

Tasks 1 - 4 are preparation tasks. DBD and PSB change is done in Task 5.

Notes:

  • If you do not want to select data sets from a data set group but instead use "discovered data sets", you can omit tasks 1 and 2.
  • These tasks explain how to work on an IMS subsystem (IMSID). Data sets that you register and data set groups that you create will be associated with a specific IMSID and they cannot be shared across multiple IMSIDs.


Task 1. Register data sets and data set groups for DBD and PSB resource change

(Menu: 0 Setup and Administration > 4 Manage Data Sets and Groups)

In this task, you register the data sets that you want to use with DBD and PSB change to IMS Administration Tool. Data sets you can register include not only DBD and PSB source data sets but also DBD library data sets, PSB library data sets, ACB library data sets, and data sets related to copybooks. After you register data sets, you create a data set group and add the registered data sets to the data set group.

IMS Administration Tool manages data sets by the unit of data set group. For each data set group you create, you assign a unique ID. By selecting the data set group ID in a subsequent task, the data sets included in the selected data set group are enabled for DBD and PSB change.

There can be multiple data set groups, and a data set can be included in multiple data set groups. For example, you can create two data set groups; one for testing and another for development, and include data sets in both data set groups.

Registering data sets and data set groups can be accomplished with the following two subtasks:


Task 1-1. Register data sets
  1. From the IMS Administration Tool ISPF main menu, select 0 Setup and Administration and press Enter.
    Task 1-1-1. Main menu
  2. In the Setup and Administration panel, select 4 Manage Data Sets and Groups and press Enter.
    Task 1-1-2. Setup and Administration panel
  3. In the Manage Data Sets and Groups panel, enter the IMS subsystem ID (IMSID) that you want to work with. Then select 1 Data Set and press Enter.
    Task 1-1-3. Manage Data Sets and Groups panel
  4. The Manage Data Sets panel is displayed.
    Task 1-1-4. Manage Data Sets panel
    This panel displays all the data set types that can be registered for DBD and PSB change. For each data set type, the number of registered data sets is shown.

    Reference: The following types of data sets are used for DBD and PSB change tasks:

    • DBDGEN: 1. DBD statement source and 7. DBD libraries
    • PSBGEN: 2. PSB statement source and 8. PSB libraries
    • ACBGEN: 7. DBD libraries, 8. PSB libraries, and 9. ACB libraries
    • Copybook import: 3. COBOL copybook, 4. PL/I copybook, 5. Copybook cross reference, and optionally 6. DBD statements with copybook

    Tip: If you want to view the data sets that IMS Administration Tool identifies, specify Y for Confirm discovered data sets? and press Enter.

    In this scenario, you register at least one data set for each data set type, starting with DBD library data sets.

    Select 7. DBD libraries and press Enter.
    Task 1-1-4. Manage Data Sets panel

  5. A list of registered DBD library data sets is displayed. If no DBD library data sets are registered, the panel lists no data sets.
    Enter C (Create a new data set ID) and press Enter.
    Task 1-1-5. Manage Data Sets panel
  6. The Manage Data Sets - Add a data set panel is displayed. You use this panel to register a data set.
    Enter a DSN ID, data set name, and optionally a comment. Then press Enter.
    DSN ID must be unique within the selected IMS subsystem (IMSID).
    Task 1-1-6. Manage Data Sets - Add a data set panel
  7. In the Manage Data Sets panel, the DBD library data set you just registered is listed.
    Use a line command (U or D) if you want to update the data set information or unregister the data set.
    If you want to add another DBD library data set, repeat steps 5 and 6. Otherwise, press PF3.
    Task 1-1-7. Manage Data Sets panel
  8. In the Manage Data Sets panel, repeat steps 4 - 7 to register one or more data sets for each data set type.
    Task 1-1-8. Manage Data Sets panel
  9. When you have finished registering data sets of each data set type, press PF3 to return to the Manage Data Sets and Groups panel.


Task 1-2. Register a data set group
  1. In the Manage Data Sets and Groups panel, select 2 Data Set Group and press Enter.
    Task 1-2-1. Manage Data Sets and Groups panel
  2. The Manage Data Set Groups panel is displayed. This panel lists all the data set groups. If there are no data set groups, the panel lists no data set groups.
    Enter C (Create a new data set group) and press Enter.
    Task 1-2-2. Manage Data Set Groups panel
  3. This panel displays all the data set types related to DBD and PSB change.
    For each data set type, the number of data sets that belong to this data set group and the number of registered data sets are displayed.
    Enter a data set group ID (DS Group ID), default use value, and optionally a comment. Data set group ID must be unique within the selected IMS subsystem (IMSID).
    In this scenario, you add at least one data set for each data set type, starting with DBD library data sets.
    Select 7. DBD libraries and press Enter.
    Task 1-2-3. Manage Data Set Group panel
  4. This panel displays the registered data sets for the selected data set type.
    Select the data sets that you want to add to this data set group by entering numbers (1 - 99) in Seq fields. For example, if you want to add data sets DSNDBDL1 and DSNDBDL2, and you want to give DSNDBDL2 higher priority, you enter 1 for DSNDBDL2 and 2 for DSNDBDL1. After you enter a number beside each data set that you want to include in the data set group, press Enter. Then press PF3 to return to the previous panel.
    Task 1-2-4. Manage Data Set Group panel
  5. For each data set type, repeat steps 3 and 4. The panel for adding data sets is common across all data set types.
    Task 1-2-5. Manage Data Set Group panel
  6. In the Manage Data Set Groups panel, enter V (View data sets in the group) to view a list of data sets that are included in this data set group.
    Task 1-2-6. Manage Data Set Groups panel
  7. The View Data Set Group panel lists all the data sets, by data set type, that belong to this data set group.
    Task 1-2-7. View Data Set Group panel

You completed this task. You have successfully created a data set group.

Back to top


Task 2. Enable a data set group for DBD and PSB change tasks

(Menu: 1 Database and Application Administration > 0 Settings)

In this task, you select a data set group so that the data sets that belong to the data set group are enabled for DBD and PSB change tasks.

  1. From the IMS Administration Tool ISPF main menu, select 1 Database and Application Administration and press Enter.
    Task 2-1. Main menu
  2. In the Database and Application Administration panel, select the IMS subsystem ID that you want to work with.
    The Data Set Selection field displays the default data set selection method Discovered Data sets, which means a data set group is not selected.
    Select 0 Settings and press Enter.
    Task 2-2. Database and Application Administration panel
  3. In the Settings panel, select 1 Change Data Set Selection Method and press Enter.
    Task 2-3. Settings panel
  4. The Change Data Set Selection Method panel is displayed.
    In this panel, you select the data set selection method for DBD and PSB change tasks. In this scenario, you select 2. Data Set Group to enable the data set group that you created.
    Tips: Select 2. Data Set Group and press Enter.
    Task 2-4. Change Data Set Selection Method panel
  5. In the Select Data Set Group panel, enter S (Select to use the data set group) next to the data set group that you want to use and press Enter.
    Tip: If you want to view the data sets that belong to the data set group, enter V (View data sets in the group).
    Task 2-5. Select Data Set Group panel
  6. The Change Data Set Selection Method panel is displayed. This time the data set group that you selected is displayed in the Data Set Group field. Also, a message is displayed to inform you that the data set group is selected.
    Task 2-6. Change Data Set Selection Method panel

You completed this task. You have successfully changed the data set selection method.


Reference: Selecting Discovered Data Sets as the data set selection method

This reference section is not part of the scenario. It explains how to select Discovered Data Sets for the data set selection method.

  1. In the Change Data Set Selection Method panel, select 1. Discovered Data Sets and press Enter.
    Reference 2-1. Change Data Set Selection Method panel
  2. The Discovered Data Sets panel is displayed. This panel lists all the data sets (DBD, PSB, and ACB library data sets) that IMS Administration Tool identified for the selected IMSID.
    If the data sets that you want to use are listed in this panel, press Enter. IMS Administration Tool sets the data set selection method to Discovered Data Sets. Otherwise, press PF3 to exit the panel and return to the previous panel.
    Reference 2-2. Discovered Data Sets panel
  3. In the Change Data Set Selection Method panel, Selected is displayed next to 1. Discovered Data Sets. Also, a message is displayed to inform you that Discovered Data Sets is selected.
    Reference 2-3. Change Data Set Selection Method panel

Back to top


Task 3. Decode DBD and PSB that are stored in DBD and PSB libraries

(Menu: 0 Database and Application Administration > 1 Object Explorer)

In this task, you prepare DBD and PSB source code, which IMS Administration Tool requires to update DBDs and PSBs. If the DBDs and PSBs that you want to update are stored in the DBD library, PSB library, or ACB library, complete the following steps to decode DBDs and PSBs from binary format to readable format source code and store the source code in the DBD statement source data set and the PSB statement source data set.

If DBD and PSB source code is already stored in the DBD statement source data set and PSB statement source data set, you do not need to complete this task.

The decode function of IMS Administration Tool allows you to not only decode DBDs and PSBs but also edit the source code or model existing DBD or PSB source code to create new source code for DBD or PSB.

  1. From the IMS Administration Tool ISPF main menu, select 1 Database and Application Administration and press Enter.
    Task 3-1. Main menu
  2. In the Database and Application Administration panel, select 1 Object Explorer and press Enter.
    Task 3-2. Database and Application Administration panel
  3. The Select Resource Type pop-up menu is displayed.
    You can select either 1. Database (DBD) or 2. Application (PSB).
    In this scenario, select 1. Database (DBD) and press Enter. Subsequent panels are the same for both resources.
  4. The Object Explorer panel is displayed.
    In this panel, you specify the DBD member to decode.
    Decoded source code will be stored in the decoded source data set. Ensure that the correct data set is specified in the Decoded Source Data Set field. If a data set group is selected for the data set selection method, the Decoded Source Data Set field is populated with the DBD statement source data set that is found in the selected data set group.
    Task 3-4. Object Explorer panel
    In the From Library section, select the library in which the DBD that you want to decode is stored by entering the number that corresponds to the stored library. Also use the DBD Filter field to filter DBDs. Asterisk (*) is supported as a wildcard character.
    In this scenario, you enter 3 (DBD Library) for From Library, type IVP* in the DBD Filter field, and press Enter.
    Task 3-4. Object Explorer panel
  5. The Database DBD List panel is displayed.
    This panel lists all the DBDs that are identified from the conditions you specified in the previous panel.
    Enter one of the following line commands to specify how you want to decode the DBD:
    • A - Alter: Decodes the member and displays the decoded source code in edit mode. You can edit the decoded source code.
    • M - Model: Decodes the member, saves the source code in a different member (a pop-up is displayed to enter the new member name), and displays the decoded source code in edit mode. You can edit the decoded source code.
    • S - Source: Decodes the member and displays the decoded source code in view mode. You cannot edit the decoded source code.
    The decoded source code will be stored in the decoded source data set that you specified in the previous panel.
    In this scenario, enter S (Source) next to DBD IVPDB1 and press Enter.
    Task 3-5. Database DBD List panel
  6. Decoded source code is displayed in view mode.
    This member is now stored in the decoded source data set ATY.IFB8.DBDSRC.
    The decoded source code contains the following information in the JCL header:
    • Comment line that indicates the data set in which the DBD member is stored (DSNAME=data_set)
    • Comment line that indicates when the DBD was decoded (DECODE DATE mm/dd/yyyy TIME hh.mm.ss).
    Task 3-6. Decoded source code

You completed this task. You have successfully decoded a DBD and stored the decoded source code to the decoded source data set.

Back to top


Task 4. Register runtime options for DBDGEN and PSBGEN tasks

(Menu: 1 Database and Application Administration > 0 Settings)

In this task, you register, view, and update runtime options that are applied to DBDGEN and PSBGEN tasks.

The following runtime options can be registered for DBD and PSB change tasks:

  • IMS Macro Library
  • Assemble Option
  • COBOL Compiler
  • COBOL Compile Option
  • PL/I Compiler
  • Copybook Default Lang (Default is COBOL)
  • Copybook XREF Format (Default is TYPE1)

In this scenario, you register the IMS macro library, which is used for DBDGEN and PSBGEN tasks, and COBOL and PL/I compilers, which are used for copybook import. Other options (Assemble option, COBOL compile option, and copybook options) have system default values. If you want to change the default values, you can update them by following these steps.

For details about runtime options, view the help panel (PF1) or the IMS Administration Tool User's Guide.

  1. From the IMS Administration Tool ISPF main menu, select 1 Database and Application Administration and press Enter.
    Task 4-1. Main menu
  2. In the Database and Application Administration panel, select 0 Settings and press Enter.
    Task 4-2. Database and Application Administration panel
  3. The Settings panel is displayed. Select 2 View or Update Runtime Options and press Enter.
    Task 4-3. Settings panel
  4. The View/Update Runtime Options panel is displayed.
    There are two scopes for each option, IMS subsystem ID and system. You can set the runtime option for each scope.
    In this scenario, you register the IMS macro library, COBOL compiler, and PL/I compiler.
    Enter U (Update) next to IMS Macro Library (Scope IFB8) and press Enter.
    Task 4-4. View/Update runtime Options panel
  5. In the Update Runtime Option panel, enter the IMS macro library data set and press Enter.
    Task 4-5. Update Runtime Option panel
  6. Repeat steps 4 and 5 to register the COBOL compiler and the PL/I compiler. Panels for registering runtime options are common across all runtime options.
  7. In the View/Update Runtime Options panel, the data sets that you registered are displayed.
    Task 4-7. View/Update Runtime Options panel

You completed this task. You have successfully registered runtime options.

Back to top


Task 5. Change DBD and PSB with IMS resource change

(Menu: 1 Database and Application Administration > 2 IMS Resource Change)

Now you have completed the following preparation tasks:

  • All the data sets that you want to use with IMS resource change are registered to a data set group.
  • The data set group is selected for the data set selection method.
  • DBD and PSB to change are decoded and stored in decoded source data sets.
  • Runtime options for IMS resource change tasks are registered.

In this task, you use the IMS resource change function to change a DBD and a PSB.

  1. From the IMS Administration Tool ISPF main menu, select 1 Database and Application Administration and press Enter.
    Task 5-1. Main menu
  2. In the Database and Application Administration panel, ensure that the IMS subsystem ID and the data set selection method displayed are correct.
    Select 2 IMS Resource Change and press Enter.
    Task 5-2. Database and Application Administration panel
  3. In the IMS Resource Change panel, select 1 DBD/PSB Resource Change and press Enter.
    Task 5-3. IMS Resource Change panel
  4. The DBD/PSB Resource Change panel is displayed.
    This panel consists of two panels. The second panel is displayed after you enter all the required fields in the first panel.
    Task 5-4. DBD/PSB Resource Change panel (1)
    Task 5-4. DBD/PSB Resource Change panel (2)
    The first panel is for selecting the members to process and the tasks to perform.
    • The Object Selection Criteria for DBDGEN/PSBGEN/ACBGEN section specifies the members to process.
    • The Resource Change Tasks section specifies the tasks to perform. You can select all the tasks (from DBDGEN to IMS catalog populate) or only some tasks (for example, only DBDGEN).
    The second panel is for specifying options that are related to DBD and PSB update JCL.
    • The IMS Resource Change Options section specifies whether to execute the JCL immediately (E) or build JCL (B) to run at a later time. If you select B, you can view and edit the JCL before you submit it.
    • The JCL Output Options section specifies the data set where IMS Administration Tool stores the JCL member, and job (JOB) statements.

    The goals of this scenario are:
    • Import field definition from a copybook to a DBD and perform DBDGEN to update the DBD. Also, perform PSBGEN to update the PSB.
    • Perform ACBGEN to update ACBs, and populate the IMS catalog with updated DBD, PSB, and ACBs.
    In this scenario, you run two IMS resource change sessions to accomplish these goals:
    • First session: Import field definitions from a copybook to the DBD source code, and perform DBDGEN and PSBGEN.
    • Second session: Perform ACBGEN and populate the IMS catalog with the updated DBDs, PSBs, and ACBs.
  5. In the first DBD/PSB Resource Change panel, enter the fields as follows:
    In the Object Selection Criteria for DBGEN/PSBGEN/ACBGEN section:
    • For Object Type, specify 3 (Both) so that both DBDs and PSBs are selected.
    • For Select DBDs and Select PSBs, enter the names of DBD and PSB members.
    • In the first DBD/PSB Resource Change panel, enter the fields as follows:
    In the Resource Change Tasks section:
    • For 1. DBDGEN, enter 2 (Yes with Copybook Import).
    • For 2. PSBGEN, enter 1 (Yes).
    • For 3. ACBGEN and 4. IMS Catalog Populate, enter 3 (No).
    Press Enter to proceed to the second panel.
    Task 5-5. DBD/PSB Resource Change panel (1)
  6. In the second DBD/PSB Resource Change panel, enter the fields as follows:
    In the IMS Resource Change Options section:
    • For Exec or Build JCL, enter B (Build JCL).
    In the JCL Output Options section:
    • For JCL Output Data Set, specify a data set to store the IMS resource change JCL.
    Task 5-6. DBD/PSB Resource Change panel (2)
    Press Enter. IMS Administration Tool generates DBD and PSB update JCL (member JCL1) in the JCL output data set.
  7. Some messages related to JCL generation are displayed. Enter PF3 to display the generated JCL member.
    Task 5-7. Generated JCL member
    The JCL contains the following steps:
    • Imports copybook field definitions to the source code of DBD member IVPDB1.
    • Calls the DBDGEN utility to generate DBD member IVPDB1.
    • Calls the PSBGEN utility to generate PSB member SQLIVPB.

    The data sets that belong to the selected data set group are specified with the following DD statements:
    DD statement Data set
    ATYDBD DBD statement source
    ATYPSB PSB statement source
    DBDLIB DBD libraries
    PSBLIB PSB libraries
    ATYXREF Copybook cross reference
    ATYCOPY COBOL copybook
    ATYPLI PL/I copybook
    ATYPUTDB DBD statements with copybook
    After reviewing the JCL statements, press PF3.
  8. In the Submit Job Confirmation pop-up menu, enter Y to submit the JCL.
    The following message is displayed.
    Task 5-8. Message
    Ensure that the job ends with return code 0.
    Now the DBD and PSB are updated. Next step is to run ACBGEN and populate the IMS catalog with the new DBD and PSB.
  9. Go back to the DBD/PSB Resource Change panel.
    In the first DBD/PSB Resource Change panel, enter the fields as follows:
    In the Object Selection Criteria for DBGEN/PSBGEN/ACBGEN section:
    • For Object Type, specify 3 (Both) so that both DBDs and PSBs are selected.
    • For Select DBDs and Select PSBs, enter the names of the DBD and PSB members.
    In the Resource Change Tasks section:
    • For 1. DBDGEN, enter 3 (No).
    • For 2. PSBGEN, enter 3 (No).
    • For 3. ACBGEN, enter 1 (Yes).
    • For 4. IMS Catalog Populate, enter 1 (Yes).
    Press Enter to proceed to the second panel.
    Task 5-9. DBD/PSB Resource Change panel (1)
  10. In the second DBD/PSB Resource Change panel, enter the fields as follows:
    In the IMS Resource Change Options section:
    • For Exec or Build JCL, enter B (Build JCL).
    In the JCL Output Options section:
    • For JCL Output Data Set, specify a data set to store the IMS resource change JCL.
    Task 5-10. DBD/PSB Resource Change panel (2)
    Press Enter. IMS Administration Tool generates DBD and PSB update JCL (member JCL2) in the JCL output data set. The JCL contains the following steps:
    • Calls the ACBGEN utility or the Advanced ACBGEN utility of IMS Library Integrity Utilities to generate ACB from DBD member IVPDB1 and PSB member SQLIVPB.
    • Calls the IMS Catalog Populate utility to populate the IMS catalog.
  11. Repeat steps 7 and 8 and ensure that the job ends with return code 0.

You completed this task. You have successfully changed the DBD and PSB, generated ACB, and populated the IMS catalog.

Tip: In this scenario, you used two IMS resource change sessions to accomplish the goals. You can also accomplish the goals with one IMS resource change session by specifying as follows in the Resource Change Tasks section:
Task 5. Tip - Resource Change Tasks section

Remember: The IMS resource change function updates the ACB library (the ACB staging library if "discovered data sets" are used) in the ACBGEN task and the IMS directory staging data set in the IMS Catalog Populate task. After the ACBGEN task or IMS catalog populate task completes, you must perform the IMS online change (OLC) or issue the IMPORT DEFN SOURCE(CATALOG) command to activate DBDs and PSBs in the online IMS system.

Back to top

Document Location

Worldwide

[{"Line of Business":{"code":"","label":""},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCD9F6","label":"IMS Administration Tool"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"},{"Line of Business":{"code":"LOB35","label":"Mainframe SW"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSS8QJ","label":"IMS Database Solution Pack for z\/OS"},"ARM Category":[{"code":"a8m0z000000cvkCAAQ","label":"IMS Administration Tool"}],"Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"2.2.0"}]

Document Information

Modified date:
11 November 2020

UID

ibm16350889