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:
- Log on to a TSO user ID that is enabled to access and use FM/Db2.
- 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.
- 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.
- 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.
- FM/Db2 is always shown as
- 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.
- The
- 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
- 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
- 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.