FABADA5 THRCTL DD data set

Syntax of the control statement

FABADA5 may require one control statement.

Keywords and the associated values can be coded in free format (columns 1 - 72), provided certain syntactical coding rules are followed:

1. The keyword and its value must be on one control statement.
2. If specification of a keyword value is required, the keyword must be separated from its associated value by an equal sign. The equal sign must not be preceded by blanks, but can be followed by one or more blanks. The value must be separated from the next keyword by a blank, a comma, or a comma followed by one or more blanks.
3. For keywords that do not have associated values, the keyword must be separated from the next keyword by a blank, a comma, or a comma followed by one or more blanks.
4. In case of duplicate keywords, the last one coded is used.

Format

This control-statement data set usually resides in the input stream. However, it can also be defined as a sequential data set or as a member of a partitioned data set. It must contain 80-byte fixed-length records. Block size, if coded, must be a multiple of 80.

This data set must contain only one control statement. It can be coded as shown in the following figure:

//THRCTL    DD *
T5002 02004 01202 02004 101010 80 02004 20 050050050 101010 1010
/*

Record format

There is only one record type in the THRCTL file:

• The control statement is optional.
• Only 1 control statement is used. If multiple statements are provided, only the first statement is used. The additional statements are ignored.
• If a control statement is present, it must contain a "T" in position 1.
• All threshold parameter values are optional (that is, they can be blank).
• Only non-blank threshold parameter values are tested.
• Threshold parameters can be used to monitor the following:
  1. Synonym Chain Length:
     • xx% of the synonym chains are > yy in length.
     • average length > xx.x
     • maximum length > yy
  2. Root I/O:
     • average I/O > xx.x
     • maximum I/O > yy
  3. Record I/O:
     • average I/O > xx.x
     • maximum I/O > yy
  4. Overflow usage:
     • available IOVF CIs < xx%
     • RAP CIs using overflow > xx%
     • UOWs using DOVF > xx%
     • UOWs using IOVF > yy%
     • number of IOVF CIs used by a UOW
       • average > xx.x
       • maximum > yy
     • number of records using IOVF CIs > xx%
  5. Percent free space:
     • total RAA BASE free space < xx%
     • total DOVF free space < yy%
     • total IOVF free space < zz%
  6. Free space relationships:
     • RAA BASE > xx% and DOVF< yy% or IOVF < zz%
     • DOVF > xx% and IOVF < yy%

The format of the threshold parameter control statement is as follows:

POSITION

DEFINITION

1

T is a mandatory value.

2 - 5

xxyy - Synonym Chain Length

xx

The percentage of the synonym chains that exceed the specified length. The maximum value is 99, and the minimum value is 0.

yy

The default length of the maximum chain value is 40. The maximum value is 99, and the minimum value is 0. The value must be less than the value that is specified by SYNTBL in the PARMCTL DD data set.

Both values must be present. A warning message is issued if xx% of the synonym chains exceed length yy.

6

Not used.

7 - 9

xxx - Average Synonym Chain Length. There is an implied decimal point before the third digit. A warning message is issued if the average synonym chain length is greater than xx.x. The maximum value is 999, and the minimum value is 0.

10 - 11

xx - Maximum Synonym Chain Length. A warning message is issued if the maximum synonym chain length is greater than xx. The maximum value is 99, and the minimum value is 0.

12

Not used.

13 - 15

xxx - Average Root I/O. There is an implied decimal point before the third digit. A warning message is issued if the average number of I/O to access a root segment is greater than xx.x. The maximum value is 999, and the minimum value is 0.

16 - 17

xx - Maximum Root I/O. A warning message is issued if the maximum number of I/O to access a root segment is greater than xx. The maximum value is 99, and the minimum value is 0.

18

Not used.

19 - 21

xxx - Average Record I/O. There is an implied decimal point before the third digit. A warning message is issued if the average number of I/O to access a database record is greater than xx.x. The maximum value is 999, and the minimum value is 0.

22 - 23

xx - Maximum Record I/O. A warning message is issued if the maximum number of I/O to access a database record is greater than xx. The maximum value is 99, and the minimum value is 0.

24

Not used.

25 - 26

xx - Percentage of RAA BASE CIs that use either DOVF or IOVF. A warning message is issued if the percentage of RAA BASE CIs that use overflow is greater than xx%. The maximum value is 99, and the minimum value is 0.

27 - 28

xx - Percentage of UOWs that use DOVF. A warning message is issued if the percentage of UOWs that use DOVF is greater than xx%. The maximum value is 99, and the minimum value is 0.

29 - 30

xx - Percentage of UOWs using IOVF. A warning message is issued if the number of UOWs using IOVF is greater than xx% of the total UOWs. The maximum value is 99, and the minimum value is 0.

31

Not used.

32 - 33

xx - Percentage of Available IOVF CIs. A warning message is issued if the available IOVF CIs are less than xx% of the total IOVF CIs. The maximum value is 99, and the minimum value is 0.

34

Not used.

35 - 37

xxx - Average Number of IOVF CIs used by UOW. There is an implied decimal point before the third digit. A warning message is issued if the average number of CIs used by a UOW is greater than xx.x. The maximum value is 999, and the minimum value is 0.

38 - 39

xx - Maximum Number of IOVF CIs used by UOW. A warning message is issued if the maximum number of IOVF CIs used by a UOW is greater than xx. The maximum value is 99, and the minimum value is 0.

40

Not used.

41 - 42

xx - Percentage of Records that use IOVF CIs. A warning message is issued if the number of records using IOVF CIs is greater than xx%. The maximum value is 99, and the minimum value is 0.

43

Not used.

44 - 46

xxx - Percentage of the free space in RAA BASE. There is an implied decimal point before the third digit. A warning message is issued if the free space in RAA BASE is less than xxx% of total space. The maximum value is 999, and the minimum value is 0.

47 - 49

xxx - Percentage of the free space in DOVF. There is an implied decimal point before the third digit. A warning message is issued if the free space in DOVF is less than xxx% of total space. The maximum value is 999, and the minimum value is 0.

50 - 52

xxx - Percentage of free space in IOVF. There is an implied decimal point before the third digit. A warning message is issued if the free space in IOVF is less than xxx% of total space. The maximum value is 999, and the minimum value is 0.

53

Not used.

54 - 59

xxyyzz - Free space relationships between RAA BASE, DOVF, and IOVF.

xx

The percentage of free space in RAA BASE. The maximum value is 99, and the minimum value is 0.

yy

The percentage of free space in DOVF. The maximum value is 99, and the minimum value is 0.

zz

The percentage of free space in IOVF. The maximum value is 99, and the minimum value is 0.

A value for xx must be present. Either yy or zz must be present. Both yy and zz may be present.

A warning message is issued under the following conditions:

• When RAA BASE free space is greater than xx% and DOVF free space is less than yy%.
• When RAA BASE free space is greater than xx% and IOVF free space is less than zz%.

60

Not used.

61 - 64

xxyy - Free space relationship between DOVF and IOVF.

xx

The percentage of free space in DOVF. The maximum value is 99, and the minimum value is 0.

yy

The percentage of free space in IOVF. The maximum value is 99, and the minimum value is 0.

Both values must be present. A warning message is issued if the DOVF free space is greater than xx% and if the IOVF free space is less than yy%.

65 - 72

Not used.