Customizing the Site Options

Use Option 10 on the Full Installation menu to review and modify the Site Options. The Site Options panel can also be invoked from any of the following menus or panels:

• Option 6 on the main install menu.
• Option 0.0 on the main product menu (provided the user is authorized).
• OPTIONS SITE command on any panel during a user session (provided the user is authorized).

The following figure shows the first page of the default Site Options panel.

------------------------- FOPMDFLT Site Options -----------------------------
Command ===>                                               Scroll ===>  CSR

                                                               

************************************ TOP ************************************
Audit Mode                 ===> N         A-Always, N-Never, U-User
Load Utility to Use        ===> D         D-DB2 Load, B-BMC, U-User
Use Special Unload Utility ===> N         N-None, B-BMC, I-IBM, C|O-CDB
Unload Utility Strategy    ===> H         U-Unload Utility Only, H-Hybrid
Confirm on Deletes         ===> Y         Y-Yes, N-No
Submit Jobs with END       ===> Y         Y-Yes, N-No
Display DB2 Subsystem      ===> Y         Y-Yes, N-No
Selection List Format      ===> S         S-Short, F-Full, D-Desc
User Supplies Defaults     ===> U         A-Always, N-Never, U-User
NULL as Insert Default     ===> U         A-Always, N-Never, U-User
Table Lock Mode            ===> C         C-Can Not Lock, U-User
Editor Fetch Rows          ===> 1000      In Range (1 - 4294967295)
Maximum Compare Fetch Rows ===> 100000    In Range (1 - 4294967295)
Process Batch Compare Only ===> N         Y-Yes, N-No
Maximum Archive Rows       ===> 100000    In Range (1 - 4294967295)
Maximum Restore Rows       ===> 100000    In Range (1 - 4294967295)
***************************************************************************

The site options are:

Audit Mode

For Access only. Audit activity for edit sessions. Specify:

A

Activate the Audit Facility. Users are unable to deactivate it.

N

Deactivate the Audit Facility. Users are unable to activate it. Default.

U

Allow users to activate and deactivate, as desired.

Load Utility to Use

The load utility used for the Load process. Specify:

D

Use the DB2^® Load utility. Users cannot override. Default.

B

Use the BMC LOADPLUS utility. Users cannot override.

U

Allow users to use DB2 Load or LOADPLUS, as desired.

Use Special Unload Utility

The unload utility available when extracting data. Specify:

N

None. No special unload utility is available. Default.

B

The BMC UNLOAD PLUS utility is available.

I

The IBM^® High Performance Unload utility is available.

C|O

A CDB unload utility is available. Indicate the version by specifying C or O:

• C for CDB Auto-Unload; formerly known as Super Unload.
• O for CDB Auto-Online Unload; formerly known as RW-Unload.

Unload Utility Strategy

The strategy for using a special unload utility, when the response to Use Special Unload Utility is anything but N. Specify:

U

Use only the special unload utility. Exclusive use of the special unload utility allows a site to avoid overhead or contention that is possible using DB2.

H

Use the faster method, either DB2 or the special unload utility. This option is the default and allows a site to obtain the best performance.

Confirm on Deletes

Setting for user-enabled confirmation prompt on deletion of an Optim™ object. Specify:

N

Users cannot request confirmation prompt.

Y

User option allows user to request confirmation prompt. Default.

Submit Jobs with END

The default for a User Option to submit jobs while reviewing JCL and control statements for any batch job. Specify:

N

Users cannot submit job by using END. The SUBMIT command must be used to submit the job.

Y

Users can choose to submit job by using END.

Display DB2 Subsystem

The default for a User Option governing the display of the DB2 subsystem name on panels. Specify:

N

DB2 subsystem name is not displayed.

Y

DB2 subsystem name is displayed on every panel. Default. If connected to a remote subsystem, the DB2 subsystem name is replaced with the location of the remote subsystem.

Selection List Format

The information that is presented on a selection list of Optim objects. Specify:

S

Short format. Modification information is displayed with the object name. Default. (This is the display format used in figures throughout this documentation.)

D

Description is displayed with the object name.

F

Each entry is presented on two lines. The first line is the same as for Short format. The second line displays the description and the security status, if other than PUBLIC.

User Supplies Defaults

For Access only. Setting for user-supplied default values for columns with no DB2 default. Specify:

A

Always require user to supply a default value.

N

Never require user to supply a default value.

U

User determines whether to supply default values. Default.

NULL as Insert Default

For Access only. Indicator for blank column defined as nullable. Specify:

A

The NULL value is always supplied when inserting data.

N

The NULL value is never supplied.

U

User determines whether to supply the NULL value. Default.

Table Lock Mode

The table lock option for Insert, Restore, Delete or Archive with Delete Processes. Specify:

C

Users cannot lock tables. The prompt for locking tables for each process is always set to No and cannot be changed. This setting lets sites force the frequency of commits because the commit logic occurs only for tables that are not locked. Default.

U

Users can determine whether tables are to be locked for each process individually.

Editor Fetch Rows

The maximum number of rows that can be retrieved in one fetch set, when editing data, or browsing an extract or archive file, for example. This value can be from 1 through 4,294,967,295, and is displayed on the Editor and Display Options panel, where a lower limit can be specified. The default is 1,000.

Maximum Compare Fetch Rows

The maximum number of rows that can be fetched when browsing a Compare File. This value is displayed on the Compare Options panel where a lower limit can be specified. The default is 100,000.

Process Batch Compare Only

The batch processing default for Compare. Specify:

N

Allow users to execute Compare Processes online or in batch. Default.

Y

Perform all Compare Processes in batch.

Maximum Archive Rows

The maximum number of rows that can be archived in a single Archive Process. This value is displayed on the Specify ARCHIVE Parameters and Execute panel, where a lower limit can be specified. The default value is 100,000.

Maximum Restore Rows

The maximum number of rows that can be restored in a single Restore Process. The default value is 100,000.

Maximum Extract Rows

The maximum number of rows that can be extracted in a single process. This value is displayed on the Extract and Compare Specify Parameters and Execute panels, where a lower limit can be specified. The default value is 10,000.

Maximum Insert Rows

The maximum number of rows that can be inserted in a single process. For Extract Files that exceed this number, use the Load Facility. The default value is 10,000.

Maximum Delete Rows

The maximum number of rows that can be deleted in a single process. The default value is 10,000.

Maximum Online Archive Rows

The maximum number of rows that can be archived online in a single process. If this value is exceeded, the Archive Process must be executed as a batch job. This value cannot exceed the value in Maximum Archive Rows.

Maximum Online Restore Rows

The maximum number of rows that can be restored online in a single process. If this value is exceeded, the Restore Process must be executed as a batch job. This value cannot exceed the value specified in Maximum Restore Rows.

Maximum Online Extract Rows

The maximum number of rows that can be extracted online in a single process. (Does not apply to Archive Processes). If this value is exceeded, the Extract Process must be executed as a batch job. This value cannot exceed the value specified in Maximum Extract Rows.

Maximum Online Insert Rows

The maximum number of rows that can be inserted online in a single process. (Does not apply to Restore Processes). If this value is exceeded, the Insert Process must be executed as a batch job. This value cannot exceed the value specified in Maximum Insert Rows.

Maximum Online Delete Rows

The maximum number of rows that can be deleted online in a single process. If this value is exceeded, the Delete Process must be executed as a batch job. This value cannot exceed the value specified in Maximum Delete Rows.

Maximum Online Convert Rows

The maximum number of rows that can be converted online in a single process. If this value is exceeded, the Convert Process must be executed as a batch job.

Commit Frequency Rate

The maximum number of rows that can be processed before a commit. This value is displayed on the Specify Parameters and Execute panels for an Insert, Delete, or Restore Process and can be overridden with a lower number. The default value is 1,000.

Administrator Password

The password needed for Administrator privilege. A user has Administrator privilege if the value specified at the User Supplied Password prompt on the User Options panel matches this value.

At installation, the Administrator password is set to PSTDB2. It may be changed to any one- to eight-character value. A change to the Administrator Password automatically updates the User Password (of the same value) for the current user.

Trace SYSOUT Job Class

The location where output from the diagnostic trace is to be printed. The trace should be executed only when requested by IBM Technical Support to help diagnose and resolve problems.

Object Security Suffix

The two-character suffix, to be appended to FOP2OS to indicate the name of the exit called for object security. Clear Object Security Suffix to disable object security, or change the suffix appropriately to use a different exit.

If you change the object security suffix, it will take effect immediately. The security exit is loaded when a session is invoked or the suffix is changed. (See Object Security.)

Object Security Mode

An indicator for the display and user assignment of security attributes. (This setting is valid only if you are using object security.) Specify:

N

Do not display security attributes. The user cannot assign the security status. Default.

Y

Display security attributes. The user can assign the security status explicitly. Security attributes may be displayed on the Object Attributes panel, selection lists, and object information panels.

Default Security Status

The default security for a new object. (This setting is relevant only if Object Security Mode is Y.) Specify:

P

For PUBLIC. Allow any user to access, edit, or delete an object. Default.

R

For READ-ONLY. Allow any user Read-only access to an object.

V

For PRIVATE. Allow only the object owner or administrator to access an object.

Archive Security Suffix

The two-character suffix, to be appended to FOP2AS to indicate the name of the exit called for archive security. For Archive only. To use a different exit, change the number appropriately or, to disable archive security, clear Archive Security Suffix.

If you change the archive security suffix, the change takes effect immediately. The security exit is loaded when a session is invoked or the suffix is changed. (See Archive Security.)

Archive Security Mode

An indicator for the display and user assignment of security attributes. (This setting is valid only if you are using Archive security.) Specify:

N

Do not display security attributes. The user cannot assign the security status. Default.

Y

Display security attributes. The user can assign the security status explicitly. Security attributes may be displayed on the Object Attributes panel, selection lists, and object information panels.

Archive Default Security

The default security status to assign to a new Archive File. (This setting is relevant only if Archive Security Mode is Y.) Specify:

P

PUBLIC. Allow any user to read, modify, or delete an Archive File. Default.

R

READ-ONLY. Allow any user Read-only access to an Archive File.

V

PRIVATE. Allow only the owner or administrator to access an Archive File.

Functional Security Suffix

The two-character suffix, to be appended to FOP2FS to indicate the name of the exit called for external function security. If blank, functional security is not enabled.

If you change the functional security suffix, the change takes effect immediately. The security exit is loaded when a session is invoked or the suffix is changed. (See Functional Security.)

Temp DASD Unit, Primary

The primary location of temporary work files created during a process. Specify a valid unit name or VIO, which is the default value. Offline tape units cannot be specified. Primary and secondary Temp DASD specifications are validated by performing a test allocation. If neither primary nor secondary allocations can be made during a session, SYSDA is used.

Temp DASD Unit, Secondary

The secondary location of temporary work files. Specify a valid unit name or SYSDA, which is the default value. Primary and secondary Temp DASD specifications are validated by performing a test allocation. If neither primary nor secondary allocations can be made during a session, SYSDA is used.

Default Aging Rule Table

The name of the default Aging Rule Table. This table is used whenever an explicit default Aging Rule Table is not defined for an Insert, Convert, or Load process. The distributed default is FOP2RUSA.

Change Line Characters

Edit the characters used to create borders around pop-ups. Specify:

N

Retain current or default settings for characters used to delineate pop-ups. Default.

Y

Display prompts to change characters used to delineate pop-ups.

Review Del After Archive

Indicator for user review of names of tables marked for deletion after archiving. Specify:

N

Users cannot review tables after archiving and before deleting.

Y

Users can review tables after archiving but before deleting. Default.

Restore Processing Option

Indicator for user-chosen insert or update during a Restore Process. Specify:

S

Allow users to choose a Restore processing option. Default.

I

In a Restore process, all data rows are inserted. Restoring data rows that exist at the destination causes errors.

U

In a Restore process, rows can be updated or both updated and inserted, according to the If Update, Process Mode option.

If Update, Process Mode

The processing mode when the Restore Processing Option is U. Specify:

B

All data rows are updated if they exist. Rows that do not exist are inserted. Default.

U

All data rows are updated. Any rows not found are considered errors.

Restore after Table Change

The action taken when data is restored to a table for which attributes have changed since the data was archived. Specify:

N

None. Restore proceeds.

I

An informational message is displayed and the Restore proceeds.

F

Restore fails.

U

User is prompted to continue or abort. Default.

Use DB2 LOB Defaults

The LOB tablespace used by the Create Process when creating an auxiliary table. Specify:

N

User must create tablespace explicitly.

Y

Use DB2 default LOB tablespace.

U

User can specify the type of LOB tablespace on the User Options panel. Default.

Allow Dual Archive Output

Indicator for writing an Archive File to more than one output. Specify:

N

Do not allow user to specify more than one output.

Y

Allow user to specify more than one output. Default.

Tape VOLSER required

Indicator for a volume serial number for Archive File tape processing. Specify:

N

No volume serial number is required.

Y

Volume serial number is required. Default.

Change Archive Logging

Settings for Archive Logging. Specify:

N

Do not display the Archive Logging Operations pop-up. Logging settings remain as specified previously. Default.

Y

Display the Archive Logging Operations pop-up. Use Y to enable logging or N to disable logging for each listed operation.

Remote DB2 Connection

Indicator for remote connections. Specify:

A

Application-directed connection (that is, DRDA^®). The application must issue the SQL CONNECT statement to connect to the remote location. Default.

S

System-directed connection (that is, DDF). The system connects to the remote location based on a three-part name or an alias of that name, in which one part names the location.

Replace Arch Dir in Batch

Batch Archive processing when an entry for the Archive File exists. Specify:

N

Halt process with error message.

Y

Proceed with process, replacing Archive File entry in Directory.

U

Enable User Option to determine processing when entry exists. Default.

Target Rows Del Before Isrt

Indicator for delete before Move insert processing. Specify:

N

Users cannot delete target rows before insert or specify commit frequency. These options are omitted from the Specify INSERT Parameters and Execute panel.

Y

Users determine whether to delete target rows before insert, and specify the commit frequency. Profiled values are displayed. Default.

I

Users can determine whether to delete target rows before insert, and can specify the commit frequency. Profiled values are not displayed.

Maximum Data Space Blocks

The maximum size of each data space in 4K blocks. This value can be from 500 through 524,288. The default value is 524,288. If this value exceeds limits imposed by system defaults or the IEFUSI exit, data space creation fails and a system error occurs. (For information on these error codes, refer to your IBM documentation for the DSPSERV macro.)

Maximum Data Spaces

The maximum number of data spaces created by the temp database. This value can be from 1 through 10. The default value is 10. If this value exceeds limits imposed by system defaults or the IEFUSI exit, data space creation fails and a system error occurs. (For information on these error codes, refer to your IBM documentation for the DSPSERV macro.)

Compare Row Contents

Indicator for comparing rows of data in the Source File with rows in the database prior to deletion. Specify:

A

Rows are deleted from the database only if they exactly match rows in the Source File.

N

Row comparison is not performed during the Delete Process. If a table does not have a DB2 primary key or an Optim primary key with a unique index, the Delete Process always compares row contents prior to deletion.

U

User can determine whether rows are compared prior to the Delete Process. Default. If a table does not have a DB2 primary key or an Optim primary key with a unique index, the Delete Process always compares row contents prior to deletion.

Enable Rels Prefetch

Indicator for whether all relationships for a Creator ID are retrieved. Specify:

N

Retrieve only those relationships in which the base table participates.

Y

Retrieve all defined relationships for the specified Creator ID at the first lookup request. Default.

Change Storage Options

Indicator to configure options that allow you to store Archive Files on a Centera networked storage system or Tivoli^® Storage Manager backup device. Specify:

N

Do not display the Storage Site Options pop-up. Default.

Y

Display the Storage Site Options pop-up. When you close the Storage Site Options pop-up, Change Storage Options reverts to N.

Ignore Generic Rels

Option for ignoring generic relationships to increase performance. Specify:

A

Do not use generic relationships to retrieve data.

N

Use generic relationships to retrieve data from related tables.

S

Use generic relationships to retrieve data, only if the Creator ID is the same for both the parent and child tables.

U

Allow user to set a User Option to determine whether generic relationships should be ignored.

Specify Arc File Retention

Indicator for specifying a retention period for Archive Files. You cannot delete or overwrite an Archive File, its associated Archive Directory entry, or any associated Archive Index File until after the specified retention period.

N

No retention period is assigned.

Y

Assign a retention period to Archive Files, according to the If Y, Retention Period option.

U

Allow the user to specify a retention period for an Archive File on the Specify ARCHIVE Parameters and Execute panel.

Note: You can alter the retention period assigned to an Archive File, or add a retention period to an existing Archive File, using the ALTER statement of the IBM Utility program, IDCAMS, to set the expiration date parameter of the z/OS^® file. Archive automatically recognizes any change to the retention period.

If Y, Retention Period

The retention period for Archive Files when Specify Arc File Retention is Y. If blank, the profiled value is used. If there is no profiled value, a default value of 1Y (one year), is assigned. Specify one of the following:

nD

The number of days to retain the Archive File.

nY

The number of years to retain the Archive File.

yyyy-mm-dd

An explicit date, after which you can delete or overwrite the Archive File.

Note: Any Archive File assigned a retention period over 9999 days or 27 years is considered permanent and can be deleted or overwritten only if you reduce the retention period using the ALTER statement of IDCAMS.

Defer Auth-Check for Batch

Options to defer authorization checks on objects during the creation of JCL and control statements for batch Extract and Archive Processes. Specify:

N

Use authorization checks in batch.

Y

Defer authorization checks in batch.

U

Allow the user to set a User Option to determine whether authorization checks are deferred in batch.

Default Defer DAA

Default value for Defer Delete After Archive on the Specify ARCHIVE Parameters and Execute panel. Specify:

N

Set the default value to No.

Y

Set the default value to Yes.

Use Uncommitted Reads

Option to extract uncommitted data from the database during an Archive or Extract Process. Specify:

N

Do not extract uncommitted data from the database. Default.

Y

Always extract uncommitted data from the database. If you choose to archive or extract uncommitted data, the relational integrity of the data in the Archive or Extract File may be compromised. Use caution if inserting data from any Archive or Extract File with uncommitted data.

U

User can determine whether uncommitted data is extracted during an Archive or Extract process. The Archive/Extract With Uncommitted Reads option is enabled on the Specify ARCHIVE/EXTRACT Parameters and Execute panel.

Allow Mismatched CCSIDs

The action taken when the CCSID of a source column does not match the CCSID for the destination column, or the terminal CCSID does not match that of the DB2 subsystem. Specify:

N

Terminate the process if mismatched CCSIDs are encountered. Default.

Y

Continue the process, which will fail if CCSIDs are incompatible.

U

The User Option Allow Mismatched CCSIDs determines the action taken. See Allow Mismatched CCSIDs in the Common Elements Manual.

Generate USEDD Parm in JCL

The action taken in a batch Insert, Restore, Load, Convert or Delete process when the USEDD keyword is encountered. Specify:

N

Do not generate DD cards. Default.

Y

Generate the DD cards for the file.

Legacy MIXED Data

The use of code points X'0E' and X'0F' as shift-out and shift-in controls for double-byte character strings in legacy data. Specify:

Y

Character strings can be single-byte character set (SBCS) or MIXED data with X'0E' and X'0F' serving as shift-out and shift-in controls. The CCSID that is specified in the Legacy EBCDIC CCSID field must be the mixed CCSID for the encoding scheme. During processing, this value determines the associated SBCS and double-byte character set (DBCS) CCSIDs for the encoding scheme. A valid entry in Legacy EBCDIC CCSID is required.

N

All character strings in Legacy data are processed as SBCS data.

U

Legacy MIXED DATA and Legacy EBCDIC CCSID values are obtained from the Legacy Options panel, available to all users.

Legacy EBCDIC CCSID

The default CCSID for EBCDIC-encoded character data in your Legacy data. Required if Legacy MIXED DATA is set to 'Y'. Specify a value from 1 - 65533.

New Rels Warning in Batch

Behavior when relationships are found to be in NEW status during a batch Extract or Archive process. Specify:

N

No message or return code is produced when relationships are in NEW status.

Y

A message and return code 4 is produced when relationships are in NEW status.

Enable IMS I/O Exit

Indicator for use of an IMS™ I/O Exit when a segment is read or written. Specify:

N

No I/O exit is used. Any exit specified in Exit Name and in Legacy Table definitions is ignored. Default.

Y

The exit specified in Exit Name is called when an IMS segment is read or written. Any exit specification in a Legacy Table definition is ignored.

U

An exit specified in a Legacy Table definition, if any, is called. If the Legacy Table definition does not reference an exit, the exit specified in Exit Name is called.

Exit Name

The name of the default I/O exit. FOPIMIOX, the exit distributed with your Optim solution, is specified by default.

Enable VSAM/Seq I/O Exit

Indicator for use of an I/O Exit when a VSAM or sequential record is read or written. Specify:

N

No I/O exit is used. Any exit specified in Exit Name and in Legacy Table definitions is ignored. Default.

Y

The exit specified in Exit Name is called when a record is read or written. Any exit specification in a Legacy Table definition is ignored.

U

An exit specified in a Legacy Table definition, if any, is called. If the Legacy Table definition does not reference an exit, the exit specified in Exit Name is called.

Exit Name

The name of the default I/O exit. FOP2DIOX, the exit distributed with your Optim solution, is specified by default.

Resolve DB2 Rel Change

For batch execution of extract and archive processes, determines whether Optim rebuilds any DB2 relationship if the columns in the relationship have changed since the time when the relationship was originally defined. Specify:

Y

Yes. Rebuild a DB2 relationship if the columns have changed.

N

No. Do not rebuild a DB2 relationship if the columns have changed. If an extract or archive process encounters a relationship with columns that have changed, it will fail with a return code of 12. This is the default

U

User. Allow the user to specify whether or not a DB2 relationship is rebuilt if the columns have changed.

Register DASD Extract File

Allow users to register extract files stored on disk in the Optim directory. Specify:

Y

Yes. Allow user to register an extract file.

N

No. Do not allow extract files stored on disk to be registered in the Directory. This is the default.

U

User. Enable user option to allow the user to register an extract file on disk in the Directory.

Replace Extr Dir in Batch

Batch extract file processing when an entry for this extract file exists in the Directory. Specify:

Y

Yes. Allow processing to continue and replace any existing extract file entry.

N

No. Halt processing with an error message. This is the default.

U

User. Allow user the option to enable user to determine processing when there is an existing Directory entry for the extract file.

Require IMS Data Set Names

Controls whether or not the user is required to supply the name of an IMS database data set when creating a Retrieval Definition.

Y

Yes. User must supply IMS data set name. This is the default.

N

No. User is not required to supply an IMS data set name. If the field for IMS data set name is left blank, IMS dynamically allocates the data set.

Note: Regardless of the setting for this option, all users can enable IMS to dynamically allocate the data set by specifying '$MDA' as the data set name.

Change Optim Data Privacy

Determines the environment variable file used for data privacy providers:

Y

Yes. Set a site default environment variable file that applies to all users. The Site Data Privacy Options panel displays and prompts you to enter the name of the data set for the Unix System Services environment variables.

N

No. No default environment variable file is set.

U

User. Allow users to specify the name of the environment variable file on the User options panel.