This service is used to define the Adabas Fastpath optimization parameters.
Selecting option code 1
from the main menu or
entering the command 1 on the
command line displays the Parameter Maintenance menu.
18:21:37 ***** A D A B A S FASTPATH SERVICES 7.4.2 ***** 2003-02-30 - Parameter Maintenance - F11000M1 Code Service ---- ----------------- 1 Buffer Parameters 2 File Parameters 3 Job Parameters . Exit ---- ----------------- Code ..: _ Command ==> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12 Help Exit Menu |
Select an option code to invoke the corresponding menu for the type of parameters to be defined/modified:
Note:
Before proceeding, you may wish to review the section
Adabas Fastpath Parameters
which provides a complete list and description of each parameter type.
Selecting option code 1
from the Parameter
Maintenance menu or entering 1.1
on a command line displays the Maintain Buffer Parameters screen.
The currently defined Adabas Fastpath buffers are listed.
For an existing buffer, you can enter any of the option codes described below.
You can use PF10 to add a new buffer definition as described in section Adding a New Buffer.
12:36:27 ***** A D A B A S FASTPATH SERVICES 7.4.2 ***** 2003-05-15 - Maintain Buffer Parameters - F11100M1 <----- Buffer -----> Coordinator Size Direct Read- C Name SVC DBID Group (k) Access ahead Comments _ AFPDAEF 255 11001 AFPGROUP 4096 ON ON _ AFPDA2F 255 11002 AFPGROUP 4096 ON ON _ AFPDA3F 255 11003 AFPGROUP 4096 ON ON _ V742ME01 244 7421 V742GR01 8192 ON ON _ V742ME02 244 7422 V742GR01 4096 ON ON Mark with D(isplay),M(odify),P(urge),R(ename),C(opy),F(iles) End of List Command ==> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12 Help Exit Refr Add Menu |
The following information is provided:
C | Option code (D: display buffer parameters, M: modify buffer parameters, P: purge buffer, R: rename buffer, C: copy buffer, F: file parameters, E: expand to show member buffers). For more information on the Modify function, see Modifying Buffer Parameters. |
Name SVC DBID | The buffer name, the Adabas SVC used by this buffer, and the database used by this buffer. |
Coordinator Group | The name of the Adabas System Coordinator group in which this buffer is to be a member. Adabas Fastpath buffers operate as members of an Adabas System Coordinator group. |
Size | The memory size for this buffer. |
Direct Access | Indicates whether or not direct access optimization is to be used for this buffer. |
Read Ahead | Indicates whether or not read-ahead optimization is to be used for this buffer. |
To add a new buffer, press PF10 on the Buffer Parameter Maintenance screen. The following screen appears:
11:59:24 2003-05-15 Add Buffer F11110MB Size(k) : 4096 System Coordinator Group Name : V742GR01 Member Name: X742ME03 (Leave empty to select) Command ==> PF1 Help PF3 Exit PF5 Add |
You must provide values for the following fields:
Size | The size of the buffer to be added. |
Group Name | The name of the Adabas System Coordinator group in which this buffer is to be a member. Adabas Fastpath buffers operate as members of an Adabas System Coordinator group. The group must have already been defined using Adabas System Coordinator Online Services. |
Member Name | The member name is the job name of the Adabas System Coordinator daemon under which this buffer is to operate. The member name may have already been defined. If not you will be prompted to define it by entering the unique Node ID by which this member is to be identified. |
Buffers are added with default parameters. After a buffer has been
added, you can view/modify all the default settings by using the
d
or m
option code on the
Maintain Buffer Parameters screen. The following sample screen lists the
general parameters for buffer V742ME01.
12:08:05 ***** A D A B A S FASTPATH SERVICES 7.4.2 ***** 2003-05-15 - Buffer V742ME01 - F11120MA System Coordinator Group Name: V742GR01 Member Name: V742ME01 Adabas SVC Number: 244 Designated DBID: 7421 Last Modified: 2003-05-12 By User ID: UKSJU Last Buffer Address: 00000000 Length: 00000000 Session: 0 ----------------------------- General Parameters ----------------------------- Size(k): 8192 Minimum Buffer Size(k): 0 Maximum Jobs: 12 Set ID Length Limit: 1024 RB Length Limit: 2048 Read-ahead Memory Sizes(k): 4 8 16 32 Command ==> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12 Help Exit Upd File More Menu |
You can use this screen to review and, if necessary, modify any of these buffer parameters.
Refer to section Adabas Fastpath Parameters for a description of each of these parameters.
By pressing PF11, you can display the detail parameters for this buffer:
12:09:42 ***** A D A B A S FASTPATH SERVICES 7.4.2 ***** 2003-05-15 Buffer V742ME01 F11120MB Adabas SVC Number: 244 Designated DBID: 7421 Last Modified: 2003-05-12 By User ID: UKSJU Last Buffer Address: 00000000 Length: 00000000 Session: 0 ------------------------- Detailed Parameters -------------------------------- Set Expansion: 8 Set Concurrency: 2 Freespace Index: 512 Average Item Size: 256 Log every n Minutes: 60 Keep for n Days: 30 Autorestart: Y Restart every n Hrs: 0 ------------------------ Global Operational Control -------------------------- Direct Access: ON FIND Sx/L1: ON Read-ahead: ON READ PHYSICAL L2: ON READ LOGICAL L3: ON HISTOGRAM L9: ON Command ==> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12 Help Exit Upd File Prev Menu |
You can use this screen to review and, if necessary, modify any of these buffer parameters.
Refer to section Adabas Fastpath Parameters for a description of each of these parameters.
For each Adabas Fastpath buffer, file parameters can be defined which indicate for exactly which databases/files optimization is to be performed. You can access the File Parameters maintenance function:
from the Parameter Maintenance screen after specifying a previously defined buffer; or
from any Buffer Maintenance screen.
By pressing PF10 on either of these buffer modify screens, you can access the File Optimization Parameters screen.
8:21:37 ***** A D A B A S FASTPATH SERVICES 7.4.2 ***** 2003-02-30 - File Optimization Parameters for: Global AFP311A - F11200MA Reposition Start End Update DBID: _____ C DBID File SVC Time Time Sensitivity File: _____ _ 11 7 254 Record _ 12 7 254 Record _ 13 7 254 Record _ 14 7 254 Record _ 71 7 254 Record _ 111 66 254 12:00 16:00 Record _ 193 1 Record _ 193 2 Record _ 193 3 Record _ 193 4 Record _ 193 5 Record _ 193 7 254 Record Mark with D(isplay),M(odify),P(urge),C(opy) Top of List Command ==> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12 Help Exit Refr Fwd Bot Add Menu |
This screen lists, for the specified Adabas Fastpath buffer, all databases and files curently defined for Adabas Fastpath optimization.
Note:
You can use the Repostion function to position to a specific
database/file in the list.
Field | Description |
---|---|
C | Option code (D: display file parameters, M: modify file parameters, P: purge file parameters, C: copy file parameters). |
DBID | Adabas Database ID. |
File | Adabas File Number. |
SVC | Adabas SVC. |
Time | The specific time period during which Adabas
Fastpath optimization is to be in effect. See parameter
Start
Time .
|
Update Sensitivity | Controls how Adabas update commands are to be
processed. See parameter Update
Sensitivity .
|
In the File Optimization Parameters screen, use PF10 to add a new file parameter. The following screen will appear:
12:30:07 2003-05-15 F11210M1 Add File Optimization Parameter Buffer Name: V742ME01 File: 0 (0 = DB default) in DBID: _____ using SVC: _____ (Optional) Optional Time Window Start(HH:MM): _____ End: _____ (Leave empty for 24 hours) Command ==> PF1 Help PF3 Exit PF5 Add |
File | The Adabas file number for which Adabas Fastpath
optimization is to be defined.
Note: |
in DBID | The Adabas database in which the file to be optimized is located. |
using SVC | The Adabas SVC number.
Note: |
Time Window | Optimization is only to be in effect within the
specified time window. See parameter
Start
Time .
|
After a file parameter is added, the File Parameters Maintenance screen can be used to define further optimization parameters which are to be in effect for the file. This is described in the following section.
The File Parameters Maintenance function can be invoked by/from:
automatically from the Add File Parameters function
by using option code m on the File Parameter Selection screen
from an AFPLOOK File Display screen or from the File Set Summary List screen by pressing PF4 . Similarly, hot keys on this screen can be used to access AFPLOOK and File Set Summary.
by entering 1.2 on a command line anywhere in the system, provided that a database and file number have previously been established using this screen or one of the other functions in the hot key chain.
The following screen appears:
15:52:22 ***** A D A B A S FASTPATH SERVICES 7.4.2 ***** 2003-02-04 - File Optimization Parameters for: Global SYSCO33 - F11220MA File: 7 DBID: 198 SVC: 254 Last Modified: 2003-02-20 by: UKYCL Start Time (HH:MM): 06:30 End Time: 17:30 Update Sensitivity: R Record Initial Status: ON Set Limit (k): 0 Set Expansion: 0 Set Id Length Limit: 0 RB Length Limit: 0 Set Concurrency: 0 Expanded File: N Synchronous Remote Updates:N --------------------- Optimization Summary ----------------------------------- Direct Access + Read-ahead L1 Get/Read by ISN ON | L1 Read by ISN ON L3 Read Logical ON | L2 Read Physical ON L9 Histogram ON | L3 Read Logical ON S1 Find Records ON | L9 Histogram ON S2 Find Sorted ON | S1 Find Records ON | S2 Find Sorted ON | S8 Process ISN List ON | S9 Sort ISN List ON PF10 to Modify Direct Access + PF11 to Modify Read-ahead Command ==> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12 Help Exit Upd Look File Dir R-a Menu |
The following parameters can be maintained using this screen:
Parameter | Description |
---|---|
Start Time, End Time |
Optimization is only to be in effect within the specified time
window. See parameter Note: |
Update Sensitivity | Indicates how Adabas Fastpath is to process
commands which result in database updating. The following values are permitted:
N (none). Ignore all update commands. |
Initial Status | By setting this field to OFF, you can indicate that the file parameters being defined are not to be activated until this field is changed to ON. |
Set Limit | Adabas Fastpath creates sets of direct access command models. This parameter limits the size (in k) of data items within a set. |
Set Expansion |
These parameters can be used to decrease (but not increase) the values of the equivalent buffer parameters. These parameters are described in section Adabas Fastpath Parameters. |
Expanded File | This field must be set to Y if the file is defined to Adabas
as an expanded file. If so, direct access optimization cannot be defined for
L3/L9 commands.
|
Synchronous Remote Updates | Controls the mode used for sychronizing updates. See the
parameter Synchronous Remote
Updates .
|
Optimization Summary |
The current direct access and read-ahead optimization settings for each Adabas command used for this file. Optimization can be defined for the following commands:
Note: |
Use PF5 to commit all changes. Use PF3 to exit without applying any changes.
Use PF10 and PF11 to modify the direct access and read-ahead optimization parameters as described in the following sections:
The following screen is displayed when you press PF10 from the File Optimization Parameters screen:
16:12:41 ***** A D A B A S FASTPATH SERVICES 7.4.2 ***** 2003-02-04 - File Optimization Parameters for: Global SYSCO33 - F11220MB File: 7 DBID: 198 SVC: 254 Last Modified: 2003-02-04 By: UKDEV1 Start Time (HH:MM): 06:00 End Time: 19:30 Update Sensitivity: R Record Initial Status: ON Set Limit (k): 0 Set Expansion: 0 Set Id Length Limit: 0 RB Length Limit: 0 Set Concurrency: 0 Expanded File: N --------------------- Direct Access Optimization ----------------------------- On/Off Except for: Field level overrides L1 Get/Read by ISN ON L3 Read Logical OFF Now Optimizes AA AB __ __ __ __ __ L9 Histogram OFF __ __ __ __ __ __ __ S1 Find Records ON Now Excludes BB __ __ __ __ __ __ S2 Find Sorted OFF __ __ __ __ __ __ __ PF11 to Modify Read-ahead Command ==> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12 Help Exit Upd Look File Back R-a Menu |
Field | Description |
---|---|
Command | Adabas read or query command
(L1/L3/L9/S1/S2 ).
|
On/Off | Indicates whether or not optimization is to be
in effect for the command. In the screen example, L1
commands (all fields), L3 commands
(for fields AA nd AB only) and S1 commands
(excluding S1 commands in which field BB is used as
the primary descriptor) are to be optimized. The default is OFF.
|
Except for | The comments Now Optimizes and Now Excludes are displayed when the Enter key is pressed to illustrate the effect of field level overrides. |
Field level overrides | Used to include/exclude certain fields from
optimization. In the screen example, L1 commands
(all fields), L3 commands (fields AA nd AB only) and
S1 commands (excluding field BB) are to be
optimized.
|
Use PF5 to commit all changes. Use PF3 to exit without applying any changes.
The following screen is displayed when you press PF11 from the File Optimization Parameters screen:
16:25:22 ***** A D A B A S FASTPATH SERVICES 7.4.2 ***** 2003-02-04 - File Optimization Parameters for: Global SYSCO33 - F11220MC File: 7 DBID: 198 SVC: 254 Last Modified: 2003-02-04 by: UKDEV1 Start Time (HH:MM): 06:00 End Time: 19:30 Update Sensitivity: R Record Initial Status: ON Set Limit (k): 0 Set Expansion: 0 Set Id Length Limit: 0 RB Length Limit: 0 Set Concurrency: 0 Expanded File: N --------------------- Read-ahead Optimization -------------------------------- On/Off Except for: Field level overrides L1 Read by ISN ON L2 Read Physical ON L3 Read Logical OFF Now Optimizes AA __ __ __ __ __ __ L9 Histogram OFF __ __ __ __ __ __ __ S1 Find Records ON Now Excludes CC __ __ __ __ __ __ S2 Find Sorted OFF __ __ __ __ __ __ __ S8 Process ISN List OFF S9 Sort ISN List OFF PF10 to Modify Direct Access Command ==> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12 Help Exit Upd Look File Dir Back Menu |
Field | Description |
---|---|
Command | Adabas read or query command
(L1/L2/L3/L9/S1/S2/S8/S9 ).
|
On/Off | Indicates whether or not Adabas Fastpath
optimization is to be in effect for the command. In the screen example,
L1 commands, L2 commands,
L3 commands (only when field AA is used as the
primary descriptor) and S1 commands (excluding
S1 commands in which field CC is used as the primary
descriptor) are to be optimized. The default is OFF.
|
Except for | The comments Now Optimizes and Now Excludes are displayed when the Enter key is pressed to illustrate the effect of field level overrides. |
Field level overrides | Used to include/exclude certain fields from
optimization. Field overrides are not applicable for
L1/L2 commands. In the screen example,
L1 commands, L2 commands,
L3 commands (only when field AA is used as the
primary descriptor) and S1 commands (excluding
S1 commands in which field CC is used as the primary
descriptor) are to be optimized.
|
Use PF5 to commit all changes. Use PF3 to exit without applying any changes.
Selecting option 3
from the Parameter
Maintenance screen or entering 1.3
on a command line
displays the Maintain Job Parameters screen:
12:38:54 ***** A D A B A S FASTPATH SERVICES 7.4.2 ***** 2003-05-15 - Maintain Job Parameters List - F11300M1 <-Reposition-> Type: ________ System Coordinator Name: ________ C Job Type Job Name (Buffer) Group Name Comment Time period _ Batch V742DA2F AFPGROUP _ V742DA3F AFPGROUP _ V742JB01 V742GR01 _ V742JB02 V742GR01 _ V742JB03 V742GR01 _ CICS Cluster CICS0414 MROJOB01 _ CICS0514 V742GR01 _ DAEFCIUK V742GR01 _ TSO *DEFAULT BIGBUFF _ TIAM TESTTIAM BIGBUFF Mark with D(isplay),M(odify),P(urge),R(ename),C(opy) End of List Command ==> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12 Help Exit Refr Top Back Add All Menu |
The following information is provided:
Field | Description |
---|---|
C | Option code (display, modify, purge, rename, copy). For more information on the Modify function, see Maintaining Job Parameters. |
Job Type | The job type. |
Job Name | The job name. |
Group Name | The name of the Adabas System Coordinator group in which this buffer is a member. |
Time period | Optimization for this job is only to be in
effect within the specified time window. See parameter
Start
Time .
Note: |
Press PF8 to move to the next page, or enter the "Reposition Type and Name" to position anywhere within the list.
Press PF10 to add a new job.
Press PF11 to list all defined job parameters including those for Adabas Transaction Manager (ATM) and Adabas Vista (AVI).
When you press PF10 on the Maintain Job Parameters screen, the following window is displayed for adding a new job definition:
09:21:16 Add 2003-05-16 Job Parameters F11310MC Job Name: KM27WD__ (D = Default for Job Type) X Batch _ COM-PLETE _ CICS Cluster _ CICS _ IMS/DC _ UTM _ TSO _ CMS _ TIAM _ None above Mark to Select a Job Type Command ==> PF1 Help PF3 Exit |
Job Name | The job name.
Note: Note: |
Job Type | The job type. Each different job type has a
different characteristic so it is important to select the correct type.
Note: Note: |
Once you select a job type, the corresponding screen for that job type will appear. In this example, a batch type job is being defined.
09:21:41 Add 2003-05-16 Job Parameters F11310M1 Job Type: Batch Job Name: KM27WD (D = Default for Job Type) Fastpath ON/OFF for Job: ON Buffer Group Name: SYSCO33 Leave empty to select) Optional Time Window Start(HH:MM): _____ End: _____ (Leave empty for 24 hours) ----------- Daemon Mode ------------ (Usually for Clustered Applications) Service Name: ________ Coordinator Group Name: ________ Command ==> PF1 Help PF3 Exit PF5 Add |
Job Type / Job Name | The job type and job name. |
Fastpath ON/OFF | Indicates whether or not optimization is to be in effect for this job. |
Buffer Group Name | The name of the Adabas Fastpath buffer to be used by this job. |
Optional Time Window |
Optimization is to be in effect for this job only if the job is started within the time window specified. Time windows are checked when a job starts. If the job starts
Once started, optimization continues until the end of job; there is no check at the end time. It is therefore recommended that a time window is not used for TP monitors or other long running jobs. Note: |
Service Name |
The job types CICS Cluster, IMS, and UTM are considered to be clustered applications and must be accompanied by the Coordinator Group Name and Clustered Application Service Name. To select an existing Coordinator Group Name from a list, press PF1 with the cursor in the field. |
Normally, the absence of job parameters implies that optimization is not applied. Thus, you can implement optimization gradually by defining only specific jobs to receive optimization.
Alternatively, this can be reversed. Default job parameters can be created so that optimization is applied to all jobs of a specific category. Then, you can specify only the jobs that are not to be optimized and those that differ from the default.
Note:
A specific job definition overrides any wild card job definitions or
any default definition.
To maintain job parameters, on the Maintain Job Parameters screen,
enter the option code m
next to the job for which
parameters are to be maintained. In the sample screen shown below, the job
parameters for batch job KM27WD are displayed.
The following screen will be displayed:
17:44:06 ***** A D A B A S FASTPATH SERVICES 7.4.2 ***** 2003-05-16 - Job Parameters - F11320M1 Job Name: KM27WD Last Modified: 2002-05-28 Job Type: Batch by Userid: UKSJU System Coordinator (Buffer) Group Name.: SYSCO33 Start Time(HH:MM)...: End Time(HH:MM): Job End Stats.......: N Direct Access..: ON Read-ahead Optimization Control: BAT Command Time...: 00000000 Read-ahead Memory Limit(k).....: 0 Command ==> Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12 Help Exit Upd More +Prod Menu |
Parameter | Description |
---|---|
Start Time / End Time |
Optimization is to be in effect for this job only if the job is started within the time window specified. Time windows are checked when a job starts. If the job starts
Once started, optimization continues until the end of job; there is no check at the end time. It is therefore recommended that a time window is not used for TP monitors or other long running jobs. Note: Note: |
Job End Statistics | If Y is specified, Adabas Fastpath performance information will be sent to the operator console when a job ends. |
Direct Access | If OFF is specified, no direct access optimization will be performed for the job, without regard to other parameters. |
Read-Ahead Optimization Control | If OFF is specified, no read-ahead optimization will be performed. In addition, you can choose between the read-ahead factor algorithms for TP monitors (TP) or for batch (BAT). While both algorithms accelerate the factor as the sequence length increases, the batch algorithm accelerator is faster than the one for TP monitors. Normally, the default setting is the most efficient. |
Read-Ahead Memory Limit | Used to restrict the memory allocated to the job for read-ahead optimization. |
Press PF10 to maintain the related Adabas System Coordinator parameters as follows:
17:48:02 System Coordinator Parameters 2003-05-16 U1SCJPM1 Estimated Client Sessions : 2 Fixed Memory Pool Size(k): 256 Managed by Daemon........................: N (Y/N) Daemon Group Name....................: ________ Clustered Application Service Name...: ________ Daemon manages Terminal Sessions only: X or manages All Sessions.........: _ Mark One PF1 Help PF3 Exit PF5 Upd |
The following parameters apply to all job types:
Parameter | Description |
---|---|
Estimated Client Sessions | Determines the size of the Adabas System Coordinator user pool. |
Fixed Memory Pool Size(k) | Determines the size of all fixed memory pools. |
The following parameters are mandatory for clustered applications (job types CICS/MRO and CICSplex; IMS/TM and IMSplex; and UTM) or for those jobs that have been explicitly defined to be managed by the Adabas System Coordinator daemon. Either type can be identified by the fact that they have the parameter Managed by Daemon set to Y.
Parameter | Description |
---|---|
System Coordinator Group Name | Used to link the clustered application to the relevant Adabas System Coordinator group. |
Clustered Application Service Name | Used to group together all instances of the application with the Adabas System Coordinator. |
Manage Terminal Sessions or Manage All Sessions | Used to determine the type of sessions that will be managed by the Adabas System Coordinator daemon. |
Refer to the Adabas System Coordinator documentation for more information.