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

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

Start of instruction setTo 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.

Start of instruction setTo 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/NSQ) Only available if Natural for DB2 (NDB) or Natural for SQL/DS (NSQ) is installed.

SQL Services (NDB/NSQ) are used to generate DDMs from DB2 or SQL/DS tables as described in SQL Services (NDB/NSQ) (Natural for DB2) and SQL Services (Natural for SQL/DS) in the Database Management System Interfaces documentation.

D DL/I Services Only available if Natural for DL/I is installed.

DL/I Services are used to maintain a Natural for DL/I environment. They provide functions for inquiry into and modification of structures such as DL/I Database Descriptions (DBDs), Program Specification Blocks (PSBs), Program Communication Blocks (PCBs), DDMs and segment layouts.

DL/I Services are described in the Database Management System Interfaces documentation.

Z SQL Services (NSB) Only available if Natural SQL Gateway (NSB) is installed.

SQL Services (NSB) are used to generate DDMs from SQL tables as described in SQL Services (NSB) in the Database Management System Interfaces documentation.

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

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.

Start of instruction setTo 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.

If a DL/I segment type is used, the file number specified is used internally by Natural for DL/I.

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
D DL/I
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.