This statement changes the number and attributes of the service tasks.
Scope of validity
DBH administration
See also
DBH option SERVICE-TASKS on "SERVICE-TASKS"
Function
You use the MODIFY-SERVICE-TASKS statement to change the number and attributes of the service tasks which may be started during a session.
Information about the utilization of the service tasks in the current session is provided by the SESAM/SQL utility routine SESMON in the SERVICE TASKS form (see "DBH form SERVICE TASKS").
MODIFY-SERVICE-TASKS | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Operands
INITIAL = *UNCHANGED / *STD / <integer 0..32>
Minimum number of service tasks which should exist. If fewer service tasks exist, additional ones are started until this value is reached. If you specify *STD the default value of the DBH option (one service task) is assumed. In the case of a linked-in DBH this parameter is ignored.
MAXIMUM = *UNCHANGED / *STD / <integer 1..64>
Maximum number up to which further service tasks may be started during the DBH session. If more service tasks already exist, the next service task is started only when this value is fallen below. If you specify *STD the default value of the DBH option (see "SERVICE-TASKS") is assumed. In the case of a linked-in DBH this parameter is ignored.
Note that if MAXIMUM is reduced without changing the attributes for service tasks it may initially not be possible to start any service tasks because more than the maximum number of service tasks are running. These are not terminated prematurely by SESAM/SQL.
Note that if MAXIMUM is reduced and the attributes for service tasks are changed the running service tasks can only be terminated after the request has terminated. This can mean that initially no service tasks with the new attributes can be started. See also the note on "MODIFY-SERVICE-TASKS".
JOBCLASS = *UNCHANGED / *STD / *DBH-JOBCLASS / <name 1..8>
Name of the BS2000 job class.
When *STD is specified the batch job is to run in the standard job class. The standard job class is the default job class for batch jobs of the DBH identifier. It is taken from the JOIN entry of the user ID. When *DBH-JOBCLASS is specified the name of the BS2000 job class is the job class of the DBH when the service task is started, provided the DBH is started as a batch job. In interactive mode the specification of *DBH-JOBCLASS is ignored and the procedure is the same as for JOBCLASS=*STD.
WORK-FILES = *UNCHANGED / *STD / *PUBLIC-DISK(...) / *PRIVATE-DISK(...)
Temporary SORT work files which are generated within a service task are created before each sort run and deleted after it. If you specify *STD the default value of the DBH option (see "SERVICE-TASKS") is assumed.
WORK-FILES = *PUBLIC-DISK(...)
Temporary SORT work files are stored on a public disk.
CAT-ID = *UNCHANGED / *STD / <cat-id>
Catalog ID of the pubset on which the temporary SORT work files are to be stored. The default is the DBH catalog ID.
PRIMARY-ALLOCATION = *UNCHANGED / *STD / <integer 1..16777215>
Number of PAM pages for the initial allocation of memory space. The default value is 120.
SECONDARY-ALLOCATION = *UNCHANGED / *STD / <integer 1..32767>
Number of PAM pages for subsequent extensions to files The default value is 120.
WORK-FILES = *PRIVATE-DISK(...)
Temporary SORT work files are stored on a private disk.
CAT-ID = *UNCHANGED / *STD / <cat-id>
Catalog ID of the pubset on which the temporary SORT work files are to be stored. The default is the DBH catalog ID.
PRIMARY-ALLOCATION = *UNCHANGED / *STD / <integer 1..16777215>
Number of PAM pages for the initial allocation of memory space. The default value is 120.
SECONDARY-ALLOCATION = *UNCHANGED / *STD / <integer 1..32767>
Number of PAM pages for subsequent extensions to files The default value is 120.
DEVICE-TYPE = <structured-name 1..8>
BS2000 device type to which the required disks are assigned. If you make an incorrect entry, the system prompts you in interactive mode to make the entry again (see the device type table in the BS2000 manual “ Commands”).
VOLUME = list-poss(6): <alphanum-name 1..6>
VSNs of the disks on which the file is to be created. Up to 6 VSNs are permitted, each of which can be specified only once. VOLUME is not evaluated unless the DEVICE parameter is specified.
RECORDS-PER-CYCLE = *UNCHANGED / *STD / <integer 1..2147483647>
Number of records to be sorted per cycle by a sort subtask during multitask sorting. SESAM/SQL passes this value to the BS2000 utility SORT in the CYCLE parameter (see also the SORT manual “ SDF Format”). The “ Performance” manual describes the criteria on the basis of which the RECORDS-PER-CYCLE value should be assigned. The total number of records to be sorted divided by CYCLE is the optimal number of work files to be created. However, no more than 9 temporary work files can be created. The number of work files determines the number of sort subtasks started by the SORT utility (number of sort subtasks = number of work files minus 1). In single-task sorting, work files are not created unless one of the following parameters is specified: CAT-ID, PRIMARY-ALLOCATION or DEVICE-TYPE.
*STD means that the DBH does not use the multitask sorting facility.
MAIL = *UNCHANGED / *NONE / *ALL / *ERROR
Controls the output of information by email.
MAIL = *NONE
The information is not sent by email.
MAIL = *ALL
When the service task terminates its SYSLST file is sent by email to the address which is entered in the MAIL parameter file (see "Sending important information of the DBH session by email"). The MAIL parameter file must have been assigned with the link name SESMAIL when the DBH started.
“SYSLST (SVT, TSN=<tsn of the service task>” is entered under “Subject:”.The sender is the sender address entered in the MAIL parameter file under “SENDER=”. The SYSLST file is attached to the email.
MAIL = *ERROR
Only if the server task terminates with an error its SYSLST file is sent by email to the address which is entered in the MAIL parameter file (see "Sending important information of the DBH session by email") eingetragen ist. The MAIL parameter file must have been assigned with the link name SESMAIL when the DBH started.
“SYSLST (SVT, TSN=<tsn of the service task>” is entered under “Subject:”. The sender is the sender address entered in the MAIL parameter file under “SENDER=”. The SYSLST file is attached to the email.
Administration command in ISP format and at the CALL DML interface
The OPT,SVT administration command corresponds to the MODIFY-SERVICE-TASKS administration statement here.
OPT,SVT[,{INI[TIAL]-STD | INI[TIAL]=m}][,{MAX[IMUM]-STD | MAX[IMUM]=n}]
[,J[OB]-C[LASS]={STD|DBH|(name)}][,R[ECORDS]-P[ER]-C[YCLE]=r]
[,{W[ORK-FILE]-STD|file-spec}][,MAIL={NONE | ALL | ERROR}]
file-spec ::= W[ORK-FILE]-V[OL]=(vsn)[,D[EV]=device]
[,S[PACE]-P[RIMARY]=space][,S[PACE]-S[ECONDARY]=space]
[,{C[ATID]-STD | C[ATID]=cat-id}]
At least one parameter must be specified. If a parameter is not specified, its setting remains unchanged.
The values defined beforehand for the relevant operands may be entered for m, n, r, name, vsn, device, space and cat-id.
When WORK-FILE-STD is entered, the default values defined beforehand for the relevant operands are used for the file.
The MAIL parameters are described under the MAIL operand.
Multiple volumes vsn for the work file are specified separated by commas.
If the work file is to reside on a public volume, the word PUBLIC (with or without parentheses) is specified in place of (vsn).
space is used to specify the values for PRIMARY- and SECONDARY-ALLOCATION. If 0 is specified, the default value of the DBH is set for these parameters, as it is for WORKFILE-STD.
The default catalog ID of the DBH is selected with CATID-STD.
In INFORM-PROGRAM administration you must adhere to the permissible length for filespec (see section “Administration using INFORM-PROGRAM”).