Db2 environment

Don’t forget to scroll through the whole PARMLIB member. The SUBSYSTEM_ENABLED indicator (see also SUBSYSTEM_ENABLED), needs special attention:

• Setting the SUBSYSTEM_ENABLED indicator to Y, will mark this subsystem as active and available to be used with File-AID/RDX, File-AID for Db2, and File-AID Data Editor of the Workbench for Eclipse andWorkbench for VS Code.
• Setting the SUBSYSTEM_ENABLED indicator to N, will mark this subsystem as inactive and it will NOT be available to be used with File-AID/RDX, File-AID for Db2, and File-AID Data Editor of the Workbench for Eclipse and Workbench for VS Code.

The parameters are used to establish the Db2 subsystems in your Db2 environment. You must supply values for each subsystem on which you install File-AID products that access the File-AID Db2 subsystem definitions.

Db2 Environment Parameters (FADE00)

One-Time Parameters

The next 3 parameters are one-time parameters that must NOT be repeated when defining multiple Db2 subsystems.

DEFAULT_DB2_SUBSYSTEM_ID

Description: Default SSID. Max. length 4.
Specify a Db2 Subsystem ID (SSID) as the default SSID.

Default: blank (no default value)

Required: yes

DEFAULT_DB2_LOAD_DATASET

Description: Default Db2 Loadlib. Max. length 44.
(Specify the Db2 Load library for the default SSID (SDSNLOAD).

Default: blank (no default value)

Required: yes

RELATIONSHIP_DATASET

Description: Relationship Dataset Name. Max. length 44.
(Optional) Specify the dataset name of the Relationship file to be used with File-AID/RDX and File-AID for Db2. It will be used to generate JCL for the RI update jobs (see also Refreshing-relationship-file-from-an-outside-source). The Relationship file requires WRITE access for users to update the Relationship file.

Default: blank (no default value)

Db2 Subsystem Definition

The following parameters are used to define a single Db2 subsystem. To define multiple Db2 subsystems, repeat (copy and paste) the block of parameters from DB2_ENVIRONMENT to END, then edit the parameters to identify the other subsystems. Each subsystems must be identified with a unique DB2_SUBSYSTEM_ID.

DB2_ENVIRONMENT

Description: Each SSID definition starts with a DB2_ENVIRONMENT parameter and terminates with an END parameter (see also END ). There are no parameter values.

Default: N/A

Required: yes

DB2_SUBSYSTEM_ID

Description: The Db2 subsystem ID for which you are installing File-AID. Max. length 4.
This value helps identify JCL members and profiles that File-AID generates for specific Db2 subsystems.

Default: blank (no default value)

Required: yes

DB2_SUBSYSTEM_DESCRIPTION

Description: Db2 Subsystem Description. Max. length 30.
Specify a maximum 30-character, free-format Db2 subsystem description. (Optional)

Default: blank

DB2_EXTENDED_PANELS_DATASET

Description: Extended Panels. Max. length 44.
Additional panel library (SDSNPFPE).
(Optional) This panel library specification is only required if File-AID for Db2 Primary Option Menu option 3.5, SQL Command Manager (SPUFI), is to be invoked.

Default: blank (no default value)

DB2_EXIT_DATASET

Description: Customized Db2 exit library (SDSNEXIT). Max. length 44.

Default: blank (no default value)

Required: yes

DB2_LOAD_DATASET

Description: Db2 load library (SDSNLOAD). Max. length 44.

Default: blank (no default value)

Required: yes

DB2_MESSAGES_DATASET

Description: Db2 Message Library (SDSNSPFM). Max. length 44.

Default: blank (no default value)

Required: yes

DB2_PANELS_DATASET

Description: Db2 Panel Library (SDSNSPFP). Max. length 44.

Default: blank (no default value)

Required: yes

DB2_RUNLIB_DATASET

Description: Db2 runlib load library (RUNLIB.LOAD). Max. length 44.
Usually contains Db2 samples and/or utilities.

Default: blank (no default value)

Required: yes

Product Functionality Parameters

The following parameters determine product functionality for the Db2 subsystem you are currently defining.

ENABLE_PARALLEL_PROC_OF_DYNAMIC_SQL

Description: Enable parallel processing of Dynamic SQL? Max. length 1.
(Y=YES,N=NO)
This option will activate/deactivate Parallelism on this Db2 Subsystem.
Y (Yes) produces SET CURRENT DEGREE='ANY'.
N (No) produces SET CURRENT DEGREE='1'.

Default: blank (no default value)

Required: yes

DB2_ENABLE_PREDICTIVE_GOVERNOR_WARNING

Description: This parameter controls the execution when an SQLCODE +495 is returned. Max. length 1.
(Y=YES,N=NO)
This option allows you to specify how File-AID for Db2 should respond when Db2 executes an SQL statement that exceeds the limit set up by RLIMIT when the Db2 Resource Limit Facility is activated for a subsystem. Refer to the IBM Db2 documentation for more information on the Db2 Resource Limit Facility (governor).
Y (Yes) enables the predictive governor warning.
N (No) ignores the predictive governor warning and will execute the SQL statement.

Default: N

Required: no

DDF_INSTALLED

Description: (DDF = Distributed Data Facility). Max. length 1.
Y (Yes) or N (No).
Specifies that the subsystem is to be connected to other subsystems. If N, you will not be able to access other subsystems from this one (File-AID will disable Location ID entry). Also, set to N when SYSIBM.LOCATIONSdoes not exist.

Default: blank (no default value)

Required: yes

DB2_REMOTE_LOCATION_ID

Description: Db2 remote location identification for the Db2 subsystem. Max. length 16.

Default: blank (no default value)

Required: yes

DB2_TCPIP_PORT

Description: Port number for TCP/IP communication with Db2. Max. length 5

Default: 446

PLAN_NAME

Description: Default File-AID plan name to be used for this subsystem. Max. length 8.

Default: blank (no default value)

Required: yes

SUBSYSTEM_ENABLED

Description: Enable this Subsystem for use (Active subsystem). Max. length 1.
Set to Y (Yes) to indicates that this subsystem is active and available to be used with File-AID/RDX, File-AID for Db2, and File-AID Data Editor of the Workbench for Eclipse and Workbench for VS Code. This subsystem will be included in the Db2 subsystem list for “Create and Run Bind JCL” of Configuring-a-new-installation-of-File-AID-products and Configuring-File-AID-products-to-upgrade.
Specify N (No) to indicate that this subsystem is NOT active and NOT available for use with File-AID/RDX, File-AID for Db2, and File-AID Data Editor of the Workbench for Eclipse and Workbench for VS Code. This subsystem will NOT be included in the Db2 subsystem list for “Create and Run Bind JCL” of Configuring-a-new-installation-of-File-AID-products and Configuring-File-AID-products-to-upgrade.

Default: Y

Required: yes

CREATOR_NAME_FOR_CATALOG_TABLES

Description: Specify the Catalog Table Creator Name. Max. length 128. (Optional)

Default: SYSIBM

UNCOMMITTED_READ_DEFAULT

Description: Specifies the default value for the “Use Uncommitted Read” option field on the File-AID for Db2 Browse, Edit, Copy, and Extract screens and the File-AID/RDX Extract screens. Max. length 1. (Optional)
(Y=Yes, N=No, or blank).
Set to Y (Yes) to set the "Use Uncommitted Read" option field to YES upon entering any screen where this value can be set.
Set to N (No) to set the "Use Uncommitted Read" option field to NO upon entering any screen where this value can be set.
When blank, the "Use Uncommitted Read" option field will be set to the value stored in the user’s profile.
Users still have the ability to override the initial value.

Default: blank (no default value)

END

Description: Each SSID definition ends with an END parameter (see also DB2_ENVIRONMENT). There are no parameter values.

Default: N/A

Required: yes

DB2_BMC_AMI_LOAD_LOADLIB1

Description: BMC AMI load utility library

When this parm is specified, the BMC AMI DB2 load utility is used instead of the IBM DB2 load utility.

Default: Blank (Optional)

Required: Requires ECC PTF CXSJ36A to activate this feature.

DB2_BMC_AMI_LOAD_LOADLIB2

Description: BMC AMI load utility library

When this parm is specified, the BMC AMI DB2 load utility is used instead of the IBM DB2 load utility.

Default: Blank (Optional)

Required: Requires ECC PTF CXSJ36A to activate this feature.

SQL_INSERT_RETAIN_TEMPORAL_DATA

This parameter controls whether to retain the original system-period data in a system-period temporal table when you use the SQL Insert method for the Load function. If this parameter is set to Y and the Preserve Temporal field on the LOAD OBJECT SPECIFICATION panel is also set to Y, the product attempts to set the Db2 built-in variable REPLICATION_OVERRIDE (available in Db2 V12 FL503 and later) to Y during the insert process. The processing SQLID must have the authority to write this built-in variable.
Valid values: Y=Yes, N=No, blank=No
Default: N