DBOPT

Purpose

Use this statement to support Tivoli® Dynamic Workload Console reporting. It provides the information required to connect to the database and store data. The information is used by the Java program that populates the history tables and by the server that provides the URL information to Tivoli Dynamic Workload Console process.

Format

>>-DBOPT--+---------------------------+------------------------->
          |                .-10---.   |
          '-CLEANUPPOLICY(-+-days-+-)-'
 
>--+--------------------------+--------------------------------->
   |                .-150-.   |
   '-LONGDURPOLICY(-+-nnn-+-)-'
 
>--+----------------------------+--+--------------+------------->
   '-SMOOTHPOLICY(-percentage-)-'  '-DBURL(-url-)-'
 
>--+------------------+--+-------------------+------------------>
   '-DBUSER(-userid-)-'  '-DBPSW(-password-)-'
 
>--+-----------------------------+------------------------------>
   '-TIMEZONE(-timezone_string-)-'
 
>--+--------------------------------------+--------------------->
   |           .-IBM – 037------------.   |
   '-CODEPAGE(-+-host system codepage-+-)-'
 
>--+-------------------------+---------------------------------->
   |             .-0-----.   |
   '-TRACELEVEL(-+-level-+-)-'
 
>--+-----------------------------+-----------------------------><
   '-WRKDIR(-working directory-)-'

Parameters

CLEANUPPOLICY (days|10)

The number of days for which the historical run data is kept in the database. Data older than the number of days specified is deleted. The default value is 10 days.

LONGDURPOLICY (nnn|150)

The policy used to decide if a job is a long duration job, based on the formula: AD >= (ED * LDP / 100) where the variables indicate the following:

AD: The actual duration.
ED: The estimated duration.
LPD: The long duration policy.

Specify a value in the range 100 to 999. The default value is 150.

SMOOTHPOLICY (percentage)

The policy used to calculate the average duration of a job. It sets the weighting factor that favors the most recent job run, when calculating the average duration for a job. This is expressed as a percentage. For example, a value of 40 applies a weighting factor of 40% to the most recent job run, and 60% to the existing average.

If you do not set this parameter, the smoothing is not used and the average duration is calculated as the total elapsed time divided by the number of successful runs.

DBURL (url)

Information about the URL, in the following format:

jdbc:db2://server:port/database

where the variables indicate the following:

server: The TCP/IP address or host name of the system where the database resides.
port: The SQL port number used by the DB2® server.
database: The name of the target database.

This parameter is required and does not have a default value.

DBUSER (userid)

The user ID to access the database. This parameter is required and does not have a default value.

DBPSW (password)

The password associated with the user set in DBUSER. To avoid leaving the password in plaintext, you can have it encrypted. For details about how to encrypt the password, see Managing the Workload.

The password can be long up to 15 characters. This limit ensures that the password will continue to fit on one line after it is encrypted.

This parameter is required and does not have a default value.

TIMEZONE (timezone_string)

The local time zone of the z/OS® system where the controller runs, for example TIMEZONE('Europe/Rome'). It is the format used in standard zoneinfo files at distributed side. Do not specify the time zone in a three-letter format, because this results in an incorrect time zone from Java APIs during daylight saving time.

This parameter is required and does not have a default value.

CODEPAGE (host system codepage|IBM–037)

The name of the host code page, used by the archiving process. You can provide the IBM®–nnn value, where nnn is the EBCDIC code page. The default value, IBM–037, defines the EBCDIC code page for US English, Portuguese, and Canadian French. The following is a list of the EBCDIC code pages:

IBM–939: Japan Extended
IBM-937: Taiwan
IBM–935: China
IBM–933: Korea
IBM–975: Greece
IBM–971: Iceland
IBM–970: Latin 2
IBM–838: Thai
IBM-500: International
IBM–424: Israel
IBM–297: France
IBM–285: UK
IBM–284: Spain - Latin America
IBM-280: Italy
IBM–278: Sweden - Finland
IBM–277: Denmark - Norway
IBM–274: Belgium
IBM–273: Germany
IBM–1388: China
IBM–1122: Estonia
IBM–1112: Baltic
IBM–1047: Open Systems
IBM–1026: Latin 5 (Turkey)
IBM–1025: Cyrillic

The following is a list of the EBCDIC code pages for EURO support:

IBM-1140: Finland, Sweden
IBM-1141: Austria, Germany
IBM-1142: Denmark, Norway
IBM-1143: USA
IBM-1144: Italy
IBM-1145: Spain, spanish-speaking Latin America
IBM-1146: UK
IBM-1147: France
IBM-1148: Belgium, Switzerland

TRACELEVEL (level|0)

Trace level for internal logging and traces. Possible values are:

0: To receive error messages only.
1: To receive error and warning messages.
2: To receive error, warning, and informational messages.
3: Indicates the fine level, to receive the most important messages with the lowest volume.
4: Indicates the finer level, to activate entry and exit traces.
5: Indicates the finest level, to receive the most detailed tracing output.

The default value is 0.

WRKDIR (working directory)

The complete path of the working directory for the archiving process. Each subsystem must have its own working directory. You can use the same working directory used for end-to-end scheduling with fault tolerance capabilities. This parameter is required and does not have a default value.

Run EQQPCS08 to customize the content of the working directory.

This parameter is required and does not have a default value.