Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Appendix D Database Definition Parameters : Database Parameters

Database Parameters
Modify DBJCL
Modify the following parameters in DBJCL to reflect your site’s requirements.
DBSET and DB Macros
These two Macros are used together to define the Data Object Broker data sets and Segment data sets. The DBSET Macro define global parameters and the DB Macro define local parameters that override the same DBSET parameters. Each invocation of the DBSET Macro reestablishes the global parameters.
DBSET Macro
DBSET parameters define the global data set name qualifiers as described in the following table. All z/OS data set naming conventions apply: the maximum data set name length is forty-four characters and no qualifier can exceed eight characters. The total length of all specified qualifiers cannot exceed thirty-five characters. The Q1= to Q6= keywords must be specified without omitting a lower value. For example, if you specify Q4=, you must specify Q1=, Q2=, and Q3=.
 
NAME= is used as the Segment name when TYPE=PAGE specified and used in the data set name generation following Q1= if Q2= not specified. The maximum length is eight and you can specify NAME= or SEGNAME= but not both.
First dsname qualifier or string of qualifiers separated by periods. Each qualifier cannot exceed eight characters, periods not included.
Second dsname qualifier or string of qualifiers separated by periods. Each qualifier cannot exceed eight characters, periods not included.
SEGNAME= is used as the Segment name when TYPE=PAGE specified and used in the data set name generation following Q1= if Q2= not specified. The maximum length is eight and you can specify NAME= or SEGNAME= but not both.
DB Macro
The DB Macro describes individual Data Object Broker data sets and Segments. The parameters specified on the DB Macro override the parameters specified on the DBSET Macro.
 
The maximum number of Pagestore data sets in a segment. The default is 1. This parameter is valid for PAGE and JOURNAL data sets. The base segment requires a minimum value of 3. Journals require a minimum value of 2 and can have as many as 255 data sets. The maximum value for PAGE data sets is128.
LOGICAL – A freed page is not to be journaled and not to be written back to the Pagestore data set. This is the default.
Specifies the numeric ID of the segment being defined. Default is 0 for the base segment. Each segment must have a numeric ID specified, and it must be unique amongst all the segments. In the sample, segment 1 has a value of 1. Valid range is 0-255.
Specifies if the segment is to be allocated and opened during Data Object Broker initialization (Y or N). Default is Y. Code N to request the segment not be opened during Data Object Broker initialization. If the Data Object Broker is restarted after an abnormal termination, the value of INIT at the time of termination applies.
Specifies if updates to data within a segment should be journaled by the Data Object Broker (Y or N). This parameter is valid for page data sets only. Default is Y.
Use this parameter to restrict write access to any segment other than segment 0 by setting MODE=RO. Absence of this parameter sets the segment for full read and write access. You can also explicitly specify full access to the segment by MODE=RW.
Second dsname qualifier when defining PAGE data sets specified by the TYPE=PAGE keyword. NAME= replaces Q2= if Q2 is not specified. The maximum length is eight characters. You can specify NAME= or SEGNAME= but not both.
First dsname qualifier or string of qualifiers separated by periods. Each qualifier cannot exceed eight characters, periods not included.
Second dsname qualifier or string of qualifiers separated by periods. Each qualifier cannot exceed eight characters, periods not included.
Name of segment when defining PAGE data sets specified by the TYPE=PAGE keyword. SEGNAME+ replaces Q2= if Q2 is not specified. The maximum length is eight characters. You can specify NAME= or SEGNAME= but not both.
This optional parameter, when set as SYSTEM=Y, designates the segment as a required segment. As the Data Object Broker initializes, it checks for required segments and does not come up if any required segment is inaccessible. After Data Object Broker initialization, a required segment cannot be taken offline.
Defines the number of concurrent I/Os supported per page data set within a segment. If this parameter specifies a value greater than the Data Object Broker MAXVSAMC parameter, the MAXVSAMC parameter value is used. Refer to TIBCO Object Service Broker Parameters for a description of this parameter.
When space usage of a segment reaches a minimum threshold—percentage full—the system sends an initial warning message and enables subsequent warning messages to appear. Valid Values: 40 to 100, in increments of 5. Default is 80. Related Parameter is WARNRATE.
When the segment WARN limit is reached, the system issues more warning messages indicating that the segment could be running out of disk space. A warning is sent out whenever space usage reaches a multiple of the WARNRATE percentage full increment. Valid Values: 5 to 20, in increments of 5, Default is 5. Related Parameter is WARN.
For example, if WARN=85 and WARNRATE=5, an initial warning message appears when the segment reaches 85% usage of its total capacity. Subsequent messages are sent out at 90% (85% + 5%), 95%(85% + 2 * 5%), and so on.
Netview alerts can be used to immediately identify full segments and recommend action to operations staff. For more information, refer to Chapter 15, TIBCO Object Service Broker Netview Support.
Option
 
DBGEN Macro
The DBGEN macro defines the end of the database definitions. When this macro is encountered, the database definition is generated if all parameters are specified correctly.
See Also
TIBCO Object Service Broker Application Administion for more information about creating additional segments.
TIBCO Object Service Broker Shareable Tools for more information about UTCDATE and UTCTIME.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved