Step 1. Define Db2® objects to be used during verification

The first step in the FM/Db2 verification is to define the Db2® objects to be used.

Take a copy of the IVP member from the sample library. Select the sample member that matches the Db2® version of the Db2® system where the IVP database is to be created. For example:
FMN2VERC  (for Db2 version 12 systems)
FMN2VERD  (for Db2 version 13 systems)
Note: The figures in this chapter are from a Db2® version 12 system. If you run the IVP against a later Db2® version there might be minor differences in the names of the Db2® objects.

Follow the instructions at the top of the sample. You need to review, and possibly change, the following values:

SG name
Change this to the name of a Db2® storage group of your choice. You can use an existing Db2® storage group name. To do this, change SG_name to the existing storage group name, and comment out the CREATE STOGROUP statement. If you use an existing Db2® storage group name, you can skip the customization for Vol_list and DB2_VCAT_name.
VOL_list
Change this, if required, to a list of valid disk volume names.
DB2_VCAT_name
Change this to the VCAT name used for Db2® user data sets, for the appropriate Db2® system.

To execute the DDL statements:

  1. Log on to a TSO user ID that is enabled to access and use FM/Db2.
  2. Start FM/Db2.
    • If you have added an option for FM/Db2 to your ISPF Primary Options menu (see Adding FM/Db2 to the ISPF menu), type this option value, and press Enter. For example, if you have assigned FD to FM/Db2, type FD and then press Enter.
    • If you defined FM/Db2 in an ISPF command table (see Defining FM/Db2 in an ISPF command table), verify that FM/Db2 can be started by entering the command FD on any ISPF command line.
  3. If you have previously selected a Db2® subsystem, you immediately see the Primary Option Menu.

    If this is the first time you have used FM/Db2:

    • The Copyright panel appears. After reading the panel text, press the Cancel key, PF12. In subsequent sessions this panel does not automatically appear.
    • The Db2 Subsystem Selection menu is displayed, showing the Db2® subsystems you customized in your FMN2SSDM macro. Select the Db2® subsystem you want to use, or run the FM/Db2 IVP against, and press Enter to go to the FM/Db2 Primary Option Menu.
  4. Enter VER on the command line to display the release level and PTF level of FM/Db2. A panel is displayed that gives you, as example, the following information:
    IBM
          File Manager for z/OS Version 14 Release 1 Modification 21
    Db2 Component
    (not APF authorized)
    
    Service Levels of installed components
    
                 Base       IMS        Db2        CICS
    English      -NONE-     -NONE-     -NONE-     -NONE-
    • FM/Db2 is always shown as APF not authorized, even if you have made File Manager APF-authorized, as File Manager cannot run as APF-authorized under ISPF.
    • When you first install File Manager, -NONE- is shown against each component. Subsequently, when you have applied service to File Manager, a PTF number is shown, indicating the PTF level of each component you have installed. If you have not installed a component, that component is not be shown at all.

      If you have installed the Japanese, or Korean language components of FM/Db2, another line is displayed indicating the service level of that component.

  5. Select the FM/Db2 system options by typing '0.0.2' on the FM/Db2 main menu panel and pressing Enter. See FM/Db2 System Options panel. Ensure that:
    • The Translate Db2® object names option is not selected.
    • The Translate input SQL statements option is not selected.
  6. Press PF3 to return to the FM/Db2 main menu.
    Figure 1. FM/Db2 System Options panel
      Process   Options   Utilities   Help
     ──────────────────────────────────────────────────────────────────────────────
     FM/Db2 (DFF2)          FM/Db2 System Options (1 of 4)          Global Settings
     Command ===>                                                                  
    
     Uppercase Translation:
        Enter "/" to select option
           Translate Db2 object names
           Translate input SQL statements
    
     Encapsulation of SQL Identifiers in Double Quotes:
        Use double quotes
        3  1. For Db2 SQL reserved words
           2. For IBM and Db2 SQL reserved words
           3. Always
    
     More Options:
        Enter "/" to select option
        /  Arbitrary select statements, time display format, template creation
        /  CCSID warning option
        /  Editor choice for viewing output data, members
    
      F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
     F11=NxtPage  F12=Cancel
    
  7. Select the Edit/Execute SQL (Data Set) function by typing '4.4' on the FM/Db2 main menu panel and pressing Enter.

    See Edit/Execute SQL (Data Set) panel.

    Enter a data set name, member name, and execution options, as shown in Edit/Execute SQL (Data Set) panel. Modify the data set and member names to reflect the data set and member name containing your modified copy of the FMN2VER sample.

    Figure 2. Edit/Execute SQL (Data Set) panel
      Process   Options   Utilities   Help
     ──────────────────────────────────────────────────────────────────────────────
     FM/Db2 (DFF2)            Edit/Execute SQL (Data Set)
     Command ===>                                                                  
    
     Input Data Set:
        Data set name . . . 'FMN.V14R1M21.IVP'                             
        Member  . . . . . . FMN2VER
        Volume  . . . . . .       
    
     SELECT statement options:
        Row count . . . . . ALL            Number of rows to browse
    
     Processing Options:
        Execution options                  Enter "/" to select option
        1    First column                  /  Edit data set
        72   Last column                   /  Execute SQL from data set
        --   Comment chars                    Re-edit data set after execution
    
    
    
    
      F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
     F12=Cancel
    
  8. Press Enter to edit the sample DDL. When you have made any required changes, press PF3 to run the DDL statements.

    When the DDL samples run successfully, two SQL warning messages are displayed. See SQL Warning (1) panel and SQL Warning (2) panel. These warnings are expected. To continue running, press Enter.

    Figure 3. SQL Warning (1) panel
      Process   Options   Utilities   Help
     ─ ┌───────────────────────── SQL Warning Encountered ─────────────────────────┐
     F | Command ===>                                                              |
     C |                                                                           |
       |    SQLCODE : 162                            DSNTIAR CODE :  0             |
     I |                                                                           |
       |  DSNT404I SQLCODE = 162, WARNING:  TABLE SPACE FMN0IVD.FMN0IVSD HAS BEEN  |
       |           PLACED IN CHECK PENDING                                         |
       |  DSNT418I SQLSTATE   = 01514 SQLSTATE RETURN CODE                         |
       |  DSNT415I SQLERRP    = DSNXICRC SQL PROCEDURE DETECTING ERROR             |
     S |  DSNT416I SQLERRD    = 20  0  0  ─1  0  0 SQL DIAGNOSTIC INFORMATION      |
       |  DSNT416I SQLERRD    = X'00000014'  X'00000000'  X'00000000'              |
       |           X'FFFFFFFF'  X'00000000'  X'00000000' SQL DIAGNOSTIC            |
     P |           INFORMATION                                                     |
       |                                                                           |
       |    SQL Statement : ALTER TABLE FMN0USR."Department─Information" FOREIGN   |
       |  KEY "Department must have Admin" ("Administration Department") REFERENC  |
       | ES FMN0USR."Department─Information" ON DELETE CASCADE                     |
       |                                                                           |
       |                                                                           |
       |  F1=Help       F2=Split      F3=Exit       F5=SQL        F7=Backward      |
       |  F8=Forward    F9=Swap      F12=Cancel                                    |
       └───────────────────────────────────────────────────────────────────────────┘
     F12=Cancel
    
    Figure 4. SQL Warning (2) panel
      Process   Options   Utilities   Help
     ─ ┌───────────────────────── SQL Warning Encountered ─────────────────────────┐
     F | Command ===>                                                              |
     C |                                                                           |
       |    SQLCODE : 162                            DSNTIAR CODE :  0             |
     I |                                                                           |
       |  DSNT404I SQLCODE = 162, WARNING:  TABLE SPACE FMN0IVD.FMN0IVSD HAS BEEN  |
       |           PLACED IN CHECK PENDING                                         |
       |  DSNT418I SQLSTATE   = 01514 SQLSTATE RETURN CODE                         |
       |  DSNT415I SQLERRP    = DSNXICRC SQL PROCEDURE DETECTING ERROR             |
     S |  DSNT416I SQLERRD    = 20  0  0  ─1  0  0 SQL DIAGNOSTIC INFORMATION      |
       |  DSNT416I SQLERRD    = X'00000014'  X'00000000'  X'00000000'              |
       |           X'FFFFFFFF'  X'00000000'  X'00000000' SQL DIAGNOSTIC            |
     P |           INFORMATION                                                     |
       |                                                                           |
       |    SQL Statement : ALTER TABLE FMN0USR."Department─Information" FOREIGN   |
       |  KEY "Manager must be Employee" ("Manager Employee Number") REFERENCES F  |
       | MN9USR."Employee─Detail" ON DELETE SET NULL                               |
       |                                                                           |
       |                                                                           |
       |  F1=Help       F2=Split      F3=Exit       F5=SQL        F7=Backward      |
       |  F8=Forward    F9=Swap      F12=Cancel                                    |
       └───────────────────────────────────────────────────────────────────────────┘
     F12=Cancel
    

    When the SQL has run successfully, a box appears at the bottom of the screen with 173 statements executed.

Move onto Step 2. Run the FMN2CHKx sample job of the IVP.