SYSPCI Utility - Product Configuration and Initialization

The SYSPCI utility is used after a first-time installation of Natural or one of its add-on products which uses the Software AG Installer. It sets up a number of files, parameters and individual settings depending on your environment.

Using the SYSPCI utility, you can do the following:

  • Enter the necessary information for the required Adabas files for your products, and add these files if they do not exist.

  • Enter the database IDs of the required Adabas files into Natural's global configuration file.

  • Enter the database IDs and file numbers of the new or existing Adabas files into the default parameter files for your products.

  • Initialize your product.

  • Optional, depending on the selected product: execute additional functions (such as loading product data).

Note:
After an update installation, you need not invoke the SYSPCI utility if the required Adabas files and the parameters in the required default parameter files have already been set up previously (for example, after a first-time installation). Previously set up parameters will be kept with an update installation.

You can call the SYSPCI utility in different ways, as described in the following topics:


Configuring the Installed Products Using a Dialog Box

You can configure the installed Software AG products that the SYSPCI utility can detect in your environment.

The description below provides general information on how to use the SYSPCI utility, and it explains the options that are normally available for all products. For detailed information on the files that need to be set up for a specific product, see the installation documentation for that product.

Start of instruction setTo configure an installed product

  1. Enter the following command:

    SYSPCI

    Note:
    If you invoke the SYSPCI utility in an environment which is protected by Natural Security, Natural Security will validate the utility profile for SYSPCI.

    The following dialog box appears.

    SYSPCI

    Note:
    The above dialog box appears for the local environment. When a remote UNIX environment is active while you enter the SYSPCI command, a character screen is shown. In this case, see the description for the SYSPCI utility in the Natural for UNIX documentation. The SYSPCI utility only applies for Windows and UNIX. It is not available for remote mainframe environments.

    When you open the Product name drop-down list box, you can see the installed Software AG products that have been detected in your environment. Exception: if only one installed Software AG product has been detected, a drop-down list box is not available, and the appropriate options for that product are immediately shown.

  2. From the Product name drop-down list box (if available), select the product that you want to configure.

    Important:
    It is recommended that you configure your products in the same sequence as listed in the Product name drop-down list box.

    The content of the dialog box may change, depending on the selected product. If an Adabas file is found for the currently selected product, the corresponding drop-down boxes can be used to select the required values.

    An action may be shown as disabled (grey) for a selected product. This means, that this option cannot be changed by the user. If a grey option is checked, it will be executed when you choose the OK button.

  3. Specify the following information for the selected product:

    Option Description

    Create new Adabas file or
    Use existing Adabas file

    If Create new Adabas file is selected, the first file must not exist and a new Adabas file will be created. Depending on the selected product, there may be more than one file. If one or more of the other files already exist they can be used for the product.

    If Use existing Adabas file is selected, the first file must exist. Depending on the selected product, there may be more than one file. If one or more of the other files do not exist, they can be created.

    If the Adabas file exists already, however, the SYSPCI utility will only check whether the file has the correct structure (FDT).

    In both cases (new and existing file), the following actions will be performed:

    • The database ID of each required Adabas file will be entered into Natural's global configuration file.

    • The database ID and file number of each new or existing Adabas file will be entered into the default parameter file for your product.

    Initialize product This option is only available for products which have an initialization program.

    If selected (default), the initialization program for the selected product will be loaded and executed. If you want to activate the product, you have to select this option.

    Note:
    If you want to use this option, the database for which you specify the database ID must be online.

    Database ID The database ID of the Adabas file.

    When you open the drop-down list box, a list of all databases is shown which can be found on the machine. The list also shows whether a database is currently online or offline.

    The drop-down list box always shows the databases which have been found at the time when the SYSPCI utility was started. If the status of a database is changed afterwards or a new database is created (for example, by another user), the content of the drop-down list box does not change automatically. If you want to refresh the list, clear the contents of the Database ID field.

    Remote databases are also included in the list, provided they are defined in XTS.config (Net-Work), in DBmapping.txt (ADATCP) or in natconfig.cfg (NATTCP). The list also shows the TCP/IP address for the remote databases and the file in which they are defined.

    File number The number of a file in the selected database. This can be the number of an existing file or for a new file.

    When you open the drop-down list box, a list of all files is shown which can be found for the specified database ID.

    The Adabas system files are also shown in the drop-down list box, so that you can see which file numbers have already been assigned. However, you must not select an Adabas system file. Otherwise, an error will occur.

    When you specify the number for a new file, make sure that the Create new Adabas file option is selected.

    File name The name of the Adabas file.

    When you have selected an existing file, the corresponding file name is automatically shown. This name cannot be changed.

    When you have specified a new file number which does not yet exist, you can enter a file name (optional). If you do not enter a file name, a product-specific default name will be used.

    For some products (such as Predict), you have to specify additional options. See the installation documentation for that product for further information.

  4. Choose the OK button to start the configuration of the selected product.

    After the selected actions for the selected product have been performed, a message such as the following is shown:

    Function completed successfully.
    
    The following actions have been performed by the SYSPCI utility:
    
    - Loaded Adabas file with DBID 10 FNR 55 for product NCP
    - Updated global configuration file for DBID 10
    - Updated Natural parameter file NATPARM and set LFILE 190 to DBID 10 FNR 55
  5. Choose the OK button to close the message box.

    The dialog box for the SYSPCI utility is still shown and you can configure further products. The configuration of Natural Security, however, is an exception. In this case, Natural is terminated after the initialization program has been executed.

Calling the SYSPCI Utility with Direct Command Data

You can call the SYSPCI utility using a direct command that consists of keywords and their corresponding values. Thus, you can also use the SYSPCI utility in batch mode.

Exception: When the initialization of the Adabas file for Natural Security has been completed (by loading the initialization program with the INPL utility and executing it), the Natural session is terminated by the INPL utility. Therefore, it is not possible to execute any additional commands after this step.

You can use the following keywords with the SYSPCI command (see also the examples below):

Keyword Meaning
PRODUCT * Product to be processed. Valid values:

NCP for Natural Command Processor.
PRD for Predict.
NEE for Natural Engineer
NSL for Natural Security Log.
NSC for Natural Security.

Important:
It is recommended that you configure your products in the same sequence as listed above.

DBID * Database ID of the Adabas file.

Note:
When using FUNCTION ADU or ALU you can leave this blank. In this case, the SYSPCI utility will use the DBID value found in the text member INST-<productcode> in library SYSPCI.

DBID2 ** Database ID of the second Adabas file if PRODUCT is PRD or NEE.
FNR * File number of the Adabas file.

Notes:

  1. When using FUNCTION ADU or ALU you can leave this blank. In this case, the SYSPCI utility will use the FNR value found in the text member INST-<productcode> in library SYSPCI.
  2. When using FUNCTION ADA or ALL you can enter a negative value, for example -10. In this case, the SYSPCI utility will use the next free file number starting from the value given. In the above case it would start from file number 10.
FNR2 ** File number of the second Adabas file if PRODUCT is PRD or NEE.
FUNCTION or FCT Function to be executed. Valid values:

ADA: Create new Adabas file.
ADU: Use existing Adabas file. This requires entering a valid DBID and FNR (see above) or entering the value.
ADR: Use existing Adabas file on a remote system. This requires entering a valid DBID and FNR (see above) or entering the value.
INT: Load and execute initialization program.
INR: Load and execute initialization program using Adabas file on a remote system.
INW: Initialize product without Adabas file specification.
ALL: Both (ADA and INT). Default.
ALU: Both (ADU and INT).
ALR: Both (ADR and INR).

FILE-NAME Name of the Adabas file if FUNCTION is ADA or ALL. Valid values: 16 characters without blanks.
FILE-NAME-2 or FILE-N2 Name of the second Adabas file if PRODUCT is PRD or NEE. Valid values: 16 characters without blanks.
SUBFUNCTION Additional function to be executed. The valid values depend on the product.

If PRODUCT is PRD:

  • PRC: Convert FDIC data.

  • PRP: Load FDIC description.

  • PRD: Load example data.

  • PRA: Both (PRP and PRD).

  • PR1: Convert FDIC data and load FDIC description.

  • PR2: Convert FDIC data and load example data.

  • PR3: Convert FDIC data and load FDIC description and example data.

END, STOP, EXIT, QUIT or . Exit the SYSPCI utility. The keyword must be entered as a single command.
FIN Exit the SYSPCI utility and terminate the Natural session. The keyword must be entered as a single command.

Notes:

  1. The keywords marked with an asterisk (*) are mandatory.
  2. The keywords marked with two asterisks (**) are mandatory for the corresponding products.
  3. All other keywords are optional.

Examples

  • Batch Mode
    Commands in the batch input file which is defined by the CMSYNIN profile parameter:

    SYSPCI
    FIN

    Data in the batch input file which is defined by the CMOBJIN profile parameter:

    FUNCTION ALL PRODUCT PRD DBID 77 FNR 2002 DBID2 12 FNR2 2003
    FUNCTION ALL PRODUCT NSC DBID 77 FNR 1600
    END

    See also Natural in Batch Mode in the Operations documentation.

  • Interactive Mode - Natural Command Line
    SYSPCI FUNCTION ALL PRODUCT NSL DBID 77 FNR 1601
  • Interactive Mode - Natural Stack
    C:\SoftwareAG\Natural\bin\natural stack=(SYSPCI FUNC ALL PROD NCP DBID 77 FNR 1501: PROD NSL DBID 77 FNR 1601; FIN)