Using SYSDDM Maintenance and Service Functions

#### Search Results

Search

# Using SYSDDM Maintenance and Service Functions

The functions provided in the SYSDDM utility menu are used to create, display, edit, rename or delete a DDM.

This section describes the fields and functions available in the SYSDDM utility menu and provides information on maintaining DDMs in different environments.

- Help on Functions

- Performing a Function

- Description of Functions

- DDM Specification

## Help on Functions

This section provides instructions for obtaining information on the fields and functions provided in the SYSDDM utility menu.

To display SYSDDM help information

1. On the SYSDDM utility screen, press PF1.

   Or:
   In the command line or in any input field, enter a question mark (?).

   The Help Main Menu of the SYSDDM utility appears.

2. Position the cursor next to the greater than (>) sign of the help topic required and press PF1.

   The SYSDDM help screen appears for the topic selected.

   - To scroll forward, press ENTER.

   - To return to the Help Main Menu, press PF3.

   - To terminate the help function and return to the SYSDDM utility menu, press PF12.

3. To exit the Help Main Menu, enter a period (.) or press PF3.

   The SYSDDM utility menu appears.

## Performing a Function

This section provides instructions for performing a function from the SYSDDM utility menu.

To perform a function

- In the SYSDDM utility menu:

  - From the section DDM Maintenance, List/Copy Services or Other Services choose the one-digit code listed next to the function required and enter it in the Code field.

    For example: to edit a DDM, enter the function code `E`.

    The functions are explained in Description of Functions.

  - In the input fields next to Code, enter a valid value to specify the DDM(s) to be processed as described in DDM Specification.

## Description of Functions

This section describes the functions available on the SYSDDM utility menu and lists their corresponding function codes:

Function Code | Field | Function
--- | --- | ---
E | Edit DDM | Invokes the DDM editor and reads a DDM source from the FDIC system file into the source area.
R | Read DDM | Reads a DDM source from the FDIC system file into the source area but does not invoke the DDM editor.
C | Catalog DDM | Saves the DDM source currently contained in the source area as a cataloged object in the current FDIC system file. For the naming conventions that apply when cataloging a DDM, refer to Object Naming Conventions in the Using Natural documentation. If the source area is empty, use the function Generate DDM from Adabas FDT or Edit DDM to load a source into the source area. For a DDM from VSAM (DDM Type set to `V`; see also DDM Type in DDM Specification), SYSDDM prompts you for additional information. For details, see Natural File Access in the Database Management System Interfaces documentation.
U | Delete DDM | Deletes one or more cataloged DDM from the FDIC system file. The contents of the source area are not affected by the deletion. When you delete a DDM with SYSDDM, the corresponding Natural Security file profile is deleted too.
L | List DDMs | Displays a single DDM source (DDM editor not invoked) or a list of DDMs stored in the specified FDIC system file similar to the Natural system command `LIST DDM` described in the System Commands documentation. However, unlike the system command `LIST DDM`, the List DDMs function additionally displays all DDMs for which no read or update access right is defined in Natural Security (if installed). For details, see Protecting DDMs On Mainframes in the Natural Security documentation. From the list of DDMs displayed on the LIST DDMs screen, you can select a DDM for further processing by entering the line command that corresponds to the action required in the Cmd column. For information on possible commands, enter a question mark (?) in the Cmd column.
X | List DDMs with Additional Information |
Displays a list of DDMs stored in the specified FDIC system file. The list contains the following fields of information:
DBID | The database ID: see DBID in DDM Specification.
FNR | The file number: see FNR in DDM Specification.
DDM Typ | The DDM type: see DDM Type in DDM Specification.
Bytes | The size of the DDM in bytes.
Secur. Type | Only applies if Natural Security is installed. The security type: `Public`, `Private`, `Access` or `Undef` (undefined). See also the status of a DDM in the section Components of a File Profile in the Natural Security documentation).
File Type | Only applies to a DDM created from VSAM, or a PersonalDB file from Super Natural. The VSAM file type: `Log.View` (logical view), `Phy.File` (physical file) or `Log.File` (logical file). Super Natural:`Userfile` indicates that the DDM was created in Super Natural.
File Name | Only applies to DDMs from VSAM files. The name of a logical or physical file.
Remark | A remark such as `SupNat` (for a `Userfile` from Super Natural) or the VSAM file organization (`KSDS`, `RRDS`, `ESDS` or `VRDS`).
From the list displayed on the screen List DDMs with Additional Information, you can select a DDM for further processing by entering the line command that corresponds to the action required in the Cmd column. For information on possible commands, enter a question mark (?) in the Cmd column.
S | Show Defined DBIDs and Used FNRs | See Show Defined DBIDs and Used FNRs.
M | Copy DDM to Another FDIC File | Copies one or more DDMs from one FDIC system file to another. This can be required, for example, when a Natural application is transferred from test to production status. This function invokes the Copy DDMs window of the Natural utility SYSMAIN where you can specify source and target environment of the DDM(s) to be copied; see also the section Processing DDMs in the SYSMAIN Utility documentation.
G | Generate DDM from Adabas FDT | Generates a DDM from an Adabas field definition table (FDT) and places it in the source area for further processing. If `0` (zero) is entered as DBID, the default DBID specified with the `UDB` profile parameter in the Natural parameter module is used. The generated DDM is placed in the source area for further processing.
B | SQL Services (NDB) | Only available if Natural for Db2 (NDB) is installed. SQL Services (NDB) are used to generate DDMs from Db2 tables as described in SQL Services (NDB) (Natural for Db2) in the Database Management System Interfaces documentation.
Z | SQL Services (NSB) | Not applicable.

### Show Defined DBIDs and Used FNRs

This function shows you which database IDs (DBIDs) are defined, as well as all file numbers (FNRs) of a given DBID for which DDMs have been defined.

When you invoke this function, a menu appears from which you can select the subordinate functions described in the following section.

- Database IDs Defined in Natural
- File Numbers of Existing DDMs for a Database

#### Database IDs Defined in Natural

This function lists all DBIDs and appropriate database types specified with the Natural profile parameter `DB` (see also DB - Database Types and Options in the Parameter Reference documentation). The list does not contain the DBIDs of the default database type, which is shown at the top of the screen.

#### File Numbers of Existing DDMs for a Database

This function lists for a given DBID all file numbers for which DDMs have been defined.

To invoke this function, choose either of the following methods:

- In the menu Show Defined DBIDs and Used FNRs, in the Code field, enter an `F` and, if required, modify the DBID entered by default.

  Or:
  On the screen Database IDs Defined in Natural, in the command line, enter a DBID (valid values are `1` - `65535`) and press PF5.

## DDM Specification

For each function provided in the SYSDDM utility menu, you can specify one or more parameters that determine which DDM(s) are processed for which database. The section below describes the fields where you enter these parameters.

Field | Explanation
--- | ---
DDM Name | The name of the DDM to be processed. You can also specify a range of names: use asterisk (*) to process all DDMs or use asterisk (*) notation to process particular DDMs. For example: `EMP*` selects all DDMs with names that start with EMP. Specifying ranges with the function Delete DDMs or Copy DDM to Another FDIC File invokes the SYSMAIN utility where you can further process the DDMs; see also the section Processing DDMs in the SYSMAIN Utility documentation.
FNR | The file number (FNR) of the database file for which the DDM is (to be) defined. The file number corresponds to the type of database. For example, if an Adabas file is used, the Adabas file number must be entered. For VSAM files, see Natural for VSAM in the Database Management System Interfaces documentation. Valid values are `0` - `5000`.
DBID | The database ID (DBID) which contains the database file referenced by the DDM. Valid values are `1` - `65535`, except `255`. If `0` (zero) is specified, the database ID specified with the Natural profile parameter `UDB` in the Natural parameter module is used. See also `UDB` in the Parameter Reference documentation. If no DBID is entered, it is generated dynamically at execution time based on the DBID of the system file FUSER.
Replace |
Specifies whether to replace a DDM:
`Y` | Yes. A DDM which is being copied or cataloged replaces an existing DDM with the same name.
`N` | No. Existing DDMs with the same name are not replaced. This is the default setting.
This function corresponds to the `REPLACE` option of the command `CATALOG` described in Editor and System Commands.
FDIC Type | The database type of the system file. Possible types are the same as for DDM Type (see below). This is an output field only.
DDM Type |
The type of DDM, for example:
`A` | Adabas This is the default type.
`V` | VSAM
`2` | Db2 or SQL
`P` | PROCESS (Entire System Server)
`C` | Command processor
`S` | Super Natural
`E` | Entire DB Engine
The type of DDM corresponds to the type of database referenced by the DDM.
Adabas Password | The password required by Adabas if installed.
DBID Type | The database type of the database specified in the DBID field. Possible types are the same as for DDM Type (see above). Exception: for an Adabas database, the Adabas version (for example, `8`) is displayed. This is an output field only.

### On this page

- Help on Functions
- Performing a Function
- Description of Functions
- DDM Specification