IBM Support

How to change DBDs and PSBs by using IMS Administration Tool

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.

To update IMS resources such as DBDs and PSBs, use the IMS resource change function in IMS Administration Tool. The function provides ISPF interactive panels that help you update IMS resources efficiently.

By following the instructions in this article, you can:
- Create or update DBDs and PSBs, and then run DBDGEN, PSBGEN, ACBGEN, and IMS catalog populate either from ISPF panels or by generating JCL automatically and running it.
- Predefine IMS data sets to be referenced during DBD and PSB updates by registering them in a data set group.
- Predefine runtime options required for DBD and PSB updates.

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 intended for users who are using IMS Administration Tool to update DBDs and PSBs for the first time.

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 - 5 are preparation tasks. DBD and PSB change is done in Task 6.

Note: 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: IMS Administration Tool main panel
  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
    • IMS catalog populate: 9. ACB libraries (7. DBD libraries are also used if the the type of DBD is either GSAM or logical DBD)

     

    Tips: 

    • If you want to view the data sets that IMS Administration Tool identifies, specify Y for Confirm discovered data sets? and press Enter.
    • IMS directory data sets and IMS catalog database data sets are also updated during the IMS catalog populate process. However, you do not need to specify them in the data set group. IMS Administration Tool discovers these data sets from IMS definitions. 

     

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

    Select 1. DBD statement source and press Enter.   
    Task 1-1-4: Manage Data Sets panel

  5. A list of registered DBD statement source data sets is displayed. If no DBD statement source 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 statement source 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 statement source 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.   
    Tip: If you do not plan to import copybooks, you do not need to specify data sets for 3. COBOL copybook, 4. PL/I copybook, 5. Copybook cross reference, and 6. DBD statements with copybook.   
    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 statement source data sets.   
    Select 1. DBD statement source 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: IMS Administration Tool main menu panel
  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.   
    Tip: You can change the data set selection method anytime.

    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.

Back to top

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

(Menu: 1 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: IMS Administration Tool main menu panel
  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.   
    Before you select a library, make sure that the data sets shown in the Decoded Source Data Set and Updated Source Data Set fields match the ones specified in the data set group. The decoded DBD source code and updated DBD source code will be stored in these data sets.    
    Task 3-4: Object Explorer - DBD panel   
    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, type IVP* in the DBD Filter field, select 1. DBD Library in Data Set Group "DSGAPPL1", and press Enter.   
    Task 3-4: Object Explorer - DBD 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 A (Alter) next to DBD IVPDB1 and press Enter.   
    Task 1-5: Database DBD List panel

  6. Decoded source code is displayed.   
    This member is now stored in the decoded source data set TESTDS.ATY.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

  7. Update the source code. In this scenario, update the VERSION= statement by replacing the date with the text "Update Test". 

    Task 3-7: Updated source code

  8. Press PF3 to save the source code.

    Task 3-8: Database DBD List panel

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

Back to top

Task 4. Create DBDs and PSBs 

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

This task explains how to create new DBDs and PSBs. In this scenario, you create a new PSB based on an existing PSB. 

  1. From the Database and Application Administration menu, select 1 Object Explorer. In the pop-up menu, select 2 Application (PSB).   
    In the Object Explorer panel, enter DFS* in the PSB Filter field. For the library, select 1 PSB Library in Data Set Group "DSGAPPL1".   
    Make sure the Decoded Source Data Set and Updated Source Data Set fields display the data sets specified in the data set group. Press Enter to continue.   

    Task 4-1: Object Explorer - PSB panel

  2. Enter M (Model) next to the PSB that you want to use as the model, and press Enter.

    Task 4-2: Application PSB List panel

  3. In the pop-up dialog, enter the name for the new PSB, and press Enter.

    Task 4-3: Create/Model a PSB dialog

  4. The source code of the PSB you selected as the model is decoded from the PSB library and displayed. 

    Task 4-4: Updated PSB source code

  5. Update the source code. In this scenario, update the PSB name from DFSIVP2 to DFSIVPX, update the referencing DBD name to IVPDB1. Press PF3 to save. 

    Task 4-5: Updated PSB source code

  6. The new PSB member is saved. 

    Task 4-6: Application PSB List panel

You completed this task. You have successfully created a new PSB.

Back to top

Task 5. 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 DBD and PSB update tasks. 

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. 

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 5-1: IMS Administration Tool main menu panel
  2. In the Database and Application Administration panel, select 0 Settings and press Enter.   
    Task 5-2: Database and Application Administration panel
  3. The Settings panel is displayed. Select 2 View or Update Runtime Options and press Enter.   
    Task 5-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 IFJ1) and press Enter.   
    Task 5-5: View/Update Runtime Options panel
  5. In the Update Runtime Option panel, enter the IMS macro library data set and press Enter.   
    Task 5-5: Update Runtime Option panel
  6. Repeat steps 4 and 5 to register copybook default language and the COBOL 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 5-7: View/Update Runtime Options panel

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

Back to top

Task 6. 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 6-1: IMS Administration Tool main menu panel
  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 6-2: Database and Application Administration panel
  3. In the IMS Resource Change panel, select 1 DBD/PSB Resource Change and press Enter.   
    Task 6-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 6-4: DBD/PSB Resource Change panel   
    Task 6-4: DBD/PSB Resource Change panel   
    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.

     

  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 DBDs and PSBs, enter the names of DBD and PSB members.

     

    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 1 (Yes).

    Press Enter to proceed to the second panel.   
    Task 6-5: DBD/PSB Resource Change panel

  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 6-6: DBD/PSB Resource Change panel   
    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 6-7: Generated JCLTask 6-7: Generated JCL 
    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.
    • Calls the ACBGEN utility for the DBD and PSB members.
    • Calls the IMS catalog populate utility to store DBDs and PSBs in the IMS directory staging data set and IMS catalog.


    The data sets that belong to the selected data set group are specified with the following DD statements:

    DD statementData set
    ATYDBDDBD statement source
    ATYPSBPSB statement source
    DBDLIBDBD libraries
    PSBLIBPSB libraries
    ATYXREFCopybook cross reference
    ATYCOPYCOBOL copybook
    ATYPLIPL/I copybook
    ATYPUTDBDBD 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.

    Job submitted.  Job JOBA (JOB08089) was submitted from system SYS1.   

    Ensure that the job ends with return code 0.

    Now the updated DBD and PSB are stored in the IMS directory and IMS catalog as pending instances.

    Remember: You must activate the pending DBDs and PSBs by issuing the IMPORT DEFN SOURCE(CATALOG) command to the online IMS system. 

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

 Back to top

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.

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":"LOB70","label":"Z TPS"},"Business Unit":{"code":"BU048","label":"IBM Software"},"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:
15 September 2025

UID

ibm16350889

Page Feedback